59: int_bank_acc_holder_name CE_BANK_ACCOUNTS.account_holder_name%TYPE,
60: int_bank_acc_holder_name_alt
61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62:
63: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
64: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
66:
67: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
60: int_bank_acc_holder_name_alt
61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62:
63: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
64: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
66:
67: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
68: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
61: CE_BANK_ACCOUNTS.account_holder_name_alt%TYPE,
62:
63: payer_le_name IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
64: payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
65: payer_phone IBY_PP_FIRST_PARTY_V.party_phone%TYPE,
66:
67: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
68: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
69:
158: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
159: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
160: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
161: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
162: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
163: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
164: pmt_payment_reason_count NUMBER,
165: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
166: party_address_line1 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE, -- Payer Address Line1 (added by sodash)
162: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
163: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
164: pmt_payment_reason_count NUMBER,
165: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
166: party_address_line1 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE, -- Payer Address Line1 (added by sodash)
167: party_address_city IBY_PP_FIRST_PARTY_V.party_address_city%TYPE, -- Payer City (added by sodash)
168: party_address_postal_code IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE -- Payer Postal Code (added by sodash)
169: );
170:
163: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
164: pmt_payment_reason_count NUMBER,
165: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
166: party_address_line1 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE, -- Payer Address Line1 (added by sodash)
167: party_address_city IBY_PP_FIRST_PARTY_V.party_address_city%TYPE, -- Payer City (added by sodash)
168: party_address_postal_code IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE -- Payer Postal Code (added by sodash)
169: );
170:
171: TYPE instructionRecType is RECORD (
164: pmt_payment_reason_count NUMBER,
165: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
166: party_address_line1 IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE, -- Payer Address Line1 (added by sodash)
167: party_address_city IBY_PP_FIRST_PARTY_V.party_address_city%TYPE, -- Payer City (added by sodash)
168: party_address_postal_code IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE -- Payer Postal Code (added by sodash)
169: );
170:
171: TYPE instructionRecType is RECORD (
172: ins_id IBY_PAY_INSTRUCTIONS_ALL.
419: IBY_DOCUMENT_LINES.po_number%TYPE,
420:
421: /* PAYER */
422: payer_number
423: IBY_PP_FIRST_PARTY_V.party_number%TYPE,
424: payer_name
425: IBY_PP_FIRST_PARTY_V.party_name%TYPE,
426: payer_legal_name
427: IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
421: /* PAYER */
422: payer_number
423: IBY_PP_FIRST_PARTY_V.party_number%TYPE,
424: payer_name
425: IBY_PP_FIRST_PARTY_V.party_name%TYPE,
426: payer_legal_name
427: IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
428: payer_tax_id
429: IBY_PP_FIRST_PARTY_V.party_tax_id%TYPE,
423: IBY_PP_FIRST_PARTY_V.party_number%TYPE,
424: payer_name
425: IBY_PP_FIRST_PARTY_V.party_name%TYPE,
426: payer_legal_name
427: IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
428: payer_tax_id
429: IBY_PP_FIRST_PARTY_V.party_tax_id%TYPE,
430: payer_add1
431: IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE,
425: IBY_PP_FIRST_PARTY_V.party_name%TYPE,
426: payer_legal_name
427: IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
428: payer_tax_id
429: IBY_PP_FIRST_PARTY_V.party_tax_id%TYPE,
430: payer_add1
431: IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE,
432: payer_add2
433: IBY_PP_FIRST_PARTY_V.party_address_line2%TYPE,
427: IBY_PP_FIRST_PARTY_V.party_legal_name%TYPE,
428: payer_tax_id
429: IBY_PP_FIRST_PARTY_V.party_tax_id%TYPE,
430: payer_add1
431: IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE,
432: payer_add2
433: IBY_PP_FIRST_PARTY_V.party_address_line2%TYPE,
434: payer_add3
435: IBY_PP_FIRST_PARTY_V.party_address_line3%TYPE,
429: IBY_PP_FIRST_PARTY_V.party_tax_id%TYPE,
430: payer_add1
431: IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE,
432: payer_add2
433: IBY_PP_FIRST_PARTY_V.party_address_line2%TYPE,
434: payer_add3
435: IBY_PP_FIRST_PARTY_V.party_address_line3%TYPE,
436: payer_city
437: IBY_PP_FIRST_PARTY_V.party_address_city%TYPE,
431: IBY_PP_FIRST_PARTY_V.party_address_line1%TYPE,
432: payer_add2
433: IBY_PP_FIRST_PARTY_V.party_address_line2%TYPE,
434: payer_add3
435: IBY_PP_FIRST_PARTY_V.party_address_line3%TYPE,
436: payer_city
437: IBY_PP_FIRST_PARTY_V.party_address_city%TYPE,
438: payer_county
439: IBY_PP_FIRST_PARTY_V.party_address_county%TYPE,
433: IBY_PP_FIRST_PARTY_V.party_address_line2%TYPE,
434: payer_add3
435: IBY_PP_FIRST_PARTY_V.party_address_line3%TYPE,
436: payer_city
437: IBY_PP_FIRST_PARTY_V.party_address_city%TYPE,
438: payer_county
439: IBY_PP_FIRST_PARTY_V.party_address_county%TYPE,
440: payer_state
441: IBY_PP_FIRST_PARTY_V.party_address_state%TYPE,
435: IBY_PP_FIRST_PARTY_V.party_address_line3%TYPE,
436: payer_city
437: IBY_PP_FIRST_PARTY_V.party_address_city%TYPE,
438: payer_county
439: IBY_PP_FIRST_PARTY_V.party_address_county%TYPE,
440: payer_state
441: IBY_PP_FIRST_PARTY_V.party_address_state%TYPE,
442: payer_country
443: IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
437: IBY_PP_FIRST_PARTY_V.party_address_city%TYPE,
438: payer_county
439: IBY_PP_FIRST_PARTY_V.party_address_county%TYPE,
440: payer_state
441: IBY_PP_FIRST_PARTY_V.party_address_state%TYPE,
442: payer_country
443: IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
444: payer_postcode
445: IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE,
439: IBY_PP_FIRST_PARTY_V.party_address_county%TYPE,
440: payer_state
441: IBY_PP_FIRST_PARTY_V.party_address_state%TYPE,
442: payer_country
443: IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
444: payer_postcode
445: IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE,
446:
447: /* PAYER BANK */
441: IBY_PP_FIRST_PARTY_V.party_address_state%TYPE,
442: payer_country
443: IBY_PP_FIRST_PARTY_V.party_address_country%TYPE,
444: payer_postcode
445: IBY_PP_FIRST_PARTY_V.party_address_postal_code%TYPE,
446:
447: /* PAYER BANK */
448: payer_bank_name
449: CE_BANK_BRANCHES_V.bank_name%TYPE,