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_PAYINSTR_PUB dependencies on IBY_PAYMENTS_ALL

Line 94: p_payment_profile_id IN IBY_PAYMENTS_ALL.

90: p_comments IN IBY_PAY_INSTRUCTIONS_ALL.
91: comments%TYPE,
92:
93: /*-- selection criteria --*/
94: p_payment_profile_id IN IBY_PAYMENTS_ALL.
95: payment_profile_id%TYPE,
96: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.
97: calling_app_id%TYPE,
98: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

Line 104: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.

100: %TYPE,
101: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
102: payment_service_request_id
103: %TYPE,
104: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
105: internal_bank_account_id%TYPE,
106: p_payment_currency IN IBY_PAYMENTS_ALL.
107: payment_currency_code%TYPE,
108: p_le_id IN IBY_PAYMENTS_ALL.

Line 106: p_payment_currency IN IBY_PAYMENTS_ALL.

102: payment_service_request_id
103: %TYPE,
104: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
105: internal_bank_account_id%TYPE,
106: p_payment_currency IN IBY_PAYMENTS_ALL.
107: payment_currency_code%TYPE,
108: p_le_id IN IBY_PAYMENTS_ALL.
109: legal_entity_id%TYPE,
110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,

Line 108: p_le_id IN IBY_PAYMENTS_ALL.

104: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
105: internal_bank_account_id%TYPE,
106: p_payment_currency IN IBY_PAYMENTS_ALL.
107: payment_currency_code%TYPE,
108: p_le_id IN IBY_PAYMENTS_ALL.
109: legal_entity_id%TYPE,
110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
111: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
112: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,

Line 110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,

106: p_payment_currency IN IBY_PAYMENTS_ALL.
107: payment_currency_code%TYPE,
108: p_le_id IN IBY_PAYMENTS_ALL.
109: legal_entity_id%TYPE,
110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
111: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
112: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
113: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
114:

Line 111: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,

107: payment_currency_code%TYPE,
108: p_le_id IN IBY_PAYMENTS_ALL.
109: legal_entity_id%TYPE,
110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
111: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
112: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
113: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
114:
115: /*-- single payments / batch flow identifier --*/

Line 112: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,

108: p_le_id IN IBY_PAYMENTS_ALL.
109: legal_entity_id%TYPE,
110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
111: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
112: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
113: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
114:
115: /*-- single payments / batch flow identifier --*/
116: p_single_pmt_flow_flag IN VARCHAR2 DEFAULT 'N',

Line 113: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,

109: legal_entity_id%TYPE,
110: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
111: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
112: p_payment_from_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
113: p_payment_to_date IN IBY_PAYMENTS_ALL.payment_date%TYPE,
114:
115: /*-- single payments / batch flow identifier --*/
116: p_single_pmt_flow_flag IN VARCHAR2 DEFAULT 'N',
117:

Line 174: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction

170: * Since the IBY_PAY_INSTRUCTIONS_ALL table does not contain a payment id,
171: * a separate data structure is needed to keep track of the payments
172: * that are part of a payment instruction. This information is tracked
173: * in the pmtsInInstrTabType table. The rows in pmtsInInstrTabType are
174: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction
175: * ids.
176: *
177: * l_instrTab l_pmtsInInstrTab
178: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)

Line 178: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)

174: * used to update the rows in IBY_PAYMENTS_ALL table with payment instruction
175: * ids.
176: *
177: * l_instrTab l_pmtsInInstrTab
178: * (insert into IBY_PAY_INSTRUCTIONS_ALL) (update IBY_PAYMENTS_ALL)
179: * /--------------------------------------\ /-------------\
180: * |Payment |Payment|..|Instr |Payment|..| |Payment |Pmt |
181: * |Instr Id|Profile|..|Status |Count |..| |Instr Id|Id |
182: * | |Id |..| | |..| | | |

Line 216: prev_pmt_id iby_payments_all.payment_id%TYPE;

212: l_errTokenTab IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType;
213:
214: /* previous payment attributes */
215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
216: prev_pmt_id iby_payments_all.payment_id%TYPE;
217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;

Line 217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;

213:
214: /* previous payment attributes */
215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
216: prev_pmt_id iby_payments_all.payment_id%TYPE;
217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;

Line 218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;

214: /* previous payment attributes */
215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
216: prev_pmt_id iby_payments_all.payment_id%TYPE;
217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;

Line 219: prev_int_bank_acct_id iby_payments_all.

215: prev_ca_id iby_pay_service_requests.calling_app_id%TYPE;
216: prev_pmt_id iby_payments_all.payment_id%TYPE;
217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;

Line 221: prev_org_id iby_payments_all.org_id%TYPE;

217: prev_pmt_currency iby_payments_all.payment_currency_code%TYPE;
218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;

Line 222: prev_org_type iby_payments_all.org_type%TYPE;

218: prev_pmt_amount iby_payments_all.payment_amount%TYPE;
219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;

Line 223: prev_le_id iby_payments_all.legal_entity_id%TYPE;

219: prev_int_bank_acct_id iby_payments_all.
220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

Line 224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;

220: internal_bank_account_id%TYPE;
221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

Line 225: prev_payment_date iby_payments_all.payment_date%TYPE;

221: prev_org_id iby_payments_all.org_id%TYPE;
222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

Line 226: prev_pmt_function iby_payments_all.payment_function%TYPE;

222: prev_org_type iby_payments_all.org_type%TYPE;
223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;

Line 227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

223: prev_le_id iby_payments_all.legal_entity_id%TYPE;
224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;

Line 228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

224: prev_profile_id iby_payments_all.payment_profile_id%TYPE;
225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;

Line 229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

225: prev_payment_date iby_payments_all.payment_date%TYPE;
226: prev_pmt_function iby_payments_all.payment_function%TYPE;
227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
233:

Line 231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;

227: prev_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
233:
234: /* current payment attributes */
235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;

Line 232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;

228: prev_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
229: prev_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
230: prev_rfc_identifier hz_code_assignments.class_code%TYPE;
231: prev_pmt_method_code iby_payments_all.payment_method_code%TYPE;
232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
233:
234: /* current payment attributes */
235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
236: curr_pmt_id iby_payments_all.payment_id%TYPE;

Line 236: curr_pmt_id iby_payments_all.payment_id%TYPE;

232: prev_ppr_id iby_payments_all.payment_service_request_id%TYPE;
233:
234: /* current payment attributes */
235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
236: curr_pmt_id iby_payments_all.payment_id%TYPE;
237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;

Line 237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;

233:
234: /* current payment attributes */
235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
236: curr_pmt_id iby_payments_all.payment_id%TYPE;
237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;

Line 238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;

234: /* current payment attributes */
235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
236: curr_pmt_id iby_payments_all.payment_id%TYPE;
237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;

Line 239: curr_int_bank_acct_id iby_payments_all.

235: curr_ca_id iby_pay_service_requests.calling_app_id%TYPE;
236: curr_pmt_id iby_payments_all.payment_id%TYPE;
237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;

Line 241: curr_org_id iby_payments_all.org_id%TYPE;

237: curr_pmt_currency iby_payments_all.payment_currency_code%TYPE;
238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;

Line 242: curr_org_type iby_payments_all.org_type%TYPE;

238: curr_pmt_amount iby_payments_all.payment_amount%TYPE;
239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;

Line 243: curr_le_id iby_payments_all.legal_entity_id%TYPE;

239: curr_int_bank_acct_id iby_payments_all.
240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

Line 244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;

240: internal_bank_account_id%TYPE;
241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

Line 245: curr_payment_date iby_payments_all.payment_date%TYPE;

241: curr_org_id iby_payments_all.org_id%TYPE;
242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

Line 246: curr_pmt_function iby_payments_all.payment_function%TYPE;

242: curr_org_type iby_payments_all.org_type%TYPE;
243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;

Line 247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;

243: curr_le_id iby_payments_all.legal_entity_id%TYPE;
244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;

Line 248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;

244: curr_profile_id iby_payments_all.payment_profile_id%TYPE;
245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
252: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;

Line 249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;

245: curr_payment_date iby_payments_all.payment_date%TYPE;
246: curr_pmt_function iby_payments_all.payment_function%TYPE;
247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
252: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
253:

Line 251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;

247: curr_pmt_reason_code iby_payments_all.payment_reason_code%TYPE;
248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
252: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
253:
254: l_sql_chunk VARCHAR2(3000);
255: l_cursor_stmt VARCHAR2(8000);

Line 252: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;

248: curr_pmt_reason_commt iby_payments_all.payment_reason_comments%TYPE;
249: curr_prom_note_flag iby_payments_all.bill_payable_flag%TYPE;
250: curr_rfc_identifier hz_code_assignments.class_code%TYPE;
251: curr_pmt_method_code iby_payments_all.payment_method_code%TYPE;
252: curr_ppr_id iby_payments_all.payment_service_request_id%TYPE;
253:
254: l_sql_chunk VARCHAR2(3000);
255: l_cursor_stmt VARCHAR2(8000);
256:

Line 2601: || 'IBY_PAYMENTS_ALL table. Possible data '

2597: /* Normally, this should not happen */
2598: IF (p_pmtsInPayInstTab.COUNT = 0) THEN
2599: print_debuginfo(l_module_name, 'After grouping, no '
2600: || 'payments provided to update '
2601: || 'IBY_PAYMENTS_ALL table. Possible data '
2602: || 'corruption issue.');
2603: RETURN;
2604: END IF;
2605:

Line 2620: IBY_PAYMENTS_ALL

2616: || p_pmtsInPayInstTab(i).pay_instr_id || ', payment: '
2617: || p_pmtsInPayInstTab(i).payment_id);
2618:
2619: UPDATE
2620: IBY_PAYMENTS_ALL
2621: SET
2622: payment_instruction_id = p_pmtsInPayInstTab(i).pay_instr_id,
2623: paper_document_number = p_pmtsInPayInstTab(i).check_number,
2624: payment_status = p_pmtsInPayInstTab(i).payment_status,

Line 2761: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;

2757:
2758:
2759: l_payment_instruction_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE;
2760: l_grp_cntr NUMBER;
2761: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
2762: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
2763:
2764: TYPE type_payment_id IS TABLE OF
2765: IBY_PAYMENTS_ALL.payment_id%TYPE

Line 2765: IBY_PAYMENTS_ALL.payment_id%TYPE

2761: l_logical_group_reference IBY_PAYMENTS_ALL.LOGICAL_GROUP_REFERENCE%TYPE;
2762: l_profileRec IBY_SYS_PMT_PROFILES_B%ROWTYPE;
2763:
2764: TYPE type_payment_id IS TABLE OF
2765: IBY_PAYMENTS_ALL.payment_id%TYPE
2766: INDEX BY BINARY_INTEGER;
2767: t_payment_id type_payment_id;
2768:
2769: TYPE type_logical_group_reference IS TABLE OF

Line 2770: IBY_PAYMENTS_ALL.logical_group_reference%TYPE

2766: INDEX BY BINARY_INTEGER;
2767: t_payment_id type_payment_id;
2768:
2769: TYPE type_logical_group_reference IS TABLE OF
2770: IBY_PAYMENTS_ALL.logical_group_reference%TYPE
2771: INDEX BY BINARY_INTEGER;
2772: t_logical_group_reference type_logical_group_reference;
2773:
2774: TYPE type_legal_entity_id IS TABLE OF

Line 2775: iby_payments_all.legal_entity_id%TYPE

2771: INDEX BY BINARY_INTEGER;
2772: t_logical_group_reference type_logical_group_reference;
2773:
2774: TYPE type_legal_entity_id IS TABLE OF
2775: iby_payments_all.legal_entity_id%TYPE
2776: INDEX BY BINARY_INTEGER;
2777: t_legal_entity_id type_legal_entity_id;
2778:
2779: TYPE type_payment_currency_code IS TABLE OF

Line 2780: iby_payments_all.payment_currency_code%TYPE

2776: INDEX BY BINARY_INTEGER;
2777: t_legal_entity_id type_legal_entity_id;
2778:
2779: TYPE type_payment_currency_code IS TABLE OF
2780: iby_payments_all.payment_currency_code%TYPE
2781: INDEX BY BINARY_INTEGER;
2782: t_payment_currency_code type_payment_currency_code;
2783:
2784: TYPE type_payment_method_code IS TABLE OF

Line 2785: iby_payments_all.payment_method_code%TYPE

2781: INDEX BY BINARY_INTEGER;
2782: t_payment_currency_code type_payment_currency_code;
2783:
2784: TYPE type_payment_method_code IS TABLE OF
2785: iby_payments_all.payment_method_code%TYPE
2786: INDEX BY BINARY_INTEGER;
2787: t_payment_method_code type_payment_method_code;
2788:
2789: TYPE type_payment_date IS TABLE OF

Line 2790: iby_payments_all.payment_date%TYPE

2786: INDEX BY BINARY_INTEGER;
2787: t_payment_method_code type_payment_method_code;
2788:
2789: TYPE type_payment_date IS TABLE OF
2790: iby_payments_all.payment_date%TYPE
2791: INDEX BY BINARY_INTEGER;
2792: t_payment_date type_payment_date;
2793:
2794: TYPE type_payment_reason_code IS TABLE OF

Line 2795: iby_payments_all.payment_reason_code%TYPE

2791: INDEX BY BINARY_INTEGER;
2792: t_payment_date type_payment_date;
2793:
2794: TYPE type_payment_reason_code IS TABLE OF
2795: iby_payments_all.payment_reason_code%TYPE
2796: INDEX BY BINARY_INTEGER;
2797: t_payment_reason_code type_payment_reason_code;
2798:
2799: TYPE type_internal_bank_account_id IS TABLE OF

Line 2800: iby_payments_all.internal_bank_account_id%TYPE

2796: INDEX BY BINARY_INTEGER;
2797: t_payment_reason_code type_payment_reason_code;
2798:
2799: TYPE type_internal_bank_account_id IS TABLE OF
2800: iby_payments_all.internal_bank_account_id%TYPE
2801: INDEX BY BINARY_INTEGER;
2802: t_internal_bank_account_id type_internal_bank_account_id;
2803:
2804: TYPE type_ext_payee_id IS TABLE OF

Line 2805: iby_payments_all.ext_payee_id%TYPE

2801: INDEX BY BINARY_INTEGER;
2802: t_internal_bank_account_id type_internal_bank_account_id;
2803:
2804: TYPE type_ext_payee_id IS TABLE OF
2805: iby_payments_all.ext_payee_id%TYPE
2806: INDEX BY BINARY_INTEGER;
2807: t_ext_payee_id type_ext_payee_id;
2808:
2809: TYPE type_org_id IS TABLE OF

Line 2810: iby_payments_all.org_id%TYPE

2806: INDEX BY BINARY_INTEGER;
2807: t_ext_payee_id type_ext_payee_id;
2808:
2809: TYPE type_org_id IS TABLE OF
2810: iby_payments_all.org_id%TYPE
2811: INDEX BY BINARY_INTEGER;
2812: t_org_id type_org_id;
2813:
2814: l_group_by_legal_entity iby_pmt_logical_grp_rules.group_by_legal_entity%TYPE;

Line 2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;

2818: l_group_by_operating_unit iby_pmt_logical_grp_rules.group_by_operating_unit%TYPE;
2819:
2820: l_first_group_by VARCHAR2(1);
2821:
2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
2823: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
2824: prev_payment_date iby_payments_all.payment_date%TYPE;
2825: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
2826: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;

Line 2823: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;

2819:
2820: l_first_group_by VARCHAR2(1);
2821:
2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
2823: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
2824: prev_payment_date iby_payments_all.payment_date%TYPE;
2825: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
2826: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;
2827:

Line 2824: prev_payment_date iby_payments_all.payment_date%TYPE;

2820: l_first_group_by VARCHAR2(1);
2821:
2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
2823: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
2824: prev_payment_date iby_payments_all.payment_date%TYPE;
2825: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
2826: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;
2827:
2828:

Line 2825: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;

2821:
2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
2823: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
2824: prev_payment_date iby_payments_all.payment_date%TYPE;
2825: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
2826: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;
2827:
2828:
2829: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';

Line 2826: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;

2822: prev_legal_entity_id iby_payments_all.legal_entity_id%TYPE;
2823: prev_payment_method_code iby_payments_all.payment_method_code%TYPE;
2824: prev_payment_date iby_payments_all.payment_date%TYPE;
2825: prev_internal_bank_account_id iby_payments_all.internal_bank_account_id%TYPE;
2826: prev_ext_payee_id iby_payments_all.ext_payee_id%TYPE;
2827:
2828:
2829: l_module_name VARCHAR2(200) := G_PKG_NAME || '.createLogicalGroups';
2830:

Line 2856: FROM IBY_PAYMENTS_ALL

2852: IF l_grouping_mode = 'SNGL' THEN
2853:
2854: SELECT PAYMENT_ID BULK COLLECT
2855: INTO t_payment_id
2856: FROM IBY_PAYMENTS_ALL
2857: WHERE PAYMENT_INSTRUCTION_ID = l_payment_instruction_id;
2858:
2859: FOR j in t_payment_id.FIRST .. t_payment_id.LAST
2860: LOOP

Line 2869: UPDATE IBY_PAYMENTS_ALL

2865:
2866: END LOOP;
2867:
2868: FORALL k IN t_payment_id.FIRST .. t_payment_id.LAST
2869: UPDATE IBY_PAYMENTS_ALL
2870: SET LOGICAL_GROUP_REFERENCE = t_logical_group_reference(k)
2871: WHERE payment_id = t_payment_id(k) ;
2872:
2873: ELSIF l_grouping_mode = 'GRPD' THEN

Line 2880: UPDATE IBY_PAYMENTS_ALL

2876:
2877: print_debuginfo(l_module_name, 'logical_grp_ref: '
2878: || l_logical_group_reference );
2879:
2880: UPDATE IBY_PAYMENTS_ALL
2881: SET logical_group_reference = l_logical_group_reference
2882: WHERE payment_instruction_id = l_payment_instruction_id;
2883:
2884: ELSIF l_grouping_mode = 'MIXD' THEN

Line 2908: from_clause :=' FROM IBY_PAYMENTS_ALL';

2904: l_group_by_internal_bank_acct
2905: FROM IBY_PMT_LOGICAL_GRP_RULES
2906: WHERE SYSTEM_PROFILE_CODE = l_payment_profile_code;
2907:
2908: from_clause :=' FROM IBY_PAYMENTS_ALL';
2909: order_clause := ' ORDER BY ';
2910:
2911: l_first_group_by := 'Y';
2912:

Line 3022: UPDATE IBY_PAYMENTS_ALL

3018: END IF;
3019: END LOOP;
3020:
3021: FORALL j IN t_payment_id.FIRST .. t_payment_id.LAST
3022: UPDATE IBY_PAYMENTS_ALL
3023: SET logical_group_reference = t_logical_group_reference(j)
3024: WHERE payment_id = t_payment_id(j);
3025:
3026: END IF;

Line 5058: * pmts -> IBY_PAYMENTS_ALL

5054: * ------------- --------------------
5055: * payee -> HZ_PARTIES
5056: * payee_location -> HZ_LOCATIONS
5057: * payee_bank -> IBY_EXT_BANK_ACCOUNTS_V
5058: * pmts -> IBY_PAYMENTS_ALL
5059: *
5060: * These aliased table names are used in
5061: * query to pick up the sorted payments
5062: * in getSortedPmtsForInstr().

Line 5722: IBY_PAYMENTS_ALL

5718:
5719: FOR i IN p_sortedPmtsTab.FIRST .. p_sortedPmtsTab.LAST LOOP
5720:
5721: UPDATE
5722: IBY_PAYMENTS_ALL
5723: SET
5724: payment_reference_number = p_sortedPmtsTab(i).payment_ref,
5725: document_category_code = p_sortedPmtsTab(i).doc_cat_code,
5726: document_sequence_id = p_sortedPmtsTab(i).sequence_id,

Line 5767: IBY_PAYMENTS_ALL

5763:
5764: FOR i IN p_sortedPmtsTab.FIRST .. p_sortedPmtsTab.LAST LOOP
5765:
5766: UPDATE
5767: IBY_PAYMENTS_ALL
5768: SET
5769: document_category_code = p_sortedPmtsTab(i).doc_cat_code,
5770: document_sequence_id = p_sortedPmtsTab(i).sequence_id,
5771: document_sequence_value = p_sortedPmtsTab(i).sequence_number

Line 5811: IBY_PAYMENTS_ALL

5807:
5808: FOR i IN p_sortedPmtsTab.FIRST .. p_sortedPmtsTab.LAST LOOP
5809:
5810: UPDATE
5811: IBY_PAYMENTS_ALL
5812: SET
5813: payment_reference_number = p_sortedPmtsTab(i).payment_ref
5814: WHERE
5815: payment_id = p_sortedPmtsTab(i).payment_id

Line 5844: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,

5840: *---------------------------------------------------------------------*/
5841: PROCEDURE deriveDistinctAccessTypsForIns(
5842: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
5843: %TYPE,
5844: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
5845: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
5846: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
5847: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
5848: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab

Line 5845: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,

5841: PROCEDURE deriveDistinctAccessTypsForIns(
5842: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
5843: %TYPE,
5844: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
5845: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
5846: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
5847: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
5848: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
5849: )

Line 5846: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,

5842: p_instruction_id IN IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id
5843: %TYPE,
5844: p_pmt_function IN IBY_PAYMENTS_ALL.payment_function%TYPE,
5845: p_org_id IN IBY_PAYMENTS_ALL.org_id%TYPE,
5846: p_org_type IN IBY_PAYMENTS_ALL.org_type%TYPE,
5847: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
5848: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
5849: )
5850: IS

Line 6128: IBY_PAYMENTS_ALL

6124: document_sequence_value
6125: INTO
6126: l_seq_num
6127: FROM
6128: IBY_PAYMENTS_ALL
6129: WHERE
6130: payment_instruction_id = p_instr_id AND
6131: ROWNUM = 1
6132: ;

Line 6224: IBY_PAYMENTS_ALL

6220: payment_reference_number
6221: INTO
6222: l_pmt_ref
6223: FROM
6224: IBY_PAYMENTS_ALL
6225: WHERE
6226: payment_instruction_id = p_instr_id AND
6227: ROWNUM = 1
6228: ;

Line 6357: || 'IBY_PAYMENTS_ALL pmt, '

6353: || 'NULL, ' /* ledger id */
6354: || 'NULL, ' /* sequence number */
6355: || 'NULL ' /* sequence id */
6356: || 'FROM '
6357: || 'IBY_PAYMENTS_ALL pmt, '
6358: || 'IBY_PAY_SERVICE_REQUESTS req, '
6359: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
6360: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
6361: || 'HZ_PARTIES payee, '

Line 6396: || 'IBY_PAYMENTS_ALL pmt, '

6392: || 'NULL, ' /* ledger id */
6393: || 'NULL, ' /* sequence number */
6394: || 'NULL ' /* sequence id */
6395: || 'FROM '
6396: || 'IBY_PAYMENTS_ALL pmt, '
6397: || 'IBY_PAY_SERVICE_REQUESTS req, '
6398: || 'IBY_PAYMENT_METHODS_VL pmt_mthds, '
6399: || 'IBY_PAY_INSTRUCTIONS_ALL ins, '
6400: || 'HZ_PARTIES payee '