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 IBY_PAYMENTS_ALL

Line 71: payer_tax_registration_number IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE, --added by asarada (SEPA Credit Transfer 3.3)

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,
70: payer_registration_number IBY_PP_FIRST_PARTY_V.party_registration_number%TYPE, --added by asarada (SEPA Credit Transfer 3.3)
71: payer_tax_registration_number IBY_PAYMENTS_ALL.payer_tax_registration_num%TYPE, --added by asarada (SEPA Credit Transfer 3.3)
72: ext_bank_num IBY_EXT_BANK_ACCOUNTS_V.bank_number%TYPE,
73: ext_bank_name IBY_EXT_BANK_ACCOUNTS_V.bank_name%TYPE,
74:
75: ext_bank_name_alt CE_BANKS_V.bank_name_alt%TYPE,

Line 169: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,

165: document_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
166: );
167:
168: TYPE paymentRecType IS RECORD (
169: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
170: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
171: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country

Line 170: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,

166: );
167:
168: TYPE paymentRecType IS RECORD (
169: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
170: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
171: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,

Line 171: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,

167:
168: TYPE paymentRecType IS RECORD (
169: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
170: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
171: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
175: pmt_payment_reason_count NUMBER,

Line 172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,

168: TYPE paymentRecType IS RECORD (
169: pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE,
170: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
171: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
175: pmt_payment_reason_count NUMBER,
176: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)

Line 174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,

170: pmt_amount IBY_PAYMENTS_ALL.payment_amount%TYPE,
171: pmt_currency IBY_PAYMENTS_ALL.payment_currency_code%TYPE,
172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
175: pmt_payment_reason_count NUMBER,
176: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
177: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)
178: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)

Line 176: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)

172: pmt_delivery_channel_code IBY_PAYMENTS_ALL.delivery_channel_code%TYPE,
173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
175: pmt_payment_reason_count NUMBER,
176: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
177: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)
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)

Line 177: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)

173: pmt_payer_le_country IBY_PP_FIRST_PARTY_V.party_address_country%TYPE, -- Payer Country
174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
175: pmt_payment_reason_count NUMBER,
176: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
177: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)
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)

Line 178: payer_le_registration_num IBY_PAYMENTS_ALL.PAYER_LE_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)

174: pmt_detail IBY_PAYMENTS_ALL.payment_details%TYPE,
175: pmt_payment_reason_count NUMBER,
176: int_bank_account_iban IBY_PAYMENTS_ALL.int_bank_account_iban%TYPE, -- Payer IBAN (added by sodash)
177: payer_tax_registration_num IBY_PAYMENTS_ALL.PAYER_TAX_REGISTRATION_NUM %TYPE, --(Added by asarada SEPA Credut Transfer 3.3)
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

Line 373: pmt_id IBY_PAYMENTS_ALL.

369: /*
370: * Rejected payment id along with its status.
371: */
372: TYPE rejectedPmtRecType IS RECORD (
373: pmt_id IBY_PAYMENTS_ALL.
374: payment_id%TYPE,
375: pmt_status IBY_PAYMENTS_ALL.
376: payment_status%TYPE
377: );

Line 375: pmt_status IBY_PAYMENTS_ALL.

371: */
372: TYPE rejectedPmtRecType IS RECORD (
373: pmt_id IBY_PAYMENTS_ALL.
374: payment_id%TYPE,
375: pmt_status IBY_PAYMENTS_ALL.
376: payment_status%TYPE
377: );
378:
379: /*

Line 727: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,

723: | NOTES:
724: |
725: *---------------------------------------------------------------------*/
726: PROCEDURE initPaymentData(
727: p_payment_id IN IBY_PAYMENTS_ALL.payment_id%type,
728: x_payment_rec IN OUT NOCOPY paymentRecType
729: );
730:
731: /*--------------------------------------------------------------------