DBA Data[Home] [Help]

APPS.CE_BAT_UTILS dependencies on CE_PAYMENT_TRANSACTIONS

Line 7: G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;

3:
4:
5: G_spec_revision VARCHAR2(1000) := '$Revision: 120.10 $';
6:
7: G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;
8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;

Line 8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;

4:
5: G_spec_revision VARCHAR2(1000) := '$Revision: 120.10 $';
6:
7: G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;
8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;

Line 9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;

5: G_spec_revision VARCHAR2(1000) := '$Revision: 120.10 $';
6:
7: G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;
8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;

Line 10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;

6:
7: G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;
8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;

Line 11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;

7: G_trxn_reference_number CE_PAYMENT_TRANSACTIONS.trxn_reference_number%type;
8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;

Line 12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;

8: G_trxn_subtype_code_id CE_PAYMENT_TRANSACTIONS.trxn_subtype_code_id%type;
9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;

Line 13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;

9: G_transaction_date CE_PAYMENT_TRANSACTIONS.transaction_date%type;
10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;

Line 14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;

10: G_anticipated_value_date CE_PAYMENT_TRANSACTIONS.anticipated_value_date%type;
11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;

Line 15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;

11: G_transaction_desc CE_PAYMENT_TRANSACTIONS.transaction_description%type;
12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;

Line 16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;

12: G_payment_curr_code CE_PAYMENT_TRANSACTIONS.payment_currency_code%type;
13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;

Line 17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;

13: G_payment_amount CE_PAYMENT_TRANSACTIONS.payment_amount%type;
14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;

Line 18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;

14: G_source_party_id CE_PAYMENT_TRANSACTIONS.source_party_id%type;
15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;

Line 19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;

15: G_source_le_id CE_PAYMENT_TRANSACTIONS.source_legal_entity_id%type;
16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;

Line 20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;

16: G_source_bank_acct_id CE_PAYMENT_TRANSACTIONS.source_bank_account_id%type;
17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;

Line 21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;

17: G_dest_party_id CE_PAYMENT_TRANSACTIONS.destination_party_id%type;
18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;
25:

Line 22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;

18: G_dest_le_id CE_PAYMENT_TRANSACTIONS.destination_legal_entity_id%type;
19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;
25:
26: G_payment_request_id CE_PAYMENT_TRANSACTIONS.payment_request_number%TYPE;

Line 23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;

19: G_dest_bank_acct_id CE_PAYMENT_TRANSACTIONS.destination_bank_account_id%type;
20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;
25:
26: G_payment_request_id CE_PAYMENT_TRANSACTIONS.payment_request_number%TYPE;
27:

Line 24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;

20: G_created_from_dir CE_PAYMENT_TRANSACTIONS.created_from_dir%type;
21: G_created_from_stmtline_id CE_PAYMENT_TRANSACTIONS.create_from_stmtline_id%type;
22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;
25:
26: G_payment_request_id CE_PAYMENT_TRANSACTIONS.payment_request_number%TYPE;
27:
28:

Line 26: G_payment_request_id CE_PAYMENT_TRANSACTIONS.payment_request_number%TYPE;

22: G_bank_trxn_number CE_PAYMENT_TRANSACTIONS.bank_trxn_number%type;
23: G_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%type;
24: G_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%type;
25:
26: G_payment_request_id CE_PAYMENT_TRANSACTIONS.payment_request_number%TYPE;
27:
28:
29: FUNCTION spec_revision RETURN VARCHAR2;
30: