10: | This is the record to capture the generic information related to a receipt.
11: | This can be useful for any customizations on this API.
12: |-------------------------------------------------------------------------*/
13: TYPE receipt_info_rec IS RECORD (
14: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
15: cr_amount ar_cash_receipt_history.amount%TYPE,
16: cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE,
17: cust_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
18: cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE,
13: TYPE receipt_info_rec IS RECORD (
14: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,
15: cr_amount ar_cash_receipt_history.amount%TYPE,
16: cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE,
17: cust_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
18: cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE,
19: pay_from_customer ar_cash_receipts.pay_from_customer%TYPE,
20: site_use_id ar_cash_receipts.customer_site_use_id%TYPE);
21:
15: cr_amount ar_cash_receipt_history.amount%TYPE,
16: cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE,
17: cust_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
18: cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE,
19: pay_from_customer ar_cash_receipts.pay_from_customer%TYPE,
20: site_use_id ar_cash_receipts.customer_site_use_id%TYPE);
21:
22: /*--------------------------------------------------------------------------
23: | This record contains all the parameters that are required to by iPayments
16: cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE,
17: cust_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
18: cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE,
19: pay_from_customer ar_cash_receipts.pay_from_customer%TYPE,
20: site_use_id ar_cash_receipts.customer_site_use_id%TYPE);
21:
22: /*--------------------------------------------------------------------------
23: | This record contains all the parameters that are required to by iPayments
24: | Authorize API IBY_Payment_Adapter_pub.OraPmtReq.
28: merchant_ref ar_receipt_methods.merchant_ref%TYPE,
29: cus_bank_act_name ap_bank_accounts.bank_account_name%TYPE,
30: cus_bank_act_num ap_bank_accounts.bank_account_num%TYPE,
31: cus_bank_exp_date ap_bank_accounts.inactive_date%TYPE,
32: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
33: receipt_amount ar_cash_receipts.amount%TYPE,
34: receipt_number ar_cash_receipts.receipt_number%TYPE,
35: currency_code ar_cash_receipts.currency_code%TYPE,
36: payment_mode VARCHAR2(30) DEFAULT 'ONLINE' ,
29: cus_bank_act_name ap_bank_accounts.bank_account_name%TYPE,
30: cus_bank_act_num ap_bank_accounts.bank_account_num%TYPE,
31: cus_bank_exp_date ap_bank_accounts.inactive_date%TYPE,
32: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
33: receipt_amount ar_cash_receipts.amount%TYPE,
34: receipt_number ar_cash_receipts.receipt_number%TYPE,
35: currency_code ar_cash_receipts.currency_code%TYPE,
36: payment_mode VARCHAR2(30) DEFAULT 'ONLINE' ,
37: auth_TYPE VARCHAR2(80) DEFAULT 'AUTHONLY',
30: cus_bank_act_num ap_bank_accounts.bank_account_num%TYPE,
31: cus_bank_exp_date ap_bank_accounts.inactive_date%TYPE,
32: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
33: receipt_amount ar_cash_receipts.amount%TYPE,
34: receipt_number ar_cash_receipts.receipt_number%TYPE,
35: currency_code ar_cash_receipts.currency_code%TYPE,
36: payment_mode VARCHAR2(30) DEFAULT 'ONLINE' ,
37: auth_TYPE VARCHAR2(80) DEFAULT 'AUTHONLY',
38: unique_reference ar_cash_receipts.unique_reference%type
31: cus_bank_exp_date ap_bank_accounts.inactive_date%TYPE,
32: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
33: receipt_amount ar_cash_receipts.amount%TYPE,
34: receipt_number ar_cash_receipts.receipt_number%TYPE,
35: currency_code ar_cash_receipts.currency_code%TYPE,
36: payment_mode VARCHAR2(30) DEFAULT 'ONLINE' ,
37: auth_TYPE VARCHAR2(80) DEFAULT 'AUTHONLY',
38: unique_reference ar_cash_receipts.unique_reference%type
39: );
34: receipt_number ar_cash_receipts.receipt_number%TYPE,
35: currency_code ar_cash_receipts.currency_code%TYPE,
36: payment_mode VARCHAR2(30) DEFAULT 'ONLINE' ,
37: auth_TYPE VARCHAR2(80) DEFAULT 'AUTHONLY',
38: unique_reference ar_cash_receipts.unique_reference%type
39: );
40:
41: /*--------------------------------------------------------------------------
42: | This record contains the output record returned by iPayments
49: | This record contains all the parameters that are required to by iPayments
50: | Capture API IBY_Payment_Adapter_pub.OraPmtCapture.
51: |-------------------------------------------------------------------------*/
52: TYPE capture_input_rec IS RECORD (
53: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
54: receipt_amount ar_cash_receipts.amount%TYPE,
55: currency_code ar_cash_receipts.currency_code%TYPE,
56: TrxnRef ar_cash_receipts.unique_reference%TYPE
57: );
50: | Capture API IBY_Payment_Adapter_pub.OraPmtCapture.
51: |-------------------------------------------------------------------------*/
52: TYPE capture_input_rec IS RECORD (
53: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
54: receipt_amount ar_cash_receipts.amount%TYPE,
55: currency_code ar_cash_receipts.currency_code%TYPE,
56: TrxnRef ar_cash_receipts.unique_reference%TYPE
57: );
58:
51: |-------------------------------------------------------------------------*/
52: TYPE capture_input_rec IS RECORD (
53: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
54: receipt_amount ar_cash_receipts.amount%TYPE,
55: currency_code ar_cash_receipts.currency_code%TYPE,
56: TrxnRef ar_cash_receipts.unique_reference%TYPE
57: );
58:
59: /*--------------------------------------------------------------------------
52: TYPE capture_input_rec IS RECORD (
53: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,
54: receipt_amount ar_cash_receipts.amount%TYPE,
55: currency_code ar_cash_receipts.currency_code%TYPE,
56: TrxnRef ar_cash_receipts.unique_reference%TYPE
57: );
58:
59: /*--------------------------------------------------------------------------
60: | This record contains the output record returned by iPayments