DBA Data[Home] [Help]

APPS.AR_PMT_PROCESS_WRAPPER dependencies on AR_CASH_RECEIPTS

Line 14: cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE,

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,

Line 17: cust_bank_account_id ar_cash_receipts.customer_bank_account_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:

Line 19: pay_from_customer ar_cash_receipts.pay_from_customer%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:
22: /*--------------------------------------------------------------------------
23: | This record contains all the parameters that are required to by iPayments

Line 20: site_use_id ar_cash_receipts.customer_site_use_id%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
24: | Authorize API IBY_Payment_Adapter_pub.OraPmtReq.

Line 32: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,

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' ,

Line 33: receipt_amount ar_cash_receipts.amount%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' ,
37: auth_TYPE VARCHAR2(80) DEFAULT 'AUTHONLY',

Line 34: receipt_number ar_cash_receipts.receipt_number%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',
38: unique_reference ar_cash_receipts.unique_reference%type

Line 35: currency_code ar_cash_receipts.currency_code%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: );

Line 38: unique_reference ar_cash_receipts.unique_reference%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: );
40:
41: /*--------------------------------------------------------------------------
42: | This record contains the output record returned by iPayments

Line 53: payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE,

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: );

Line 54: receipt_amount ar_cash_receipts.amount%TYPE,

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:

Line 55: currency_code ar_cash_receipts.currency_code%TYPE,

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: /*--------------------------------------------------------------------------

Line 56: TrxnRef ar_cash_receipts.unique_reference%TYPE

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