eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_VALIDATIONSETS_PUB dependencies on CE_BANK_ACCOUNTS

Line 50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,

46: int_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE,
47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,

Line 51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,

47: int_bank_branch_name_alt CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,

Line 52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,

48: int_bank_branch_type CE_BANK_BRANCHES_V.bank_branch_type%TYPE, -- bug 16007784
49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,
56: int_bank_assigned_id1 VARCHAR2(240),

Line 53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,

49:
50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,
56: int_bank_assigned_id1 VARCHAR2(240),
57: int_bank_assigned_id2 VARCHAR2(240),

Line 54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,

50: int_bank_acc_num CE_BANK_ACCOUNTS.bank_account_num%TYPE,
51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,
56: int_bank_assigned_id1 VARCHAR2(240),
57: int_bank_assigned_id2 VARCHAR2(240),
58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,

Line 55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,

51: int_bank_acc_name CE_BANK_ACCOUNTS.bank_account_name%TYPE,
52: int_bank_acc_name_alt CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
53: int_bank_acc_type CE_BANK_ACCOUNTS.bank_account_type%TYPE,
54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,
56: int_bank_assigned_id1 VARCHAR2(240),
57: int_bank_assigned_id2 VARCHAR2(240),
58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,

Line 58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,

54: int_bank_acc_iban CE_BANK_ACCOUNTS.iban_number%TYPE,
55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,
56: int_bank_assigned_id1 VARCHAR2(240),
57: int_bank_assigned_id2 VARCHAR2(240),
58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
60: int_eft_req_identifier CE_BANK_ACCOUNTS.
61: eft_requester_identifier%TYPE,
62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,

Line 59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,

55: int_bank_acc_curr CE_BANK_ACCOUNTS.currency_code%TYPE,
56: int_bank_assigned_id1 VARCHAR2(240),
57: int_bank_assigned_id2 VARCHAR2(240),
58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
60: int_eft_req_identifier CE_BANK_ACCOUNTS.
61: eft_requester_identifier%TYPE,
62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
63: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,

Line 60: int_eft_req_identifier CE_BANK_ACCOUNTS.

56: int_bank_assigned_id1 VARCHAR2(240),
57: int_bank_assigned_id2 VARCHAR2(240),
58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
60: int_eft_req_identifier CE_BANK_ACCOUNTS.
61: eft_requester_identifier%TYPE,
62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
63: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
64: int_bank_acc_holder_name_alt

Line 62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,

58: int_eft_user_number CE_BANK_ACCOUNTS.eft_user_num%TYPE,
59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
60: int_eft_req_identifier CE_BANK_ACCOUNTS.
61: eft_requester_identifier%TYPE,
62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
63: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
64: int_bank_acc_holder_name_alt
65: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
66:

Line 63: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,

59: int_bank_acc_chk_dgts CE_BANK_ACCOUNTS.check_digits%TYPE,
60: int_eft_req_identifier CE_BANK_ACCOUNTS.
61: eft_requester_identifier%TYPE,
62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
63: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
64: int_bank_acc_holder_name_alt
65: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
66:
67: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,

Line 65: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,

61: eft_requester_identifier%TYPE,
62: int_bank_acc_short_name CE_BANK_ACCOUNTS.short_account_name%TYPE,
63: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
64: int_bank_acc_holder_name_alt
65: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
66:
67: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
68: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
69: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,

Line 103: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,

99: ext_bank_acc_holder_name IBY_EXT_BANK_ACCOUNTS_V.
100: primary_acct_owner_name%TYPE,
101:
102: ext_bank_acc_holder_name_alt
103: CE_BANK_ACCOUNTS_V.bank_account_name_alt%TYPE,
104: ext_eft_swift_code IBY_EXT_BANK_ACCOUNTS_INT_V.eft_swift_code%TYPE, -- Payee BIC (added by sodash)
105:
106: payee_party_name HZ_PARTIES.party_name%TYPE,
107: payee_party_addr1 HZ_LOCATIONS.address1%TYPE,

Line 182: payer_bank_acc_cur_code CE_BANK_ACCOUNTS.currency_code%TYPE -- Internal Bank Account Currency Code

178: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)
179: party_address_line1 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE, -- Payer Address Line1 (added by sodash)
180: party_address_city IBY_PP_FIRST_PARTY_V.party_address_city%TYPE, -- Payer City (added by sodash)
181: party_address_postal_code IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE, -- Payer Postal Code (added by sodash)
182: payer_bank_acc_cur_code CE_BANK_ACCOUNTS.currency_code%TYPE -- Internal Bank Account Currency Code
183: );
184:
185: TYPE instructionRecType is RECORD (
186: ins_id IBY_PAY_INSTRUCTIONS_ALL.

Line 515: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,

511: payer_bank_branch_name_alt
512: CE_BANK_BRANCHES_V.bank_branch_name_alt%TYPE,
513:
514: payer_bank_acct_name_alt
515: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
516: payer_bank_acct_type
517: CE_BANK_ACCOUNTS.bank_account_type%TYPE,
518: payer_bank_assigned_id1
519: VARCHAR2(240),

Line 517: CE_BANK_ACCOUNTS.bank_account_type%TYPE,

513:
514: payer_bank_acct_name_alt
515: CE_BANK_ACCOUNTS.bank_account_name_alt%TYPE,
516: payer_bank_acct_type
517: CE_BANK_ACCOUNTS.bank_account_type%TYPE,
518: payer_bank_assigned_id1
519: VARCHAR2(240),
520: payer_bank_assigned_id2
521: VARCHAR2(240),

Line 523: CE_BANK_ACCOUNTS.eft_user_num%TYPE,

519: VARCHAR2(240),
520: payer_bank_assigned_id2
521: VARCHAR2(240),
522: payer_eft_user_number
523: CE_BANK_ACCOUNTS.eft_user_num%TYPE,
524: payer_eft_req_identifier
525: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
526: payer_bank_acct_short_name
527: CE_BANK_ACCOUNTS.short_account_name%TYPE,

Line 525: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,

521: VARCHAR2(240),
522: payer_eft_user_number
523: CE_BANK_ACCOUNTS.eft_user_num%TYPE,
524: payer_eft_req_identifier
525: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
526: payer_bank_acct_short_name
527: CE_BANK_ACCOUNTS.short_account_name%TYPE,
528: payer_bank_acct_hold_name_alt
529: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,

Line 527: CE_BANK_ACCOUNTS.short_account_name%TYPE,

523: CE_BANK_ACCOUNTS.eft_user_num%TYPE,
524: payer_eft_req_identifier
525: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
526: payer_bank_acct_short_name
527: CE_BANK_ACCOUNTS.short_account_name%TYPE,
528: payer_bank_acct_hold_name_alt
529: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
530: payer_bank_acct_holder_name
531: CE_BANK_ACCOUNTS.account_holder_name%TYPE,

Line 529: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,

525: CE_BANK_ACCOUNTS.eft_requester_identifier%TYPE,
526: payer_bank_acct_short_name
527: CE_BANK_ACCOUNTS.short_account_name%TYPE,
528: payer_bank_acct_hold_name_alt
529: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
530: payer_bank_acct_holder_name
531: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
532: payer_bank_acct_num
533: CE_BANK_ACCOUNTS.bank_account_num%TYPE,

Line 531: CE_BANK_ACCOUNTS.account_holder_name%TYPE,

527: CE_BANK_ACCOUNTS.short_account_name%TYPE,
528: payer_bank_acct_hold_name_alt
529: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
530: payer_bank_acct_holder_name
531: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
532: payer_bank_acct_num
533: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
534: payer_bank_acct_name
535: CE_BANK_ACCOUNTS.bank_account_name%TYPE,

Line 533: CE_BANK_ACCOUNTS.bank_account_num%TYPE,

529: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
530: payer_bank_acct_holder_name
531: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
532: payer_bank_acct_num
533: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
534: payer_bank_acct_name
535: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
536: payer_bank_acct_iban_num
537: CE_BANK_ACCOUNTS.iban_number%TYPE,

Line 535: CE_BANK_ACCOUNTS.bank_account_name%TYPE,

531: CE_BANK_ACCOUNTS.account_holder_name%TYPE,
532: payer_bank_acct_num
533: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
534: payer_bank_acct_name
535: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
536: payer_bank_acct_iban_num
537: CE_BANK_ACCOUNTS.iban_number%TYPE,
538: payer_bank_acct_checkdigits
539: CE_BANK_ACCOUNTS.check_digits%TYPE,

Line 537: CE_BANK_ACCOUNTS.iban_number%TYPE,

533: CE_BANK_ACCOUNTS.bank_account_num%TYPE,
534: payer_bank_acct_name
535: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
536: payer_bank_acct_iban_num
537: CE_BANK_ACCOUNTS.iban_number%TYPE,
538: payer_bank_acct_checkdigits
539: CE_BANK_ACCOUNTS.check_digits%TYPE,
540:
541: /* PAYEE */

Line 539: CE_BANK_ACCOUNTS.check_digits%TYPE,

535: CE_BANK_ACCOUNTS.bank_account_name%TYPE,
536: payer_bank_acct_iban_num
537: CE_BANK_ACCOUNTS.iban_number%TYPE,
538: payer_bank_acct_checkdigits
539: CE_BANK_ACCOUNTS.check_digits%TYPE,
540:
541: /* PAYEE */
542: payee_number
543: HZ_PARTIES.party_number%TYPE,