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