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_PAYMENTS_T

Line 5045: | IBY_HOOK_PAYMENTS_TEMP. This is a temporary table that the

5041: | performPreHookProcess
5042: |
5043: | PURPOSE:
5044: | Inserts all successfuly validated payments into
5045: | IBY_HOOK_PAYMENTS_TEMP. This is a temporary table that the
5046: | calling app can access to see what payments have been
5047: | created. The calling app can also update the payments / fail
5048: | the payments in the temporary table, and the payment creation
5049: | program will update it's payments accordingly.

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 5414: DELETE IBY_HOOK_PAYMENTS_T;

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:
5418: /*

Line 5419: * Create arrays for each column of the IBY_HOOK_PAYMENTS_T table.

5415: print_debuginfo(l_module_name, 'Finished deleting records from '
5416: || 'hook tables .. ');
5417:
5418: /*
5419: * Create arrays for each column of the IBY_HOOK_PAYMENTS_T table.
5420: * These arrays will be used in the bulk insert.
5421: */
5422: IF (x_hookDocsInPmtTab.COUNT > 0) THEN
5423: FOR i in x_hookDocsInPmtTab.FIRST..x_hookDocsInPmtTab.LAST LOOP

Line 5568: * Bulk insert records into IBY_HOOK_PAYMENTS_T using named

5564: ;
5565: END IF; -- if hook document count > 0
5566:
5567: /*
5568: * Bulk insert records into IBY_HOOK_PAYMENTS_T using named
5569: * columns. This will avoid any dependency in column order.
5570: */
5571:
5572: -- FOR i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST

Line 5575: INSERT INTO IBY_HOOK_PAYMENTS_T

5571:
5572: -- FOR i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST
5573:
5574: FORALL i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST
5575: INSERT INTO IBY_HOOK_PAYMENTS_T
5576: (
5577: calling_app_id,
5578: call_app_pay_service_req_code,
5579: payment_service_request_id,

Line 5675: | Copies back the payments from the IBY_HOOK_PAYMENTS_TEMP temporary

Line 6650: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE

6646: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
6647: '.getAdjustedPaymentData';
6648:
6649: TYPE t_calling_app_id IS TABLE OF
6650: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
6651: INDEX BY BINARY_INTEGER;
6652: TYPE t_call_app_pay_srv_req_code IS TABLE OF
6653: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
6654: INDEX BY BINARY_INTEGER;

Line 6653: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE

6649: TYPE t_calling_app_id IS TABLE OF
6650: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
6651: INDEX BY BINARY_INTEGER;
6652: TYPE t_call_app_pay_srv_req_code IS TABLE OF
6653: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
6654: INDEX BY BINARY_INTEGER;
6655: TYPE t_payment_service_request_id IS TABLE OF
6656: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
6657: INDEX BY BINARY_INTEGER;

Line 6656: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE

6652: TYPE t_call_app_pay_srv_req_code IS TABLE OF
6653: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
6654: INDEX BY BINARY_INTEGER;
6655: TYPE t_payment_service_request_id IS TABLE OF
6656: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
6657: INDEX BY BINARY_INTEGER;
6658: TYPE t_payment_id IS TABLE OF
6659: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
6660: INDEX BY BINARY_INTEGER;

Line 6659: IBY_HOOK_PAYMENTS_T.payment_id%TYPE

6655: TYPE t_payment_service_request_id IS TABLE OF
6656: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
6657: INDEX BY BINARY_INTEGER;
6658: TYPE t_payment_id IS TABLE OF
6659: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
6660: INDEX BY BINARY_INTEGER;
6661: TYPE t_payment_amount IS TABLE OF
6662: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
6663: INDEX BY BINARY_INTEGER;

Line 6662: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE

6658: TYPE t_payment_id IS TABLE OF
6659: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
6660: INDEX BY BINARY_INTEGER;
6661: TYPE t_payment_amount IS TABLE OF
6662: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
6663: INDEX BY BINARY_INTEGER;
6664: TYPE t_payment_currency_code IS TABLE OF
6665: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
6666: INDEX BY BINARY_INTEGER;

Line 6665: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE

6661: TYPE t_payment_amount IS TABLE OF
6662: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
6663: INDEX BY BINARY_INTEGER;
6664: TYPE t_payment_currency_code IS TABLE OF
6665: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
6666: INDEX BY BINARY_INTEGER;
6667: TYPE t_dont_pay_flag IS TABLE OF
6668: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
6669: INDEX BY BINARY_INTEGER;

Line 6668: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE

6664: TYPE t_payment_currency_code IS TABLE OF
6665: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
6666: INDEX BY BINARY_INTEGER;
6667: TYPE t_dont_pay_flag IS TABLE OF
6668: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
6669: INDEX BY BINARY_INTEGER;
6670: TYPE t_dont_pay_reason_code IS TABLE OF
6671: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
6672: INDEX BY BINARY_INTEGER;

Line 6671: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE

6667: TYPE t_dont_pay_flag IS TABLE OF
6668: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
6669: INDEX BY BINARY_INTEGER;
6670: TYPE t_dont_pay_reason_code IS TABLE OF
6671: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
6672: INDEX BY BINARY_INTEGER;
6673: TYPE t_dont_pay_description IS TABLE OF
6674: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
6675: INDEX BY BINARY_INTEGER;

Line 6674: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE

6670: TYPE t_dont_pay_reason_code IS TABLE OF
6671: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
6672: INDEX BY BINARY_INTEGER;
6673: TYPE t_dont_pay_description IS TABLE OF
6674: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
6675: INDEX BY BINARY_INTEGER;
6676: TYPE t_internal_bank_account_id IS TABLE OF
6677: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
6678: INDEX BY BINARY_INTEGER;

Line 6677: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE

6673: TYPE t_dont_pay_description IS TABLE OF
6674: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
6675: INDEX BY BINARY_INTEGER;
6676: TYPE t_internal_bank_account_id IS TABLE OF
6677: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
6678: INDEX BY BINARY_INTEGER;
6679: TYPE t_ext_payee_id IS TABLE OF
6680: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
6681: INDEX BY BINARY_INTEGER;

Line 6680: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE

6676: TYPE t_internal_bank_account_id IS TABLE OF
6677: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
6678: INDEX BY BINARY_INTEGER;
6679: TYPE t_ext_payee_id IS TABLE OF
6680: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
6681: INDEX BY BINARY_INTEGER;
6682: TYPE t_payee_party_id IS TABLE OF
6683: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
6684: INDEX BY BINARY_INTEGER;

Line 6683: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE

6679: TYPE t_ext_payee_id IS TABLE OF
6680: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
6681: INDEX BY BINARY_INTEGER;
6682: TYPE t_payee_party_id IS TABLE OF
6683: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
6684: INDEX BY BINARY_INTEGER;
6685: TYPE t_party_site_id IS TABLE OF
6686: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
6687: INDEX BY BINARY_INTEGER;

Line 6686: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE

6682: TYPE t_payee_party_id IS TABLE OF
6683: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
6684: INDEX BY BINARY_INTEGER;
6685: TYPE t_party_site_id IS TABLE OF
6686: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
6687: INDEX BY BINARY_INTEGER;
6688: TYPE t_supplier_site_id IS TABLE OF
6689: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
6690: INDEX BY BINARY_INTEGER;

Line 6689: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE

6685: TYPE t_party_site_id IS TABLE OF
6686: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
6687: INDEX BY BINARY_INTEGER;
6688: TYPE t_supplier_site_id IS TABLE OF
6689: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
6690: INDEX BY BINARY_INTEGER;
6691: TYPE t_org_id IS TABLE OF
6692: IBY_HOOK_PAYMENTS_T.org_id%TYPE
6693: INDEX BY BINARY_INTEGER;

Line 6692: IBY_HOOK_PAYMENTS_T.org_id%TYPE

6688: TYPE t_supplier_site_id IS TABLE OF
6689: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
6690: INDEX BY BINARY_INTEGER;
6691: TYPE t_org_id IS TABLE OF
6692: IBY_HOOK_PAYMENTS_T.org_id%TYPE
6693: INDEX BY BINARY_INTEGER;
6694: TYPE t_org_type IS TABLE OF
6695: IBY_HOOK_PAYMENTS_T.org_type%TYPE
6696: INDEX BY BINARY_INTEGER;

Line 6695: IBY_HOOK_PAYMENTS_T.org_type%TYPE

6691: TYPE t_org_id IS TABLE OF
6692: IBY_HOOK_PAYMENTS_T.org_id%TYPE
6693: INDEX BY BINARY_INTEGER;
6694: TYPE t_org_type IS TABLE OF
6695: IBY_HOOK_PAYMENTS_T.org_type%TYPE
6696: INDEX BY BINARY_INTEGER;
6697: TYPE t_external_bank_account_id IS TABLE OF
6698: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
6699: INDEX BY BINARY_INTEGER;

Line 6698: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE

6694: TYPE t_org_type IS TABLE OF
6695: IBY_HOOK_PAYMENTS_T.org_type%TYPE
6696: INDEX BY BINARY_INTEGER;
6697: TYPE t_external_bank_account_id IS TABLE OF
6698: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
6699: INDEX BY BINARY_INTEGER;
6700: TYPE t_discount_amount_taken IS TABLE OF
6701: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
6702: INDEX BY BINARY_INTEGER;

Line 6701: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE

6697: TYPE t_external_bank_account_id IS TABLE OF
6698: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
6699: INDEX BY BINARY_INTEGER;
6700: TYPE t_discount_amount_taken IS TABLE OF
6701: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
6702: INDEX BY BINARY_INTEGER;
6703: TYPE t_payment_date IS TABLE OF
6704: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
6705: INDEX BY BINARY_INTEGER;

Line 6704: IBY_HOOK_PAYMENTS_T.payment_date%TYPE

6700: TYPE t_discount_amount_taken IS TABLE OF
6701: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
6702: INDEX BY BINARY_INTEGER;
6703: TYPE t_payment_date IS TABLE OF
6704: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
6705: INDEX BY BINARY_INTEGER;
6706: TYPE t_bank_charge_amount IS TABLE OF
6707: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
6708: INDEX BY BINARY_INTEGER;

Line 6707: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE

6703: TYPE t_payment_date IS TABLE OF
6704: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
6705: INDEX BY BINARY_INTEGER;
6706: TYPE t_bank_charge_amount IS TABLE OF
6707: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
6708: INDEX BY BINARY_INTEGER;
6709: TYPE t_created_by IS TABLE OF
6710: IBY_HOOK_PAYMENTS_T.created_by%TYPE
6711: INDEX BY BINARY_INTEGER;

Line 6710: IBY_HOOK_PAYMENTS_T.created_by%TYPE

6706: TYPE t_bank_charge_amount IS TABLE OF
6707: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
6708: INDEX BY BINARY_INTEGER;
6709: TYPE t_created_by IS TABLE OF
6710: IBY_HOOK_PAYMENTS_T.created_by%TYPE
6711: INDEX BY BINARY_INTEGER;
6712: TYPE t_creation_date IS TABLE OF
6713: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
6714: INDEX BY BINARY_INTEGER;

Line 6713: IBY_HOOK_PAYMENTS_T.creation_date%TYPE

6709: TYPE t_created_by IS TABLE OF
6710: IBY_HOOK_PAYMENTS_T.created_by%TYPE
6711: INDEX BY BINARY_INTEGER;
6712: TYPE t_creation_date IS TABLE OF
6713: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
6714: INDEX BY BINARY_INTEGER;
6715: TYPE t_last_updated_by IS TABLE OF
6716: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
6717: INDEX BY BINARY_INTEGER;

Line 6716: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE

6712: TYPE t_creation_date IS TABLE OF
6713: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
6714: INDEX BY BINARY_INTEGER;
6715: TYPE t_last_updated_by IS TABLE OF
6716: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
6717: INDEX BY BINARY_INTEGER;
6718: TYPE t_last_update_date IS TABLE OF
6719: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
6720: INDEX BY BINARY_INTEGER;

Line 6719: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE

6715: TYPE t_last_updated_by IS TABLE OF
6716: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
6717: INDEX BY BINARY_INTEGER;
6718: TYPE t_last_update_date IS TABLE OF
6719: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
6720: INDEX BY BINARY_INTEGER;
6721: TYPE t_last_update_login IS TABLE OF
6722: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
6723: INDEX BY BINARY_INTEGER;

Line 6722: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE

6718: TYPE t_last_update_date IS TABLE OF
6719: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
6720: INDEX BY BINARY_INTEGER;
6721: TYPE t_last_update_login IS TABLE OF
6722: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
6723: INDEX BY BINARY_INTEGER;
6724: TYPE t_object_version_number IS TABLE OF
6725: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE
6726: INDEX BY BINARY_INTEGER;

Line 6725: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE

6721: TYPE t_last_update_login IS TABLE OF
6722: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
6723: INDEX BY BINARY_INTEGER;
6724: TYPE t_object_version_number IS TABLE OF
6725: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE
6726: INDEX BY BINARY_INTEGER;
6727:
6728: l_calling_app_id t_calling_app_id;
6729: l_call_app_pay_srv_req_code t_call_app_pay_srv_req_code;

Line 6786: FROM IBY_HOOK_PAYMENTS_T;

6782: last_updated_by,
6783: last_update_date,
6784: last_update_login,
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;