261: */
262: OPEN c_document_attribs(p_payment_request_id);
263: LOOP
264:
265: iby_disburse_submit_pub_pkg.delete_docspayTab;
266:
267: FETCH c_document_attribs BULK COLLECT INTO
268: iby_disburse_submit_pub_pkg.docspayTab.document_payable_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
264:
265: iby_disburse_submit_pub_pkg.delete_docspayTab;
266:
267: FETCH c_document_attribs BULK COLLECT INTO
268: iby_disburse_submit_pub_pkg.docspayTab.document_payable_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
265: iby_disburse_submit_pub_pkg.delete_docspayTab;
266:
267: FETCH c_document_attribs BULK COLLECT INTO
268: iby_disburse_submit_pub_pkg.docspayTab.document_payable_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
266:
267: FETCH c_document_attribs BULK COLLECT INTO
268: iby_disburse_submit_pub_pkg.docspayTab.document_payable_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
267: FETCH c_document_attribs BULK COLLECT INTO
268: iby_disburse_submit_pub_pkg.docspayTab.document_payable_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
268: iby_disburse_submit_pub_pkg.docspayTab.document_payable_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
269: iby_disburse_submit_pub_pkg.docspayTab.calling_app_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
270: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
271: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
272: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
273: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
274: iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
275: iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
276: iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id,
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
284: iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id
277: iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id,
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
284: iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id
285: LIMIT G_LINES_PER_FETCH;
278: iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code,
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
284: iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id
285: LIMIT G_LINES_PER_FETCH;
286:
279: iby_disburse_submit_pub_pkg.docspayTab.payment_method_code,
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
284: iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id
285: LIMIT G_LINES_PER_FETCH;
286:
287: FOR l_trx_line_index IN nvl(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id.FIRST,0) .. nvl(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id.LAST,-99)
280: iby_disburse_submit_pub_pkg.docspayTab.payment_format_code,
281: iby_disburse_submit_pub_pkg.docspayTab.org_id,
282: iby_disburse_submit_pub_pkg.docspayTab.org_type,
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
284: iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id
285: LIMIT G_LINES_PER_FETCH;
286:
287: FOR l_trx_line_index IN nvl(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id.FIRST,0) .. nvl(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id.LAST,-99)
288: LOOP
283: iby_disburse_submit_pub_pkg.docspayTab.payment_date,
284: iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id
285: LIMIT G_LINES_PER_FETCH;
286:
287: FOR l_trx_line_index IN nvl(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id.FIRST,0) .. nvl(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id.LAST,-99)
288: LOOP
289: l_no_rec_in_ppr := FALSE;
290:
291: /*
294: * internal bank account and payment profile whenever
295: * necessary (and whenever possible).
296: */
297:
298: doc_id := iby_disburse_submit_pub_pkg.docspayTab.document_payable_id(l_trx_line_index);
299: ca_id := iby_disburse_submit_pub_pkg.docspayTab.calling_app_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
295: * necessary (and whenever possible).
296: */
297:
298: doc_id := iby_disburse_submit_pub_pkg.docspayTab.document_payable_id(l_trx_line_index);
299: ca_id := iby_disburse_submit_pub_pkg.docspayTab.calling_app_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
296: */
297:
298: doc_id := iby_disburse_submit_pub_pkg.docspayTab.document_payable_id(l_trx_line_index);
299: ca_id := iby_disburse_submit_pub_pkg.docspayTab.calling_app_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
297:
298: doc_id := iby_disburse_submit_pub_pkg.docspayTab.document_payable_id(l_trx_line_index);
299: ca_id := iby_disburse_submit_pub_pkg.docspayTab.calling_app_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
298: doc_id := iby_disburse_submit_pub_pkg.docspayTab.document_payable_id(l_trx_line_index);
299: ca_id := iby_disburse_submit_pub_pkg.docspayTab.calling_app_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
299: ca_id := iby_disburse_submit_pub_pkg.docspayTab.calling_app_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
300: ca_doc_id1 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref1(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
301: ca_doc_id2 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref2(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
302: ca_doc_id3 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref3(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
303: ca_doc_id4 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref4(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
304: ca_doc_id5 := iby_disburse_submit_pub_pkg.docspayTab.calling_app_doc_unique_ref5(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
305: pp_tt_cd := iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
313: doc_pmt_date := iby_disburse_submit_pub_pkg.docspayTab.payment_date(l_trx_line_index);
306: doc_int_bank_acct_id := iby_disburse_submit_pub_pkg.docspayTab.internal_bank_account_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
313: doc_pmt_date := iby_disburse_submit_pub_pkg.docspayTab.payment_date(l_trx_line_index);
314: doc_payee_id := iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id(l_trx_line_index);
307: doc_profile_id := iby_disburse_submit_pub_pkg.docspayTab.payment_profile_id(l_trx_line_index);
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
313: doc_pmt_date := iby_disburse_submit_pub_pkg.docspayTab.payment_date(l_trx_line_index);
314: doc_payee_id := iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id(l_trx_line_index);
315:
308: doc_pay_currency := iby_disburse_submit_pub_pkg.docspayTab.payment_currency_code(l_trx_line_index);
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
313: doc_pmt_date := iby_disburse_submit_pub_pkg.docspayTab.payment_date(l_trx_line_index);
314: doc_payee_id := iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id(l_trx_line_index);
315:
316: /*
309: doc_pmt_method := iby_disburse_submit_pub_pkg.docspayTab.payment_method_code(l_trx_line_index);
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
313: doc_pmt_date := iby_disburse_submit_pub_pkg.docspayTab.payment_date(l_trx_line_index);
314: doc_payee_id := iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id(l_trx_line_index);
315:
316: /*
317: * Log the fields for the fetched document
310: doc_pmt_format := iby_disburse_submit_pub_pkg.docspayTab.payment_format_code(l_trx_line_index);
311: doc_org_id := iby_disburse_submit_pub_pkg.docspayTab.org_id(l_trx_line_index);
312: doc_org_type := iby_disburse_submit_pub_pkg.docspayTab.org_type(l_trx_line_index);
313: doc_pmt_date := iby_disburse_submit_pub_pkg.docspayTab.payment_date(l_trx_line_index);
314: doc_payee_id := iby_disburse_submit_pub_pkg.docspayTab.ext_payee_id(l_trx_line_index);
315:
316: /*
317: * Log the fields for the fetched document
318: */
721: RETURN;
722:
723: END IF;
724:
725: iby_disburse_submit_pub_pkg.delete_docspayTab;
726:
727: CLOSE c_document_attribs;
728:
729: