APPS.IBY_PAYGROUP_PUB dependencies on IBY_HOOK_DOCS_IN_PMT_T

Line 5106: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE

5102: l_object_version_numbers t_object_version_number;
5103: */
5104:
5105: TYPE t_pmt_id IS TABLE OF
5106: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
5107: INDEX BY BINARY_INTEGER;
5108: TYPE t_document_payable_id IS TABLE OF
5109: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
5110: INDEX BY BINARY_INTEGER;

Line 5109: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE

5105: TYPE t_pmt_id IS TABLE OF
5106: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
5107: INDEX BY BINARY_INTEGER;
5108: TYPE t_document_payable_id IS TABLE OF
5109: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
5110: INDEX BY BINARY_INTEGER;
5111: TYPE t_call_app_id IS TABLE OF
5112: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
5113: INDEX BY BINARY_INTEGER;

Line 5112: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE

5108: TYPE t_document_payable_id IS TABLE OF
5109: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
5110: INDEX BY BINARY_INTEGER;
5111: TYPE t_call_app_id IS TABLE OF
5112: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
5113: INDEX BY BINARY_INTEGER;
5114: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
5115: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
5116: INDEX BY BINARY_INTEGER;

Line 5115: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE

5111: TYPE t_call_app_id IS TABLE OF
5112: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
5113: INDEX BY BINARY_INTEGER;
5114: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
5115: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
5116: INDEX BY BINARY_INTEGER;
5117: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
5118: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
5119: INDEX BY BINARY_INTEGER;

Line 5118: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE

5114: TYPE t_calling_app_doc_unique_ref1 IS TABLE OF
5115: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
5116: INDEX BY BINARY_INTEGER;
5117: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
5118: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
5119: INDEX BY BINARY_INTEGER;
5120: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
5121: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
5122: INDEX BY BINARY_INTEGER;

Line 5121: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE

5117: TYPE t_calling_app_doc_unique_ref2 IS TABLE OF
5118: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
5119: INDEX BY BINARY_INTEGER;
5120: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
5121: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
5122: INDEX BY BINARY_INTEGER;
5123: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
5124: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
5125: INDEX BY BINARY_INTEGER;

Line 5124: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE

5120: TYPE t_calling_app_doc_unique_ref3 IS TABLE OF
5121: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
5122: INDEX BY BINARY_INTEGER;
5123: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
5124: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
5125: INDEX BY BINARY_INTEGER;
5126: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
5127: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
5128: INDEX BY BINARY_INTEGER;

Line 5127: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE

5123: TYPE t_calling_app_doc_unique_ref4 IS TABLE OF
5124: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
5125: INDEX BY BINARY_INTEGER;
5126: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
5127: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
5128: INDEX BY BINARY_INTEGER;
5129: TYPE t_document_amount IS TABLE OF
5130: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
5131: INDEX BY BINARY_INTEGER;

Line 5130: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE

5126: TYPE t_calling_app_doc_unique_ref5 IS TABLE OF
5127: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
5128: INDEX BY BINARY_INTEGER;
5129: TYPE t_document_amount IS TABLE OF
5130: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
5131: INDEX BY BINARY_INTEGER;
5132: TYPE t_document_currency_code IS TABLE OF
5133: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
5134: INDEX BY BINARY_INTEGER;

Line 5133: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE

5129: TYPE t_document_amount IS TABLE OF
5130: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
5131: INDEX BY BINARY_INTEGER;
5132: TYPE t_document_currency_code IS TABLE OF
5133: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
5134: INDEX BY BINARY_INTEGER;
5135: TYPE t_amount_withheld IS TABLE OF
5136: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
5137: INDEX BY BINARY_INTEGER;

Line 5136: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE

5132: TYPE t_document_currency_code IS TABLE OF
5133: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
5134: INDEX BY BINARY_INTEGER;
5135: TYPE t_amount_withheld IS TABLE OF
5136: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
5137: INDEX BY BINARY_INTEGER;
5138: TYPE t_dont_pay_flg IS TABLE OF
5139: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
5140: INDEX BY BINARY_INTEGER;

Line 5139: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE

5135: TYPE t_amount_withheld IS TABLE OF
5136: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
5137: INDEX BY BINARY_INTEGER;
5138: TYPE t_dont_pay_flg IS TABLE OF
5139: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
5140: INDEX BY BINARY_INTEGER;
5141: TYPE t_dont_pay_reason_cd IS TABLE OF
5142: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
5143: INDEX BY BINARY_INTEGER;

Line 5142: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE

5138: TYPE t_dont_pay_flg IS TABLE OF
5139: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
5140: INDEX BY BINARY_INTEGER;
5141: TYPE t_dont_pay_reason_cd IS TABLE OF
5142: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
5143: INDEX BY BINARY_INTEGER;
5144: TYPE t_dont_pay_desc IS TABLE OF
5145: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
5146: INDEX BY BINARY_INTEGER;

Line 5145: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE

5141: TYPE t_dont_pay_reason_cd IS TABLE OF
5142: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
5143: INDEX BY BINARY_INTEGER;
5144: TYPE t_dont_pay_desc IS TABLE OF
5145: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
5146: INDEX BY BINARY_INTEGER;
5147: TYPE t_pay_proc_trxn_type_code IS TABLE OF
5148: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
5149: INDEX BY BINARY_INTEGER;

Line 5148: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE

5144: TYPE t_dont_pay_desc IS TABLE OF
5145: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
5146: INDEX BY BINARY_INTEGER;
5147: TYPE t_pay_proc_trxn_type_code IS TABLE OF
5148: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
5149: INDEX BY BINARY_INTEGER;
5150: TYPE t_int_bank_account_id IS TABLE OF
5151: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
5152: INDEX BY BINARY_INTEGER;

Line 5151: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE

5147: TYPE t_pay_proc_trxn_type_code IS TABLE OF
5148: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
5149: INDEX BY BINARY_INTEGER;
5150: TYPE t_int_bank_account_id IS TABLE OF
5151: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
5152: INDEX BY BINARY_INTEGER;
5153: TYPE t_external_payee_id IS TABLE OF
5154: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
5155: INDEX BY BINARY_INTEGER;

Line 5154: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE

5150: TYPE t_int_bank_account_id IS TABLE OF
5151: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
5152: INDEX BY BINARY_INTEGER;
5153: TYPE t_external_payee_id IS TABLE OF
5154: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
5155: INDEX BY BINARY_INTEGER;
5156: TYPE t_payeeparty_id IS TABLE OF
5157: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
5158: INDEX BY BINARY_INTEGER;

Line 5157: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE

5153: TYPE t_external_payee_id IS TABLE OF
5154: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
5155: INDEX BY BINARY_INTEGER;
5156: TYPE t_payeeparty_id IS TABLE OF
5157: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
5158: INDEX BY BINARY_INTEGER;
5159: TYPE t_partysite_id IS TABLE OF
5160: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
5161: INDEX BY BINARY_INTEGER;

Line 5160: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE

5156: TYPE t_payeeparty_id IS TABLE OF
5157: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
5158: INDEX BY BINARY_INTEGER;
5159: TYPE t_partysite_id IS TABLE OF
5160: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
5161: INDEX BY BINARY_INTEGER;
5162: TYPE t_suppliersite_id IS TABLE OF
5163: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
5164: INDEX BY BINARY_INTEGER;

Line 5163: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE

5159: TYPE t_partysite_id IS TABLE OF
5160: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
5161: INDEX BY BINARY_INTEGER;
5162: TYPE t_suppliersite_id IS TABLE OF
5163: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
5164: INDEX BY BINARY_INTEGER;
5165: TYPE t_orgid IS TABLE OF
5166: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
5167: INDEX BY BINARY_INTEGER;

Line 5166: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE

5162: TYPE t_suppliersite_id IS TABLE OF
5163: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
5164: INDEX BY BINARY_INTEGER;
5165: TYPE t_orgid IS TABLE OF
5166: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
5167: INDEX BY BINARY_INTEGER;
5168: TYPE t_orgtype IS TABLE OF
5169: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
5170: INDEX BY BINARY_INTEGER;

Line 5169: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE

5165: TYPE t_orgid IS TABLE OF
5166: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
5167: INDEX BY BINARY_INTEGER;
5168: TYPE t_orgtype IS TABLE OF
5169: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
5170: INDEX BY BINARY_INTEGER;
5171: TYPE t_ext_bank_account_id IS TABLE OF
5172: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
5173: INDEX BY BINARY_INTEGER;

Line 5172: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE

5168: TYPE t_orgtype IS TABLE OF
5169: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
5170: INDEX BY BINARY_INTEGER;
5171: TYPE t_ext_bank_account_id IS TABLE OF
5172: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
5173: INDEX BY BINARY_INTEGER;
5174: TYPE t_payment_curr_discount_taken IS TABLE OF
5175: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
5176: INDEX BY BINARY_INTEGER;

Line 5175: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE

5171: TYPE t_ext_bank_account_id IS TABLE OF
5172: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
5173: INDEX BY BINARY_INTEGER;
5174: TYPE t_payment_curr_discount_taken IS TABLE OF
5175: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
5176: INDEX BY BINARY_INTEGER;
5177: TYPE t_crtd_by IS TABLE OF
5178: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
5179: INDEX BY BINARY_INTEGER;

Line 5178: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE

5174: TYPE t_payment_curr_discount_taken IS TABLE OF
5175: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
5176: INDEX BY BINARY_INTEGER;
5177: TYPE t_crtd_by IS TABLE OF
5178: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
5179: INDEX BY BINARY_INTEGER;
5180: TYPE t_crt_date IS TABLE OF
5181: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
5182: INDEX BY BINARY_INTEGER;

Line 5181: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE

5177: TYPE t_crtd_by IS TABLE OF
5178: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
5179: INDEX BY BINARY_INTEGER;
5180: TYPE t_crt_date IS TABLE OF
5181: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
5182: INDEX BY BINARY_INTEGER;
5183: TYPE t_last_updt_by IS TABLE OF
5184: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
5185: INDEX BY BINARY_INTEGER;

Line 5184: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE

5180: TYPE t_crt_date IS TABLE OF
5181: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
5182: INDEX BY BINARY_INTEGER;
5183: TYPE t_last_updt_by IS TABLE OF
5184: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
5185: INDEX BY BINARY_INTEGER;
5186: TYPE t_last_updt_date IS TABLE OF
5187: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
5188: INDEX BY BINARY_INTEGER;

Line 5187: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE

5183: TYPE t_last_updt_by IS TABLE OF
5184: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
5185: INDEX BY BINARY_INTEGER;
5186: TYPE t_last_updt_date IS TABLE OF
5187: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
5188: INDEX BY BINARY_INTEGER;
5189: TYPE t_last_updt_login IS TABLE OF
5190: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
5191: INDEX BY BINARY_INTEGER;

Line 5190: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE

5186: TYPE t_last_updt_date IS TABLE OF
5187: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
5188: INDEX BY BINARY_INTEGER;
5189: TYPE t_last_updt_login IS TABLE OF
5190: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
5191: INDEX BY BINARY_INTEGER;
5192: TYPE t_object_ver_number IS TABLE OF
5193: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
5194: INDEX BY BINARY_INTEGER;

Line 5193: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE

5189: TYPE t_last_updt_login IS TABLE OF
5190: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
5191: INDEX BY BINARY_INTEGER;
5192: TYPE t_object_ver_number IS TABLE OF
5193: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
5194: INDEX BY BINARY_INTEGER;
5195:
5196: l_payment_id t_pmt_id;
5197: l_document_payable_id t_document_payable_id;

Line 5392: * temp tables IBY_HOOK_PAYMENTS_TEMP and IBY_HOOK_DOCS_IN_PMT_TEMP.

5388: || paymentTab.calling_app_id.COUNT);
5389:
5390: /*
5391: * The hook data is passed to the external app via global
5392: * temp tables IBY_HOOK_PAYMENTS_TEMP and IBY_HOOK_DOCS_IN_PMT_TEMP.
5393: * Populate these temp tables with data from our hook data
5394: * structures.
5395: */
5396: IF (paymentTab.calling_app_id.COUNT > 0) THEN

Line 5413: DELETE IBY_HOOK_DOCS_IN_PMT_T;

5409: * our processing.
5410: */
5411: print_debuginfo(l_module_name, 'Deleting existing records in '
5412: || 'hook tables .. ');
5413: DELETE IBY_HOOK_DOCS_IN_PMT_T;
5414: DELETE IBY_HOOK_PAYMENTS_T;
5415: print_debuginfo(l_module_name, 'Finished deleting records from '
5416: || 'hook tables .. ');
5417:

Line 5493: * Bulk insert records into IBY_HOOK_DOCS_IN_PMT_T using named

5489:
5490:
5491: /* insert documents */
5492: /*
5493: * Bulk insert records into IBY_HOOK_DOCS_IN_PMT_T using named
5494: * columns. This will avoid any dependency in column order.
5495: */
5496: IF (x_hookDocsInPmtTab.COUNT > 0) THEN
5497: FORALL i in x_hookDocsInPmtTab.FIRST..x_hookDocsInPmtTab.LAST

Line 5498: INSERT INTO IBY_HOOK_DOCS_IN_PMT_T

5494: * columns. This will avoid any dependency in column order.
5495: */
5496: IF (x_hookDocsInPmtTab.COUNT > 0) THEN
5497: FORALL i in x_hookDocsInPmtTab.FIRST..x_hookDocsInPmtTab.LAST
5498: INSERT INTO IBY_HOOK_DOCS_IN_PMT_T
5499: (
5500: payment_id,
5501: document_payable_id,
5502: calling_app_id,

Line 6789: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE

6785: object_version_number
6786: FROM IBY_HOOK_PAYMENTS_T;
6787:
6788: TYPE ty_payment_id IS TABLE OF
6789: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
6790: INDEX BY BINARY_INTEGER;
6791: TYPE ty_document_payable_id IS TABLE OF
6792: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
6793: INDEX BY BINARY_INTEGER;

Line 6792: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE

6788: TYPE ty_payment_id IS TABLE OF
6789: IBY_HOOK_DOCS_IN_PMT_T.payment_id%TYPE
6790: INDEX BY BINARY_INTEGER;
6791: TYPE ty_document_payable_id IS TABLE OF
6792: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
6793: INDEX BY BINARY_INTEGER;
6794: TYPE ty_calling_app_id IS TABLE OF
6795: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
6796: INDEX BY BINARY_INTEGER;

Line 6795: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE

6791: TYPE ty_document_payable_id IS TABLE OF
6792: IBY_HOOK_DOCS_IN_PMT_T.document_payable_id%TYPE
6793: INDEX BY BINARY_INTEGER;
6794: TYPE ty_calling_app_id IS TABLE OF
6795: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
6796: INDEX BY BINARY_INTEGER;
6797: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
6798: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
6799: INDEX BY BINARY_INTEGER;

Line 6798: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE

6794: TYPE ty_calling_app_id IS TABLE OF
6795: IBY_HOOK_DOCS_IN_PMT_T.calling_app_id%TYPE
6796: INDEX BY BINARY_INTEGER;
6797: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
6798: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
6799: INDEX BY BINARY_INTEGER;
6800: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
6801: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
6802: INDEX BY BINARY_INTEGER;

Line 6801: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE

6797: TYPE ty_calling_app_doc_unique_ref1 IS TABLE OF
6798: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref1%TYPE
6799: INDEX BY BINARY_INTEGER;
6800: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
6801: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
6802: INDEX BY BINARY_INTEGER;
6803: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
6804: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
6805: INDEX BY BINARY_INTEGER;

Line 6804: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE

6800: TYPE ty_calling_app_doc_unique_ref2 IS TABLE OF
6801: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref2%TYPE
6802: INDEX BY BINARY_INTEGER;
6803: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
6804: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
6805: INDEX BY BINARY_INTEGER;
6806: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
6807: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
6808: INDEX BY BINARY_INTEGER;

Line 6807: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE

6803: TYPE ty_calling_app_doc_unique_ref3 IS TABLE OF
6804: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref3%TYPE
6805: INDEX BY BINARY_INTEGER;
6806: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
6807: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
6808: INDEX BY BINARY_INTEGER;
6809: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
6810: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
6811: INDEX BY BINARY_INTEGER;

Line 6810: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE

6806: TYPE ty_calling_app_doc_unique_ref4 IS TABLE OF
6807: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref4%TYPE
6808: INDEX BY BINARY_INTEGER;
6809: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
6810: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
6811: INDEX BY BINARY_INTEGER;
6812: TYPE ty_document_amount IS TABLE OF
6813: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
6814: INDEX BY BINARY_INTEGER;

Line 6813: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE

6809: TYPE ty_calling_app_doc_unique_ref5 IS TABLE OF
6810: IBY_HOOK_DOCS_IN_PMT_T.calling_app_doc_unique_ref5%TYPE
6811: INDEX BY BINARY_INTEGER;
6812: TYPE ty_document_amount IS TABLE OF
6813: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
6814: INDEX BY BINARY_INTEGER;
6815: TYPE ty_document_currency_code IS TABLE OF
6816: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
6817: INDEX BY BINARY_INTEGER;

Line 6816: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE

6812: TYPE ty_document_amount IS TABLE OF
6813: IBY_HOOK_DOCS_IN_PMT_T.document_amount%TYPE
6814: INDEX BY BINARY_INTEGER;
6815: TYPE ty_document_currency_code IS TABLE OF
6816: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
6817: INDEX BY BINARY_INTEGER;
6818: TYPE ty_amount_withheld IS TABLE OF
6819: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
6820: INDEX BY BINARY_INTEGER;

Line 6819: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE

6815: TYPE ty_document_currency_code IS TABLE OF
6816: IBY_HOOK_DOCS_IN_PMT_T.document_currency_code%TYPE
6817: INDEX BY BINARY_INTEGER;
6818: TYPE ty_amount_withheld IS TABLE OF
6819: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
6820: INDEX BY BINARY_INTEGER;
6821: TYPE ty_dont_pay_flag IS TABLE OF
6822: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
6823: INDEX BY BINARY_INTEGER;

Line 6822: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE

6818: TYPE ty_amount_withheld IS TABLE OF
6819: IBY_HOOK_DOCS_IN_PMT_T.amount_withheld%TYPE
6820: INDEX BY BINARY_INTEGER;
6821: TYPE ty_dont_pay_flag IS TABLE OF
6822: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
6823: INDEX BY BINARY_INTEGER;
6824: TYPE ty_dont_pay_reason_code IS TABLE OF
6825: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
6826: INDEX BY BINARY_INTEGER;

Line 6825: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE

6821: TYPE ty_dont_pay_flag IS TABLE OF
6822: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_flag%TYPE
6823: INDEX BY BINARY_INTEGER;
6824: TYPE ty_dont_pay_reason_code IS TABLE OF
6825: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
6826: INDEX BY BINARY_INTEGER;
6827: TYPE ty_dont_pay_description IS TABLE OF
6828: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
6829: INDEX BY BINARY_INTEGER;

Line 6828: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE

6824: TYPE ty_dont_pay_reason_code IS TABLE OF
6825: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_reason_code%TYPE
6826: INDEX BY BINARY_INTEGER;
6827: TYPE ty_dont_pay_description IS TABLE OF
6828: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
6829: INDEX BY BINARY_INTEGER;
6830: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
6831: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
6832: INDEX BY BINARY_INTEGER;

Line 6831: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE

6827: TYPE ty_dont_pay_description IS TABLE OF
6828: IBY_HOOK_DOCS_IN_PMT_T.dont_pay_description%TYPE
6829: INDEX BY BINARY_INTEGER;
6830: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
6831: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
6832: INDEX BY BINARY_INTEGER;
6833: TYPE ty_internal_bank_account_id IS TABLE OF
6834: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
6835: INDEX BY BINARY_INTEGER;

Line 6834: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE

6830: TYPE ty_pay_proc_trxn_type_code IS TABLE OF
6831: IBY_HOOK_DOCS_IN_PMT_T.pay_proc_trxn_type_code%TYPE
6832: INDEX BY BINARY_INTEGER;
6833: TYPE ty_internal_bank_account_id IS TABLE OF
6834: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
6835: INDEX BY BINARY_INTEGER;
6836: TYPE ty_ext_payee_id IS TABLE OF
6837: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
6838: INDEX BY BINARY_INTEGER;

Line 6837: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE

6833: TYPE ty_internal_bank_account_id IS TABLE OF
6834: IBY_HOOK_DOCS_IN_PMT_T.internal_bank_account_id%TYPE
6835: INDEX BY BINARY_INTEGER;
6836: TYPE ty_ext_payee_id IS TABLE OF
6837: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
6838: INDEX BY BINARY_INTEGER;
6839: TYPE ty_payee_party_id IS TABLE OF
6840: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
6841: INDEX BY BINARY_INTEGER;

Line 6840: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE

6836: TYPE ty_ext_payee_id IS TABLE OF
6837: IBY_HOOK_DOCS_IN_PMT_T.ext_payee_id%TYPE
6838: INDEX BY BINARY_INTEGER;
6839: TYPE ty_payee_party_id IS TABLE OF
6840: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
6841: INDEX BY BINARY_INTEGER;
6842: TYPE ty_party_site_id IS TABLE OF
6843: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
6844: INDEX BY BINARY_INTEGER;

Line 6843: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE

6839: TYPE ty_payee_party_id IS TABLE OF
6840: IBY_HOOK_DOCS_IN_PMT_T.payee_party_id%TYPE
6841: INDEX BY BINARY_INTEGER;
6842: TYPE ty_party_site_id IS TABLE OF
6843: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
6844: INDEX BY BINARY_INTEGER;
6845: TYPE ty_supplier_site_id IS TABLE OF
6846: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
6847: INDEX BY BINARY_INTEGER;

Line 6846: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE

6842: TYPE ty_party_site_id IS TABLE OF
6843: IBY_HOOK_DOCS_IN_PMT_T.party_site_id%TYPE
6844: INDEX BY BINARY_INTEGER;
6845: TYPE ty_supplier_site_id IS TABLE OF
6846: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
6847: INDEX BY BINARY_INTEGER;
6848: TYPE ty_org_id IS TABLE OF
6849: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
6850: INDEX BY BINARY_INTEGER;

Line 6849: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE

6845: TYPE ty_supplier_site_id IS TABLE OF
6846: IBY_HOOK_DOCS_IN_PMT_T.supplier_site_id%TYPE
6847: INDEX BY BINARY_INTEGER;
6848: TYPE ty_org_id IS TABLE OF
6849: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
6850: INDEX BY BINARY_INTEGER;
6851: TYPE ty_org_type IS TABLE OF
6852: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
6853: INDEX BY BINARY_INTEGER;

Line 6852: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE

6848: TYPE ty_org_id IS TABLE OF
6849: IBY_HOOK_DOCS_IN_PMT_T.org_id%TYPE
6850: INDEX BY BINARY_INTEGER;
6851: TYPE ty_org_type IS TABLE OF
6852: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
6853: INDEX BY BINARY_INTEGER;
6854: TYPE ty_external_bank_account_id IS TABLE OF
6855: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
6856: INDEX BY BINARY_INTEGER;

Line 6855: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE

6851: TYPE ty_org_type IS TABLE OF
6852: IBY_HOOK_DOCS_IN_PMT_T.org_type%TYPE
6853: INDEX BY BINARY_INTEGER;
6854: TYPE ty_external_bank_account_id IS TABLE OF
6855: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
6856: INDEX BY BINARY_INTEGER;
6857: TYPE ty_payment_curr_discount_taken IS TABLE OF
6858: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
6859: INDEX BY BINARY_INTEGER;

Line 6858: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE

6854: TYPE ty_external_bank_account_id IS TABLE OF
6855: IBY_HOOK_DOCS_IN_PMT_T.external_bank_account_id%TYPE
6856: INDEX BY BINARY_INTEGER;
6857: TYPE ty_payment_curr_discount_taken IS TABLE OF
6858: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
6859: INDEX BY BINARY_INTEGER;
6860: TYPE ty_created_by IS TABLE OF
6861: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
6862: INDEX BY BINARY_INTEGER;

Line 6861: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE

6857: TYPE ty_payment_curr_discount_taken IS TABLE OF
6858: IBY_HOOK_DOCS_IN_PMT_T.payment_curr_discount_taken%TYPE
6859: INDEX BY BINARY_INTEGER;
6860: TYPE ty_created_by IS TABLE OF
6861: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
6862: INDEX BY BINARY_INTEGER;
6863: TYPE ty_creation_date IS TABLE OF
6864: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
6865: INDEX BY BINARY_INTEGER;

Line 6864: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE

6860: TYPE ty_created_by IS TABLE OF
6861: IBY_HOOK_DOCS_IN_PMT_T.created_by%TYPE
6862: INDEX BY BINARY_INTEGER;
6863: TYPE ty_creation_date IS TABLE OF
6864: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
6865: INDEX BY BINARY_INTEGER;
6866: TYPE ty_last_updated_by IS TABLE OF
6867: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
6868: INDEX BY BINARY_INTEGER;

Line 6867: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE

6863: TYPE ty_creation_date IS TABLE OF
6864: IBY_HOOK_DOCS_IN_PMT_T.creation_date%TYPE
6865: INDEX BY BINARY_INTEGER;
6866: TYPE ty_last_updated_by IS TABLE OF
6867: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
6868: INDEX BY BINARY_INTEGER;
6869: TYPE ty_last_update_date IS TABLE OF
6870: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
6871: INDEX BY BINARY_INTEGER;

Line 6870: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE

6866: TYPE ty_last_updated_by IS TABLE OF
6867: IBY_HOOK_DOCS_IN_PMT_T.last_updated_by%TYPE
6868: INDEX BY BINARY_INTEGER;
6869: TYPE ty_last_update_date IS TABLE OF
6870: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
6871: INDEX BY BINARY_INTEGER;
6872: TYPE ty_last_update_login IS TABLE OF
6873: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
6874: INDEX BY BINARY_INTEGER;

Line 6873: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE

6869: TYPE ty_last_update_date IS TABLE OF
6870: IBY_HOOK_DOCS_IN_PMT_T.last_update_date%TYPE
6871: INDEX BY BINARY_INTEGER;
6872: TYPE ty_last_update_login IS TABLE OF
6873: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
6874: INDEX BY BINARY_INTEGER;
6875: TYPE ty_object_version_number IS TABLE OF
6876: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
6877: INDEX BY BINARY_INTEGER;

Line 6876: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE

6872: TYPE ty_last_update_login IS TABLE OF
6873: IBY_HOOK_DOCS_IN_PMT_T.last_update_login%TYPE
6874: INDEX BY BINARY_INTEGER;
6875: TYPE ty_object_version_number IS TABLE OF
6876: IBY_HOOK_DOCS_IN_PMT_T.object_version_number%TYPE
6877: INDEX BY BINARY_INTEGER;
6878:
6879:
6880: ll_payment_id ty_payment_id;

Line 6946: FROM IBY_HOOK_DOCS_IN_PMT_T

6942: last_updated_by,
6943: last_update_date,
6944: last_update_login,
6945: object_version_number
6946: FROM IBY_HOOK_DOCS_IN_PMT_T
6947: ORDER BY document_payable_id;
6948:
6949: BEGIN
6950: