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_PAYGROUP_PUB dependencies on IBY_HOOK_DOCS_IN_PMT_T

Line 11270: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE

11266: l_object_version_numbers t_object_version_number;
11267: */
11268:
11269: TYPE t_pmt_id IS TABLE OF
11270: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
11271: INDEX BY BINARY_INTEGER;
11272: TYPE t_document_payable_id IS TABLE OF
11273: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
11274: INDEX BY BINARY_INTEGER;

Line 11273: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE

11269: TYPE t_pmt_id IS TABLE OF
11270: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
11271: INDEX BY BINARY_INTEGER;
11272: TYPE t_document_payable_id IS TABLE OF
11273: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
11274: INDEX BY BINARY_INTEGER;
11275: TYPE t_call_app_id IS TABLE OF
11276: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
11277: INDEX BY BINARY_INTEGER;

Line 11276: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE

11272: TYPE t_document_payable_id IS TABLE OF
11273: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
11274: INDEX BY BINARY_INTEGER;
11275: TYPE t_call_app_id IS TABLE OF
11276: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
11277: INDEX BY BINARY_INTEGER;
11278: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
11279: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
11280: INDEX BY BINARY_INTEGER;

Line 11279: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE

11275: TYPE t_call_app_id IS TABLE OF
11276: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
11277: INDEX BY BINARY_INTEGER;
11278: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
11279: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
11280: INDEX BY BINARY_INTEGER;
11281: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
11282: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
11283: INDEX BY BINARY_INTEGER;

Line 11282: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE

11278: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
11279: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
11280: INDEX BY BINARY_INTEGER;
11281: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
11282: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
11283: INDEX BY BINARY_INTEGER;
11284: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
11285: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
11286: INDEX BY BINARY_INTEGER;

Line 11285: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE

11281: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
11282: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
11283: INDEX BY BINARY_INTEGER;
11284: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
11285: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
11286: INDEX BY BINARY_INTEGER;
11287: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
11288: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
11289: INDEX BY BINARY_INTEGER;

Line 11288: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE

11284: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
11285: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
11286: INDEX BY BINARY_INTEGER;
11287: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
11288: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
11289: INDEX BY BINARY_INTEGER;
11290: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
11291: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
11292: INDEX BY BINARY_INTEGER;

Line 11291: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE

11287: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
11288: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
11289: INDEX BY BINARY_INTEGER;
11290: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
11291: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
11292: INDEX BY BINARY_INTEGER;
11293: TYPE t_document_amount IS TABLE OF
11294: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
11295: INDEX BY BINARY_INTEGER;

Line 11294: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE

11290: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
11291: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
11292: INDEX BY BINARY_INTEGER;
11293: TYPE t_document_amount IS TABLE OF
11294: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
11295: INDEX BY BINARY_INTEGER;
11296: TYPE t_document_currency_code IS TABLE OF
11297: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
11298: INDEX BY BINARY_INTEGER;

Line 11297: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE

11293: TYPE t_document_amount IS TABLE OF
11294: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
11295: INDEX BY BINARY_INTEGER;
11296: TYPE t_document_currency_code IS TABLE OF
11297: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
11298: INDEX BY BINARY_INTEGER;
11299: TYPE t_amount_withheld IS TABLE OF
11300: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
11301: INDEX BY BINARY_INTEGER;

Line 11300: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE

11296: TYPE t_document_currency_code IS TABLE OF
11297: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
11298: INDEX BY BINARY_INTEGER;
11299: TYPE t_amount_withheld IS TABLE OF
11300: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
11301: INDEX BY BINARY_INTEGER;
11302: TYPE t_dont_pay_flg IS TABLE OF
11303: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
11304: INDEX BY BINARY_INTEGER;

Line 11303: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE

11299: TYPE t_amount_withheld IS TABLE OF
11300: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
11301: INDEX BY BINARY_INTEGER;
11302: TYPE t_dont_pay_flg IS TABLE OF
11303: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
11304: INDEX BY BINARY_INTEGER;
11305: TYPE t_dont_pay_reason_cd IS TABLE OF
11306: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
11307: INDEX BY BINARY_INTEGER;

Line 11306: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE

11302: TYPE t_dont_pay_flg IS TABLE OF
11303: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
11304: INDEX BY BINARY_INTEGER;
11305: TYPE t_dont_pay_reason_cd IS TABLE OF
11306: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
11307: INDEX BY BINARY_INTEGER;
11308: TYPE t_dont_pay_desc IS TABLE OF
11309: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
11310: INDEX BY BINARY_INTEGER;

Line 11309: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE

11305: TYPE t_dont_pay_reason_cd IS TABLE OF
11306: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
11307: INDEX BY BINARY_INTEGER;
11308: TYPE t_dont_pay_desc IS TABLE OF
11309: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
11310: INDEX BY BINARY_INTEGER;
11311: TYPE t_pay_proc_trxn_type_code IS TABLE OF
11312: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
11313: INDEX BY BINARY_INTEGER;

Line 11312: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE

11308: TYPE t_dont_pay_desc IS TABLE OF
11309: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
11310: INDEX BY BINARY_INTEGER;
11311: TYPE t_pay_proc_trxn_type_code IS TABLE OF
11312: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
11313: INDEX BY BINARY_INTEGER;
11314: TYPE t_int_bank_account_id IS TABLE OF
11315: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
11316: INDEX BY BINARY_INTEGER;

Line 11315: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE

11311: TYPE t_pay_proc_trxn_type_code IS TABLE OF
11312: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
11313: INDEX BY BINARY_INTEGER;
11314: TYPE t_int_bank_account_id IS TABLE OF
11315: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
11316: INDEX BY BINARY_INTEGER;
11317: TYPE t_external_payee_id IS TABLE OF
11318: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
11319: INDEX BY BINARY_INTEGER;

Line 11318: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE

11314: TYPE t_int_bank_account_id IS TABLE OF
11315: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
11316: INDEX BY BINARY_INTEGER;
11317: TYPE t_external_payee_id IS TABLE OF
11318: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
11319: INDEX BY BINARY_INTEGER;
11320: TYPE t_payeeparty_id IS TABLE OF
11321: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
11322: INDEX BY BINARY_INTEGER;

Line 11321: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE

11317: TYPE t_external_payee_id IS TABLE OF
11318: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
11319: INDEX BY BINARY_INTEGER;
11320: TYPE t_payeeparty_id IS TABLE OF
11321: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
11322: INDEX BY BINARY_INTEGER;
11323: TYPE t_partysite_id IS TABLE OF
11324: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
11325: INDEX BY BINARY_INTEGER;

Line 11324: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE

11320: TYPE t_payeeparty_id IS TABLE OF
11321: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
11322: INDEX BY BINARY_INTEGER;
11323: TYPE t_partysite_id IS TABLE OF
11324: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
11325: INDEX BY BINARY_INTEGER;
11326: TYPE t_suppliersite_id IS TABLE OF
11327: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
11328: INDEX BY BINARY_INTEGER;

Line 11327: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE

11323: TYPE t_partysite_id IS TABLE OF
11324: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
11325: INDEX BY BINARY_INTEGER;
11326: TYPE t_suppliersite_id IS TABLE OF
11327: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
11328: INDEX BY BINARY_INTEGER;
11329: TYPE t_orgid IS TABLE OF
11330: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
11331: INDEX BY BINARY_INTEGER;

Line 11330: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE

11326: TYPE t_suppliersite_id IS TABLE OF
11327: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
11328: INDEX BY BINARY_INTEGER;
11329: TYPE t_orgid IS TABLE OF
11330: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
11331: INDEX BY BINARY_INTEGER;
11332: TYPE t_orgtype IS TABLE OF
11333: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
11334: INDEX BY BINARY_INTEGER;

Line 11333: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE

11329: TYPE t_orgid IS TABLE OF
11330: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
11331: INDEX BY BINARY_INTEGER;
11332: TYPE t_orgtype IS TABLE OF
11333: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
11334: INDEX BY BINARY_INTEGER;
11335: TYPE t_ext_bank_account_id IS TABLE OF
11336: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
11337: INDEX BY BINARY_INTEGER;

Line 11336: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE

11332: TYPE t_orgtype IS TABLE OF
11333: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
11334: INDEX BY BINARY_INTEGER;
11335: TYPE t_ext_bank_account_id IS TABLE OF
11336: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
11337: INDEX BY BINARY_INTEGER;
11338: TYPE t_payment_curr_discount_taken IS TABLE OF
11339: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
11340: INDEX BY BINARY_INTEGER;

Line 11339: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE

11335: TYPE t_ext_bank_account_id IS TABLE OF
11336: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
11337: INDEX BY BINARY_INTEGER;
11338: TYPE t_payment_curr_discount_taken IS TABLE OF
11339: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
11340: INDEX BY BINARY_INTEGER;
11341: TYPE t_crtd_by IS TABLE OF
11342: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
11343: INDEX BY BINARY_INTEGER;

Line 11342: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE

11338: TYPE t_payment_curr_discount_taken IS TABLE OF
11339: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
11340: INDEX BY BINARY_INTEGER;
11341: TYPE t_crtd_by IS TABLE OF
11342: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
11343: INDEX BY BINARY_INTEGER;
11344: TYPE t_crt_date IS TABLE OF
11345: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
11346: INDEX BY BINARY_INTEGER;

Line 11345: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE

11341: TYPE t_crtd_by IS TABLE OF
11342: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
11343: INDEX BY BINARY_INTEGER;
11344: TYPE t_crt_date IS TABLE OF
11345: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
11346: INDEX BY BINARY_INTEGER;
11347: TYPE t_last_updt_by IS TABLE OF
11348: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
11349: INDEX BY BINARY_INTEGER;

Line 11348: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE

11344: TYPE t_crt_date IS TABLE OF
11345: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
11346: INDEX BY BINARY_INTEGER;
11347: TYPE t_last_updt_by IS TABLE OF
11348: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
11349: INDEX BY BINARY_INTEGER;
11350: TYPE t_last_updt_date IS TABLE OF
11351: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
11352: INDEX BY BINARY_INTEGER;

Line 11351: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE

11347: TYPE t_last_updt_by IS TABLE OF
11348: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
11349: INDEX BY BINARY_INTEGER;
11350: TYPE t_last_updt_date IS TABLE OF
11351: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
11352: INDEX BY BINARY_INTEGER;
11353: TYPE t_last_updt_login IS TABLE OF
11354: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
11355: INDEX BY BINARY_INTEGER;

Line 11354: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE

11350: TYPE t_last_updt_date IS TABLE OF
11351: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
11352: INDEX BY BINARY_INTEGER;
11353: TYPE t_last_updt_login IS TABLE OF
11354: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
11355: INDEX BY BINARY_INTEGER;
11356: TYPE t_object_ver_number IS TABLE OF
11357: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
11358: INDEX BY BINARY_INTEGER;

Line 11357: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE

11353: TYPE t_last_updt_login IS TABLE OF
11354: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
11355: INDEX BY BINARY_INTEGER;
11356: TYPE t_object_ver_number IS TABLE OF
11357: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
11358: INDEX BY BINARY_INTEGER;
11359:
11360: l_payment_id t_pmt_id;
11361: l_document_payable_id t_document_payable_id;

Line 11561: * temp tables IBY_HOOK_PAYMENTS_TEMP and IBY_HOOK_DOCS_IN_PMT_TEMP.

11557: END IF;
11558:
11559: /*
11560: * The hook data is passed to the external app via global
11561: * temp tables IBY_HOOK_PAYMENTS_TEMP and IBY_HOOK_DOCS_IN_PMT_TEMP.
11562: * Populate these temp tables with data from our hook data
11563: * structures.
11564: */
11565: IF (paymentTab.calling_app_id.COUNT > 0) THEN

Line 11590: DELETE IBY_HOOK_DOCS_IN_PMT_T;

11586: print_debuginfo(l_module_name, 'Deleting existing records in '
11587: || 'hook tables .. ');
11588: END IF;
11589:
11590: DELETE IBY_HOOK_DOCS_IN_PMT_T;
11591: DELETE IBY_HOOK_PAYMENTS_T;
11592: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11593: print_debuginfo(l_module_name, 'Finished deleting records from '
11594: || 'hook tables .. ');

Line 11672: * Bulk insert records into IBY_HOOK_DOCS_IN_PMT_T using named

11668:
11669:
11670: /* insert documents */
11671: /*
11672: * Bulk insert records into IBY_HOOK_DOCS_IN_PMT_T using named
11673: * columns. This will avoid any dependency in column order.
11674: */
11675: IF (x_hookDocsInPmtTab.COUNT > 0) THEN
11676: FORALL i in x_hookDocsInPmtTab.FIRST..x_hookDocsInPmtTab.LAST

Line 11677: INSERT INTO IBY_HOOK_DOCS_IN_PMT_T

11673: * columns. This will avoid any dependency in column order.
11674: */
11675: IF (x_hookDocsInPmtTab.COUNT > 0) THEN
11676: FORALL i in x_hookDocsInPmtTab.FIRST..x_hookDocsInPmtTab.LAST
11677: INSERT INTO IBY_HOOK_DOCS_IN_PMT_T
11678: (
11679: payment_id,
11680: document_payable_id,
11681: calling_app_id,

Line 11924: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE

11920: l_object_version_numbers t_object_version_number;
11921: */
11922:
11923: TYPE t_pmt_id IS TABLE OF
11924: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
11925: INDEX BY BINARY_INTEGER;
11926: TYPE t_document_payable_id IS TABLE OF
11927: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
11928: INDEX BY BINARY_INTEGER;

Line 11927: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE

11923: TYPE t_pmt_id IS TABLE OF
11924: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
11925: INDEX BY BINARY_INTEGER;
11926: TYPE t_document_payable_id IS TABLE OF
11927: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
11928: INDEX BY BINARY_INTEGER;
11929: TYPE t_call_app_id IS TABLE OF
11930: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
11931: INDEX BY BINARY_INTEGER;

Line 11930: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE

11926: TYPE t_document_payable_id IS TABLE OF
11927: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
11928: INDEX BY BINARY_INTEGER;
11929: TYPE t_call_app_id IS TABLE OF
11930: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
11931: INDEX BY BINARY_INTEGER;
11932: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
11933: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
11934: INDEX BY BINARY_INTEGER;

Line 11933: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE

11929: TYPE t_call_app_id IS TABLE OF
11930: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
11931: INDEX BY BINARY_INTEGER;
11932: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
11933: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
11934: INDEX BY BINARY_INTEGER;
11935: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
11936: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
11937: INDEX BY BINARY_INTEGER;

Line 11936: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE

11932: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
11933: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
11934: INDEX BY BINARY_INTEGER;
11935: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
11936: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
11937: INDEX BY BINARY_INTEGER;
11938: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
11939: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
11940: INDEX BY BINARY_INTEGER;

Line 11939: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE

11935: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
11936: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
11937: INDEX BY BINARY_INTEGER;
11938: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
11939: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
11940: INDEX BY BINARY_INTEGER;
11941: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
11942: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
11943: INDEX BY BINARY_INTEGER;

Line 11942: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE

11938: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
11939: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
11940: INDEX BY BINARY_INTEGER;
11941: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
11942: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
11943: INDEX BY BINARY_INTEGER;
11944: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
11945: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
11946: INDEX BY BINARY_INTEGER;

Line 11945: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE

11941: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
11942: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
11943: INDEX BY BINARY_INTEGER;
11944: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
11945: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
11946: INDEX BY BINARY_INTEGER;
11947: TYPE t_document_amount IS TABLE OF
11948: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
11949: INDEX BY BINARY_INTEGER;

Line 11948: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE

11944: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
11945: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
11946: INDEX BY BINARY_INTEGER;
11947: TYPE t_document_amount IS TABLE OF
11948: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
11949: INDEX BY BINARY_INTEGER;
11950: TYPE t_document_currency_code IS TABLE OF
11951: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
11952: INDEX BY BINARY_INTEGER;

Line 11951: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE

11947: TYPE t_document_amount IS TABLE OF
11948: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
11949: INDEX BY BINARY_INTEGER;
11950: TYPE t_document_currency_code IS TABLE OF
11951: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
11952: INDEX BY BINARY_INTEGER;
11953: TYPE t_amount_withheld IS TABLE OF
11954: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
11955: INDEX BY BINARY_INTEGER;

Line 11954: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE

11950: TYPE t_document_currency_code IS TABLE OF
11951: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
11952: INDEX BY BINARY_INTEGER;
11953: TYPE t_amount_withheld IS TABLE OF
11954: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
11955: INDEX BY BINARY_INTEGER;
11956: TYPE t_dont_pay_flg IS TABLE OF
11957: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
11958: INDEX BY BINARY_INTEGER;

Line 11957: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE

11953: TYPE t_amount_withheld IS TABLE OF
11954: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
11955: INDEX BY BINARY_INTEGER;
11956: TYPE t_dont_pay_flg IS TABLE OF
11957: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
11958: INDEX BY BINARY_INTEGER;
11959: TYPE t_dont_pay_reason_cd IS TABLE OF
11960: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
11961: INDEX BY BINARY_INTEGER;

Line 11960: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE

11956: TYPE t_dont_pay_flg IS TABLE OF
11957: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
11958: INDEX BY BINARY_INTEGER;
11959: TYPE t_dont_pay_reason_cd IS TABLE OF
11960: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
11961: INDEX BY BINARY_INTEGER;
11962: TYPE t_dont_pay_desc IS TABLE OF
11963: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
11964: INDEX BY BINARY_INTEGER;

Line 11963: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE

11959: TYPE t_dont_pay_reason_cd IS TABLE OF
11960: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
11961: INDEX BY BINARY_INTEGER;
11962: TYPE t_dont_pay_desc IS TABLE OF
11963: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
11964: INDEX BY BINARY_INTEGER;
11965: TYPE t_pay_proc_trxn_type_code IS TABLE OF
11966: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
11967: INDEX BY BINARY_INTEGER;

Line 11966: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE

11962: TYPE t_dont_pay_desc IS TABLE OF
11963: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
11964: INDEX BY BINARY_INTEGER;
11965: TYPE t_pay_proc_trxn_type_code IS TABLE OF
11966: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
11967: INDEX BY BINARY_INTEGER;
11968: TYPE t_int_bank_account_id IS TABLE OF
11969: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
11970: INDEX BY BINARY_INTEGER;

Line 11969: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE

11965: TYPE t_pay_proc_trxn_type_code IS TABLE OF
11966: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
11967: INDEX BY BINARY_INTEGER;
11968: TYPE t_int_bank_account_id IS TABLE OF
11969: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
11970: INDEX BY BINARY_INTEGER;
11971: TYPE t_external_payee_id IS TABLE OF
11972: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
11973: INDEX BY BINARY_INTEGER;

Line 11972: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE

11968: TYPE t_int_bank_account_id IS TABLE OF
11969: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
11970: INDEX BY BINARY_INTEGER;
11971: TYPE t_external_payee_id IS TABLE OF
11972: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
11973: INDEX BY BINARY_INTEGER;
11974: TYPE t_payeeparty_id IS TABLE OF
11975: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
11976: INDEX BY BINARY_INTEGER;

Line 11975: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE

11971: TYPE t_external_payee_id IS TABLE OF
11972: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
11973: INDEX BY BINARY_INTEGER;
11974: TYPE t_payeeparty_id IS TABLE OF
11975: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
11976: INDEX BY BINARY_INTEGER;
11977: TYPE t_partysite_id IS TABLE OF
11978: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
11979: INDEX BY BINARY_INTEGER;

Line 11978: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE

11974: TYPE t_payeeparty_id IS TABLE OF
11975: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
11976: INDEX BY BINARY_INTEGER;
11977: TYPE t_partysite_id IS TABLE OF
11978: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
11979: INDEX BY BINARY_INTEGER;
11980: TYPE t_suppliersite_id IS TABLE OF
11981: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
11982: INDEX BY BINARY_INTEGER;

Line 11981: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE

11977: TYPE t_partysite_id IS TABLE OF
11978: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
11979: INDEX BY BINARY_INTEGER;
11980: TYPE t_suppliersite_id IS TABLE OF
11981: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
11982: INDEX BY BINARY_INTEGER;
11983: TYPE t_orgid IS TABLE OF
11984: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
11985: INDEX BY BINARY_INTEGER;

Line 11984: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE

11980: TYPE t_suppliersite_id IS TABLE OF
11981: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
11982: INDEX BY BINARY_INTEGER;
11983: TYPE t_orgid IS TABLE OF
11984: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
11985: INDEX BY BINARY_INTEGER;
11986: TYPE t_orgtype IS TABLE OF
11987: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
11988: INDEX BY BINARY_INTEGER;

Line 11987: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE

11983: TYPE t_orgid IS TABLE OF
11984: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
11985: INDEX BY BINARY_INTEGER;
11986: TYPE t_orgtype IS TABLE OF
11987: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
11988: INDEX BY BINARY_INTEGER;
11989: TYPE t_ext_bank_account_id IS TABLE OF
11990: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
11991: INDEX BY BINARY_INTEGER;

Line 11990: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE

11986: TYPE t_orgtype IS TABLE OF
11987: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
11988: INDEX BY BINARY_INTEGER;
11989: TYPE t_ext_bank_account_id IS TABLE OF
11990: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
11991: INDEX BY BINARY_INTEGER;
11992: TYPE t_payment_curr_discount_taken IS TABLE OF
11993: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
11994: INDEX BY BINARY_INTEGER;

Line 11993: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE

11989: TYPE t_ext_bank_account_id IS TABLE OF
11990: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
11991: INDEX BY BINARY_INTEGER;
11992: TYPE t_payment_curr_discount_taken IS TABLE OF
11993: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
11994: INDEX BY BINARY_INTEGER;
11995: TYPE t_crtd_by IS TABLE OF
11996: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
11997: INDEX BY BINARY_INTEGER;

Line 11996: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE

11992: TYPE t_payment_curr_discount_taken IS TABLE OF
11993: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
11994: INDEX BY BINARY_INTEGER;
11995: TYPE t_crtd_by IS TABLE OF
11996: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
11997: INDEX BY BINARY_INTEGER;
11998: TYPE t_crt_date IS TABLE OF
11999: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
12000: INDEX BY BINARY_INTEGER;

Line 11999: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE

11995: TYPE t_crtd_by IS TABLE OF
11996: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
11997: INDEX BY BINARY_INTEGER;
11998: TYPE t_crt_date IS TABLE OF
11999: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
12000: INDEX BY BINARY_INTEGER;
12001: TYPE t_last_updt_by IS TABLE OF
12002: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
12003: INDEX BY BINARY_INTEGER;

Line 12002: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE

11998: TYPE t_crt_date IS TABLE OF
11999: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
12000: INDEX BY BINARY_INTEGER;
12001: TYPE t_last_updt_by IS TABLE OF
12002: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
12003: INDEX BY BINARY_INTEGER;
12004: TYPE t_last_updt_date IS TABLE OF
12005: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
12006: INDEX BY BINARY_INTEGER;

Line 12005: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE

12001: TYPE t_last_updt_by IS TABLE OF
12002: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
12003: INDEX BY BINARY_INTEGER;
12004: TYPE t_last_updt_date IS TABLE OF
12005: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
12006: INDEX BY BINARY_INTEGER;
12007: TYPE t_last_updt_login IS TABLE OF
12008: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
12009: INDEX BY BINARY_INTEGER;

Line 12008: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE

12004: TYPE t_last_updt_date IS TABLE OF
12005: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
12006: INDEX BY BINARY_INTEGER;
12007: TYPE t_last_updt_login IS TABLE OF
12008: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
12009: INDEX BY BINARY_INTEGER;
12010: TYPE t_object_ver_number IS TABLE OF
12011: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
12012: INDEX BY BINARY_INTEGER;

Line 12011: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE

12007: TYPE t_last_updt_login IS TABLE OF
12008: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
12009: INDEX BY BINARY_INTEGER;
12010: TYPE t_object_ver_number IS TABLE OF
12011: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
12012: INDEX BY BINARY_INTEGER;
12013:
12014: l_payment_id t_pmt_id;
12015: l_document_payable_id t_document_payable_id;

Line 12129: * temp tables IBY_HOOK_PAYMENTS_TEMP and IBY_HOOK_DOCS_IN_PMT_TEMP.

12125:
12126:
12127: /*
12128: * The hook data is passed to the external app via global
12129: * temp tables IBY_HOOK_PAYMENTS_TEMP and IBY_HOOK_DOCS_IN_PMT_TEMP.
12130: * Populate these temp tables with data from our hook data
12131: * structures.
12132: */
12133: IF (IBY_PAYGROUP_PUB.pmtTable.payment_id.COUNT > 0) THEN

Line 12158: DELETE IBY_HOOK_DOCS_IN_PMT_T;

12154: print_debuginfo(l_module_name, 'Deleting existing records in '
12155: || 'hook tables .. ');
12156: END IF;
12157:
12158: DELETE IBY_HOOK_DOCS_IN_PMT_T;
12159: DELETE IBY_HOOK_PAYMENTS_T;
12160: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12161: print_debuginfo(l_module_name, 'Finished deleting records from '
12162: || 'hook tables .. ');

Line 12253: INSERT INTO iby_hook_docs_in_pmt_t(

12249: END LOOP;
12250: CLOSE check_hook_pmt;
12251: */
12252:
12253: INSERT INTO iby_hook_docs_in_pmt_t(
12254: PAYMENT_ID,
12255: DOCUMENT_PAYABLE_ID,
12256: CALLING_APP_ID,
12257: CALLING_APP_DOC_UNIQUE_REF1,

Line 12323: --from iby_hook_docs_in_pmt_t;

12319:
12320: l_DocsInPmtCount := SQL%ROWCOUNT;
12321:
12322: --Select count(*) into l_DocsInPmtCount
12323: --from iby_hook_docs_in_pmt_t;
12324:
12325: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12326: print_debuginfo(l_module_name, 'Finished populating global temp tables.');
12327:

Line 13004: WHERE idpt.document_payable_id in (SELECT idpa.document_payable_id from iby_hook_docs_in_pmt_t idpa

13000: idpt.pay_proc_trxn_type_code,
13001: idpt.document_amount,
13002: idpt.payment_grouping_number
13003: FROM iby_docs_in_pmt_gt idpt
13004: WHERE idpt.document_payable_id in (SELECT idpa.document_payable_id from iby_hook_docs_in_pmt_t idpa
13005: WHERE idpa.dont_pay_flag = 'Y');
13006: CURSOR c_failed_documents
13007: IS
13008: SELECT ihdp.document_payable_id,

Line 13012: FROM iby_hook_docs_in_pmt_t ihdp, iby_docs_in_pmt_gt idip

13008: SELECT ihdp.document_payable_id,
13009: ihdp.document_amount,
13010: ihdp.amount_withheld,
13011: ihdp.dont_pay_flag
13012: FROM iby_hook_docs_in_pmt_t ihdp, iby_docs_in_pmt_gt idip
13013: WHERE ihdp.document_payable_id = idip.document_payable_id
13014: AND (ihdp.document_amount <> idip.document_amount
13015: OR ihdp.amount_withheld <> idip.amount_withheld
13016: OR ihdp.dont_pay_flag <> idip.dont_pay_flag);

Line 13324: UPDATE iby_hook_docs_in_pmt_t

13320: *
13321: * The loop below handles these steps.
13322: */
13323:
13324: UPDATE iby_hook_docs_in_pmt_t
13325: SET dont_pay_flag = 'Y'
13326: WHERE payment_id IN (select payment_id from iby_hook_payments_t where dont_pay_flag = 'Y');
13327:
13328:

Line 13525: USING iby_hook_docs_in_pmt_t idpt ON(idpt.document_payable_id = idpa.document_payable_id)

13521: print_debuginfo(l_module_name, 'Before merge.. ' );
13522: END IF;
13523: MERGE
13524: INTO iby_docs_in_pmt_gt idpa
13525: USING iby_hook_docs_in_pmt_t idpt ON(idpt.document_payable_id = idpa.document_payable_id)
13526: WHEN MATCHED THEN UPDATE
13527: SET idpa.document_amount = idpt.document_amount,
13528: idpa.amount_withheld = idpt.amount_withheld,
13529: idpa.payment_curr_discount_taken = idpt.payment_curr_discount_taken;

Line 13543: WHERE idpa.document_payable_id IN (SELECT document_payable_id from iby_hook_docs_in_pmt_t idpt

13539: print_debuginfo(l_module_name, 'Before updating the GT table' );
13540: END IF;
13541: UPDATE iby_docs_in_pmt_gt idpa
13542: SET idpa.document_status = DOC_STATUS_CA_FAILED
13543: WHERE idpa.document_payable_id IN (SELECT document_payable_id from iby_hook_docs_in_pmt_t idpt
13544: WHERE idpt.dont_pay_flag = 'Y');
13545:
13546: IF (l_fail_dop_tbl.COUNT > 0 ) THEN
13547:

Line 14667: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE

14663: object_version_number
14664: FROM IBY_HOOK_PAYMENTS_T;
14665:
14666: TYPE ty_payment_id IS TABLE OF
14667: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
14668: INDEX BY BINARY_INTEGER;
14669: TYPE ty_document_payable_id IS TABLE OF
14670: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
14671: INDEX BY BINARY_INTEGER;

Line 14670: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE

14666: TYPE ty_payment_id IS TABLE OF
14667: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
14668: INDEX BY BINARY_INTEGER;
14669: TYPE ty_document_payable_id IS TABLE OF
14670: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
14671: INDEX BY BINARY_INTEGER;
14672: TYPE ty_calling_app_id IS TABLE OF
14673: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
14674: INDEX BY BINARY_INTEGER;

Line 14673: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE

14669: TYPE ty_document_payable_id IS TABLE OF
14670: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
14671: INDEX BY BINARY_INTEGER;
14672: TYPE ty_calling_app_id IS TABLE OF
14673: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
14674: INDEX BY BINARY_INTEGER;
14675: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
14676: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
14677: INDEX BY BINARY_INTEGER;

Line 14676: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE

14672: TYPE ty_calling_app_id IS TABLE OF
14673: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
14674: INDEX BY BINARY_INTEGER;
14675: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
14676: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
14677: INDEX BY BINARY_INTEGER;
14678: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
14679: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
14680: INDEX BY BINARY_INTEGER;

Line 14679: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE

14675: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
14676: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
14677: INDEX BY BINARY_INTEGER;
14678: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
14679: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
14680: INDEX BY BINARY_INTEGER;
14681: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
14682: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
14683: INDEX BY BINARY_INTEGER;

Line 14682: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE

14678: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
14679: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
14680: INDEX BY BINARY_INTEGER;
14681: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
14682: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
14683: INDEX BY BINARY_INTEGER;
14684: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
14685: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
14686: INDEX BY BINARY_INTEGER;

Line 14685: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE

14681: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
14682: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
14683: INDEX BY BINARY_INTEGER;
14684: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
14685: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
14686: INDEX BY BINARY_INTEGER;
14687: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
14688: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
14689: INDEX BY BINARY_INTEGER;

Line 14688: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE

14684: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
14685: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
14686: INDEX BY BINARY_INTEGER;
14687: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
14688: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
14689: INDEX BY BINARY_INTEGER;
14690: TYPE ty_document_amount IS TABLE OF
14691: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
14692: INDEX BY BINARY_INTEGER;

Line 14691: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE

14687: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
14688: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
14689: INDEX BY BINARY_INTEGER;
14690: TYPE ty_document_amount IS TABLE OF
14691: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
14692: INDEX BY BINARY_INTEGER;
14693: TYPE ty_document_currency_code IS TABLE OF
14694: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
14695: INDEX BY BINARY_INTEGER;

Line 14694: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE

14690: TYPE ty_document_amount IS TABLE OF
14691: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
14692: INDEX BY BINARY_INTEGER;
14693: TYPE ty_document_currency_code IS TABLE OF
14694: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
14695: INDEX BY BINARY_INTEGER;
14696: TYPE ty_amount_withheld IS TABLE OF
14697: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
14698: INDEX BY BINARY_INTEGER;

Line 14697: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE

14693: TYPE ty_document_currency_code IS TABLE OF
14694: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
14695: INDEX BY BINARY_INTEGER;
14696: TYPE ty_amount_withheld IS TABLE OF
14697: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
14698: INDEX BY BINARY_INTEGER;
14699: TYPE ty_dont_pay_flag IS TABLE OF
14700: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
14701: INDEX BY BINARY_INTEGER;

Line 14700: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE

14696: TYPE ty_amount_withheld IS TABLE OF
14697: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
14698: INDEX BY BINARY_INTEGER;
14699: TYPE ty_dont_pay_flag IS TABLE OF
14700: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
14701: INDEX BY BINARY_INTEGER;
14702: TYPE ty_dont_pay_reason_code IS TABLE OF
14703: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
14704: INDEX BY BINARY_INTEGER;

Line 14703: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE

14699: TYPE ty_dont_pay_flag IS TABLE OF
14700: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
14701: INDEX BY BINARY_INTEGER;
14702: TYPE ty_dont_pay_reason_code IS TABLE OF
14703: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
14704: INDEX BY BINARY_INTEGER;
14705: TYPE ty_dont_pay_description IS TABLE OF
14706: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
14707: INDEX BY BINARY_INTEGER;

Line 14706: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE

14702: TYPE ty_dont_pay_reason_code IS TABLE OF
14703: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
14704: INDEX BY BINARY_INTEGER;
14705: TYPE ty_dont_pay_description IS TABLE OF
14706: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
14707: INDEX BY BINARY_INTEGER;
14708: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
14709: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
14710: INDEX BY BINARY_INTEGER;

Line 14709: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE

14705: TYPE ty_dont_pay_description IS TABLE OF
14706: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
14707: INDEX BY BINARY_INTEGER;
14708: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
14709: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
14710: INDEX BY BINARY_INTEGER;
14711: TYPE ty_internal_bank_account_id IS TABLE OF
14712: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
14713: INDEX BY BINARY_INTEGER;

Line 14712: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE

14708: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
14709: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
14710: INDEX BY BINARY_INTEGER;
14711: TYPE ty_internal_bank_account_id IS TABLE OF
14712: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
14713: INDEX BY BINARY_INTEGER;
14714: TYPE ty_ext_payee_id IS TABLE OF
14715: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
14716: INDEX BY BINARY_INTEGER;

Line 14715: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE

14711: TYPE ty_internal_bank_account_id IS TABLE OF
14712: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
14713: INDEX BY BINARY_INTEGER;
14714: TYPE ty_ext_payee_id IS TABLE OF
14715: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
14716: INDEX BY BINARY_INTEGER;
14717: TYPE ty_payee_party_id IS TABLE OF
14718: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
14719: INDEX BY BINARY_INTEGER;

Line 14718: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE

14714: TYPE ty_ext_payee_id IS TABLE OF
14715: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
14716: INDEX BY BINARY_INTEGER;
14717: TYPE ty_payee_party_id IS TABLE OF
14718: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
14719: INDEX BY BINARY_INTEGER;
14720: TYPE ty_party_site_id IS TABLE OF
14721: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
14722: INDEX BY BINARY_INTEGER;

Line 14721: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE

14717: TYPE ty_payee_party_id IS TABLE OF
14718: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
14719: INDEX BY BINARY_INTEGER;
14720: TYPE ty_party_site_id IS TABLE OF
14721: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
14722: INDEX BY BINARY_INTEGER;
14723: TYPE ty_supplier_site_id IS TABLE OF
14724: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
14725: INDEX BY BINARY_INTEGER;

Line 14724: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE

14720: TYPE ty_party_site_id IS TABLE OF
14721: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
14722: INDEX BY BINARY_INTEGER;
14723: TYPE ty_supplier_site_id IS TABLE OF
14724: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
14725: INDEX BY BINARY_INTEGER;
14726: TYPE ty_org_id IS TABLE OF
14727: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
14728: INDEX BY BINARY_INTEGER;

Line 14727: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE

14723: TYPE ty_supplier_site_id IS TABLE OF
14724: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
14725: INDEX BY BINARY_INTEGER;
14726: TYPE ty_org_id IS TABLE OF
14727: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
14728: INDEX BY BINARY_INTEGER;
14729: TYPE ty_org_type IS TABLE OF
14730: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
14731: INDEX BY BINARY_INTEGER;

Line 14730: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE

14726: TYPE ty_org_id IS TABLE OF
14727: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
14728: INDEX BY BINARY_INTEGER;
14729: TYPE ty_org_type IS TABLE OF
14730: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
14731: INDEX BY BINARY_INTEGER;
14732: TYPE ty_external_bank_account_id IS TABLE OF
14733: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
14734: INDEX BY BINARY_INTEGER;

Line 14733: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE

14729: TYPE ty_org_type IS TABLE OF
14730: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
14731: INDEX BY BINARY_INTEGER;
14732: TYPE ty_external_bank_account_id IS TABLE OF
14733: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
14734: INDEX BY BINARY_INTEGER;
14735: TYPE ty_payment_curr_discount_taken IS TABLE OF
14736: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
14737: INDEX BY BINARY_INTEGER;

Line 14736: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE

14732: TYPE ty_external_bank_account_id IS TABLE OF
14733: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
14734: INDEX BY BINARY_INTEGER;
14735: TYPE ty_payment_curr_discount_taken IS TABLE OF
14736: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
14737: INDEX BY BINARY_INTEGER;
14738: TYPE ty_created_by IS TABLE OF
14739: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
14740: INDEX BY BINARY_INTEGER;

Line 14739: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE

14735: TYPE ty_payment_curr_discount_taken IS TABLE OF
14736: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
14737: INDEX BY BINARY_INTEGER;
14738: TYPE ty_created_by IS TABLE OF
14739: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
14740: INDEX BY BINARY_INTEGER;
14741: TYPE ty_creation_date IS TABLE OF
14742: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
14743: INDEX BY BINARY_INTEGER;

Line 14742: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE

14738: TYPE ty_created_by IS TABLE OF
14739: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
14740: INDEX BY BINARY_INTEGER;
14741: TYPE ty_creation_date IS TABLE OF
14742: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
14743: INDEX BY BINARY_INTEGER;
14744: TYPE ty_last_updated_by IS TABLE OF
14745: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
14746: INDEX BY BINARY_INTEGER;

Line 14745: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE

14741: TYPE ty_creation_date IS TABLE OF
14742: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
14743: INDEX BY BINARY_INTEGER;
14744: TYPE ty_last_updated_by IS TABLE OF
14745: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
14746: INDEX BY BINARY_INTEGER;
14747: TYPE ty_last_update_date IS TABLE OF
14748: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
14749: INDEX BY BINARY_INTEGER;

Line 14748: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE

14744: TYPE ty_last_updated_by IS TABLE OF
14745: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
14746: INDEX BY BINARY_INTEGER;
14747: TYPE ty_last_update_date IS TABLE OF
14748: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
14749: INDEX BY BINARY_INTEGER;
14750: TYPE ty_last_update_login IS TABLE OF
14751: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
14752: INDEX BY BINARY_INTEGER;

Line 14751: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE

14747: TYPE ty_last_update_date IS TABLE OF
14748: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
14749: INDEX BY BINARY_INTEGER;
14750: TYPE ty_last_update_login IS TABLE OF
14751: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
14752: INDEX BY BINARY_INTEGER;
14753: TYPE ty_object_version_number IS TABLE OF
14754: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
14755: INDEX BY BINARY_INTEGER;

Line 14754: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE

14750: TYPE ty_last_update_login IS TABLE OF
14751: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
14752: INDEX BY BINARY_INTEGER;
14753: TYPE ty_object_version_number IS TABLE OF
14754: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
14755: INDEX BY BINARY_INTEGER;
14756:
14757:
14758: ll_payment_id ty_payment_id;

Line 14824: FROM IBY_HOOK_DOCS_IN_PMT_T

14820: last_updated_by,
14821: last_update_date,
14822: last_update_login,
14823: object_version_number
14824: FROM IBY_HOOK_DOCS_IN_PMT_T
14825: ORDER BY document_payable_id;
14826:
14827: BEGIN
14828:

Line 15203: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE

15199: object_version_number
15200: FROM IBY_HOOK_PAYMENTS_T;
15201:
15202: TYPE ty_payment_id IS TABLE OF
15203: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
15204: INDEX BY BINARY_INTEGER;
15205: TYPE ty_document_payable_id IS TABLE OF
15206: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
15207: INDEX BY BINARY_INTEGER;

Line 15206: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE

15202: TYPE ty_payment_id IS TABLE OF
15203: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
15204: INDEX BY BINARY_INTEGER;
15205: TYPE ty_document_payable_id IS TABLE OF
15206: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
15207: INDEX BY BINARY_INTEGER;
15208: TYPE ty_calling_app_id IS TABLE OF
15209: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
15210: INDEX BY BINARY_INTEGER;

Line 15209: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE

15205: TYPE ty_document_payable_id IS TABLE OF
15206: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
15207: INDEX BY BINARY_INTEGER;
15208: TYPE ty_calling_app_id IS TABLE OF
15209: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
15210: INDEX BY BINARY_INTEGER;
15211: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
15212: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
15213: INDEX BY BINARY_INTEGER;

Line 15212: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE

15208: TYPE ty_calling_app_id IS TABLE OF
15209: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
15210: INDEX BY BINARY_INTEGER;
15211: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
15212: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
15213: INDEX BY BINARY_INTEGER;
15214: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
15215: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
15216: INDEX BY BINARY_INTEGER;

Line 15215: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE

15211: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
15212: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
15213: INDEX BY BINARY_INTEGER;
15214: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
15215: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
15216: INDEX BY BINARY_INTEGER;
15217: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
15218: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
15219: INDEX BY BINARY_INTEGER;

Line 15218: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE

15214: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
15215: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
15216: INDEX BY BINARY_INTEGER;
15217: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
15218: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
15219: INDEX BY BINARY_INTEGER;
15220: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
15221: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
15222: INDEX BY BINARY_INTEGER;

Line 15221: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE

15217: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
15218: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
15219: INDEX BY BINARY_INTEGER;
15220: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
15221: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
15222: INDEX BY BINARY_INTEGER;
15223: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
15224: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
15225: INDEX BY BINARY_INTEGER;

Line 15224: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE

15220: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
15221: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
15222: INDEX BY BINARY_INTEGER;
15223: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
15224: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
15225: INDEX BY BINARY_INTEGER;
15226: TYPE ty_document_amount IS TABLE OF
15227: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
15228: INDEX BY BINARY_INTEGER;

Line 15227: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE

15223: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
15224: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
15225: INDEX BY BINARY_INTEGER;
15226: TYPE ty_document_amount IS TABLE OF
15227: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
15228: INDEX BY BINARY_INTEGER;
15229: TYPE ty_document_currency_code IS TABLE OF
15230: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
15231: INDEX BY BINARY_INTEGER;

Line 15230: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE

15226: TYPE ty_document_amount IS TABLE OF
15227: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
15228: INDEX BY BINARY_INTEGER;
15229: TYPE ty_document_currency_code IS TABLE OF
15230: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
15231: INDEX BY BINARY_INTEGER;
15232: TYPE ty_amount_withheld IS TABLE OF
15233: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
15234: INDEX BY BINARY_INTEGER;

Line 15233: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE

15229: TYPE ty_document_currency_code IS TABLE OF
15230: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
15231: INDEX BY BINARY_INTEGER;
15232: TYPE ty_amount_withheld IS TABLE OF
15233: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
15234: INDEX BY BINARY_INTEGER;
15235: TYPE ty_dont_pay_flag IS TABLE OF
15236: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
15237: INDEX BY BINARY_INTEGER;

Line 15236: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE

15232: TYPE ty_amount_withheld IS TABLE OF
15233: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
15234: INDEX BY BINARY_INTEGER;
15235: TYPE ty_dont_pay_flag IS TABLE OF
15236: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
15237: INDEX BY BINARY_INTEGER;
15238: TYPE ty_dont_pay_reason_code IS TABLE OF
15239: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
15240: INDEX BY BINARY_INTEGER;

Line 15239: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE

15235: TYPE ty_dont_pay_flag IS TABLE OF
15236: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
15237: INDEX BY BINARY_INTEGER;
15238: TYPE ty_dont_pay_reason_code IS TABLE OF
15239: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
15240: INDEX BY BINARY_INTEGER;
15241: TYPE ty_dont_pay_description IS TABLE OF
15242: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
15243: INDEX BY BINARY_INTEGER;

Line 15242: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE

15238: TYPE ty_dont_pay_reason_code IS TABLE OF
15239: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
15240: INDEX BY BINARY_INTEGER;
15241: TYPE ty_dont_pay_description IS TABLE OF
15242: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
15243: INDEX BY BINARY_INTEGER;
15244: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
15245: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
15246: INDEX BY BINARY_INTEGER;

Line 15245: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE

15241: TYPE ty_dont_pay_description IS TABLE OF
15242: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
15243: INDEX BY BINARY_INTEGER;
15244: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
15245: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
15246: INDEX BY BINARY_INTEGER;
15247: TYPE ty_internal_bank_account_id IS TABLE OF
15248: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
15249: INDEX BY BINARY_INTEGER;

Line 15248: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE

15244: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
15245: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
15246: INDEX BY BINARY_INTEGER;
15247: TYPE ty_internal_bank_account_id IS TABLE OF
15248: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
15249: INDEX BY BINARY_INTEGER;
15250: TYPE ty_ext_payee_id IS TABLE OF
15251: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
15252: INDEX BY BINARY_INTEGER;

Line 15251: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE

15247: TYPE ty_internal_bank_account_id IS TABLE OF
15248: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
15249: INDEX BY BINARY_INTEGER;
15250: TYPE ty_ext_payee_id IS TABLE OF
15251: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
15252: INDEX BY BINARY_INTEGER;
15253: TYPE ty_payee_party_id IS TABLE OF
15254: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
15255: INDEX BY BINARY_INTEGER;

Line 15254: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE

15250: TYPE ty_ext_payee_id IS TABLE OF
15251: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
15252: INDEX BY BINARY_INTEGER;
15253: TYPE ty_payee_party_id IS TABLE OF
15254: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
15255: INDEX BY BINARY_INTEGER;
15256: TYPE ty_party_site_id IS TABLE OF
15257: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
15258: INDEX BY BINARY_INTEGER;

Line 15257: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE

15253: TYPE ty_payee_party_id IS TABLE OF
15254: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
15255: INDEX BY BINARY_INTEGER;
15256: TYPE ty_party_site_id IS TABLE OF
15257: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
15258: INDEX BY BINARY_INTEGER;
15259: TYPE ty_supplier_site_id IS TABLE OF
15260: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
15261: INDEX BY BINARY_INTEGER;

Line 15260: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE

15256: TYPE ty_party_site_id IS TABLE OF
15257: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
15258: INDEX BY BINARY_INTEGER;
15259: TYPE ty_supplier_site_id IS TABLE OF
15260: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
15261: INDEX BY BINARY_INTEGER;
15262: TYPE ty_org_id IS TABLE OF
15263: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
15264: INDEX BY BINARY_INTEGER;

Line 15263: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE

15259: TYPE ty_supplier_site_id IS TABLE OF
15260: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
15261: INDEX BY BINARY_INTEGER;
15262: TYPE ty_org_id IS TABLE OF
15263: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
15264: INDEX BY BINARY_INTEGER;
15265: TYPE ty_org_type IS TABLE OF
15266: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
15267: INDEX BY BINARY_INTEGER;

Line 15266: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE

15262: TYPE ty_org_id IS TABLE OF
15263: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
15264: INDEX BY BINARY_INTEGER;
15265: TYPE ty_org_type IS TABLE OF
15266: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
15267: INDEX BY BINARY_INTEGER;
15268: TYPE ty_external_bank_account_id IS TABLE OF
15269: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
15270: INDEX BY BINARY_INTEGER;

Line 15269: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE

15265: TYPE ty_org_type IS TABLE OF
15266: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
15267: INDEX BY BINARY_INTEGER;
15268: TYPE ty_external_bank_account_id IS TABLE OF
15269: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
15270: INDEX BY BINARY_INTEGER;
15271: TYPE ty_payment_curr_discount_taken IS TABLE OF
15272: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
15273: INDEX BY BINARY_INTEGER;

Line 15272: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE

15268: TYPE ty_external_bank_account_id IS TABLE OF
15269: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
15270: INDEX BY BINARY_INTEGER;
15271: TYPE ty_payment_curr_discount_taken IS TABLE OF
15272: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
15273: INDEX BY BINARY_INTEGER;
15274: TYPE ty_created_by IS TABLE OF
15275: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
15276: INDEX BY BINARY_INTEGER;

Line 15275: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE

15271: TYPE ty_payment_curr_discount_taken IS TABLE OF
15272: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
15273: INDEX BY BINARY_INTEGER;
15274: TYPE ty_created_by IS TABLE OF
15275: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
15276: INDEX BY BINARY_INTEGER;
15277: TYPE ty_creation_date IS TABLE OF
15278: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
15279: INDEX BY BINARY_INTEGER;

Line 15278: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE

15274: TYPE ty_created_by IS TABLE OF
15275: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
15276: INDEX BY BINARY_INTEGER;
15277: TYPE ty_creation_date IS TABLE OF
15278: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
15279: INDEX BY BINARY_INTEGER;
15280: TYPE ty_last_updated_by IS TABLE OF
15281: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
15282: INDEX BY BINARY_INTEGER;

Line 15281: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE

15277: TYPE ty_creation_date IS TABLE OF
15278: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
15279: INDEX BY BINARY_INTEGER;
15280: TYPE ty_last_updated_by IS TABLE OF
15281: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
15282: INDEX BY BINARY_INTEGER;
15283: TYPE ty_last_update_date IS TABLE OF
15284: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
15285: INDEX BY BINARY_INTEGER;

Line 15284: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE

15280: TYPE ty_last_updated_by IS TABLE OF
15281: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
15282: INDEX BY BINARY_INTEGER;
15283: TYPE ty_last_update_date IS TABLE OF
15284: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
15285: INDEX BY BINARY_INTEGER;
15286: TYPE ty_last_update_login IS TABLE OF
15287: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
15288: INDEX BY BINARY_INTEGER;

Line 15287: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE

15283: TYPE ty_last_update_date IS TABLE OF
15284: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
15285: INDEX BY BINARY_INTEGER;
15286: TYPE ty_last_update_login IS TABLE OF
15287: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
15288: INDEX BY BINARY_INTEGER;
15289: TYPE ty_object_version_number IS TABLE OF
15290: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
15291: INDEX BY BINARY_INTEGER;

Line 15290: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE

15286: TYPE ty_last_update_login IS TABLE OF
15287: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
15288: INDEX BY BINARY_INTEGER;
15289: TYPE ty_object_version_number IS TABLE OF
15290: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
15291: INDEX BY BINARY_INTEGER;
15292:
15293:
15294: ll_payment_id ty_payment_id;

Line 15360: FROM IBY_HOOK_DOCS_IN_PMT_T

15356: last_updated_by,
15357: last_update_date,
15358: last_update_login,
15359: object_version_number
15360: FROM IBY_HOOK_DOCS_IN_PMT_T
15361: ORDER BY document_payable_id;*/
15362:
15363: BEGIN
15364: