csh_pos_input.lwm 1.58 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
                begin
                	 pos_txt_upload_pkg.create_trancation(p_trancation_date	     =>to_date(${@trancationDate},'yyyy-mm-dd'),
                                                          p_internal_period_num  =>${@internalPeriodNum},
                                                          p_period_name          =>${@periodName},
                                                          p_transaction_amount   =>${@transactionAmount},
                                                          p_bp_bank_account_num  =>${@bpBankAccountNum},
                                                          p_terminal_number      =>${@terminalNumber},
                                                          p_credit_card_amount   =>${@creditCardAmount},
                                                          p_handling_fee_amount  =>${@handlingFeeAmount},
                                                          p_user_code            =>${@userCode},
                                                          p_contract_number      =>${@contractNumber},
                                                          p_user_id		         =>${/session/@user_id},
                                                          p_company_id	         =>${/session/@company_id});
                end;
            ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>