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 289: IBY_HOOK_PAYMENTS_T

285: select
286: payment_id,
287: payment_amount
288: from
289: IBY_HOOK_PAYMENTS_T
290: ;
291:
292:
293: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

11205: | performPreHookProcess
11206: |
11207: | PURPOSE:
11208: | Inserts all successfuly validated payments into
11209: | IBY_HOOK_PAYMENTS_TEMP. This is a temporary table that the
11210: | calling app can access to see what payments have been
11211: | created. The calling app can also update the payments / fail
11212: | the payments in the temporary table, and the payment creation
11213: | program will update it's payments accordingly.

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

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 .. ');
11595: END IF;

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

11594: || 'hook tables .. ');
11595: END IF;
11596:
11597: /*
11598: * Create arrays for each column of the IBY_HOOK_PAYMENTS_T table.
11599: * These arrays will be used in the bulk insert.
11600: */
11601: IF (x_hookDocsInPmtTab.COUNT > 0) THEN
11602: FOR i in x_hookDocsInPmtTab.FIRST..x_hookDocsInPmtTab.LAST LOOP

Line 11747: * Bulk insert records into IBY_HOOK_PAYMENTS_T using named

11743: ;
11744: END IF; -- if hook document count > 0
11745:
11746: /*
11747: * Bulk insert records into IBY_HOOK_PAYMENTS_T using named
11748: * columns. This will avoid any dependency in column order.
11749: */
11750:
11751: -- FOR i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST

Line 11754: INSERT INTO IBY_HOOK_PAYMENTS_T

11750:
11751: -- FOR i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST
11752:
11753: FORALL i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST
11754: INSERT INTO IBY_HOOK_PAYMENTS_T
11755: (
11756: calling_app_id,
11757: call_app_pay_service_req_code,
11758: payment_service_request_id,

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

11858: | performPreHookProcess
11859: |
11860: | PURPOSE:
11861: | Inserts all successfuly validated payments into
11862: | IBY_HOOK_PAYMENTS_TEMP. This is a temporary table that the
11863: | calling app can access to see what payments have been
11864: | created. The calling app can also update the payments / fail
11865: | the payments in the temporary table, and the payment creation
11866: | program will update it's payments accordingly.

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

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 .. ');
12163: END IF;

Line 12168: * Bulk insert records into IBY_HOOK_PAYMENTS_T using named

12164:
12165: /*
12166:
12167: /*
12168: * Bulk insert records into IBY_HOOK_PAYMENTS_T using named
12169: * columns. This will avoid any dependency in column order.
12170: */
12171:
12172: -- FOR i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST

Line 12175: INSERT INTO IBY_HOOK_PAYMENTS_T

12171:
12172: -- FOR i in paymentTab.calling_app_id.FIRST .. paymentTab.calling_app_id.LAST
12173:
12174: -- FORALL i in paymentTab.payment_id.FIRST .. paymentTab.payment_id.LAST
12175: INSERT INTO IBY_HOOK_PAYMENTS_T
12176: (
12177: calling_app_id,
12178: call_app_pay_service_req_code,
12179: payment_service_request_id,

Line 12316: FROM iby_docs_in_pmt_gt src, iby_hook_payments_t ihpt

12312: src.LAST_UPDATED_BY,
12313: src.LAST_UPDATE_DATE,
12314: src.LAST_UPDATE_LOGIN,
12315: src.OBJECT_VERSION_NUMBER
12316: FROM iby_docs_in_pmt_gt src, iby_hook_payments_t ihpt
12317: WHERE src.payment_id = ihpt.payment_id
12318: AND src.document_status = DOC_STATUS_PAY_CREATED;
12319:
12320: l_DocsInPmtCount := SQL%ROWCOUNT;

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

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

Line 13026: (select B.payment_amount from IBY_HOOK_PAYMENTS_T B where A.payment_id = B.payment_id

13022: payment_amount
13023: from
13024: iby_payments_all A
13025: where payment_amount =
13026: (select B.payment_amount from IBY_HOOK_PAYMENTS_T B where A.payment_id = B.payment_id
13027: AND A.payment_service_request_id = B.payment_service_request_id)
13028: ;
13029:
13030:

Line 13061: IBY_HOOK_PAYMENTS_T

13057: last_update_date ,
13058: last_update_login ,
13059: object_version_number
13060: FROM
13061: IBY_HOOK_PAYMENTS_T
13062: WHERE
13063: call_app_pay_service_req_code=
13064: p_cap_payreq_cd
13065: ;

Line 13196: UPDATE iby_hook_payments_t

13192:
13193: */
13194:
13195:
13196: UPDATE iby_hook_payments_t
13197: SET payment_amount = 0
13198: WHERE dont_pay_flag = 'Y';
13199: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13200: print_debuginfo(l_module_name, 'After updating iby_hooks table for pmt amt');

Line 13246: FROM IBY_HOOK_PAYMENTS_T

13242:
13243:
13244: SELECT COUNT(PAYMENT_ID)
13245: INTO l_posthook_count
13246: FROM IBY_HOOK_PAYMENTS_T
13247: WHERE
13248: payment_service_request_id =
13249: (select payment_service_request_id
13250: from iby_pay_service_requests where

Line 13326: WHERE payment_id IN (select payment_id from iby_hook_payments_t where dont_pay_flag = 'Y');

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:
13329:
13330: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 13355: from IBY_HOOK_PAYMENTS_T B

13351: UPDATE IBY_PAYMENTS_ALL A
13352: SET (PAYMENT_AMOUNT, DISCOUNT_AMOUNT_TAKEN, bank_charge_amount)
13353: =
13354: (SELECT NVL(B.PAYMENT_AMOUNT,PAYMENT_AMOUNT),B.DISCOUNT_AMOUNT_TAKEN,B.bank_charge_amount
13355: from IBY_HOOK_PAYMENTS_T B
13356: where A.PAYMENT_ID= B.PAYMENT_ID)
13357: ;*/
13358:
13359:

Line 13364: from IBY_HOOK_PAYMENTS_T B

13360: /*
13361:
13362: UPDATE IBY_PAYMENTS_ALL A
13363: SET PAYMENT_AMOUNT = (SELECT B.PAYMENT_AMOUNT
13364: from IBY_HOOK_PAYMENTS_T B
13365: where A.PAYMENT_ID= B.PAYMENT_ID);
13366: */
13367:
13368: /*

Line 13372: from IBY_HOOK_PAYMENTS_T B

13368: /*
13369: UPDATE IBY_PAYMENTS_ALL A
13370: SET
13371: DISCOUNT_AMOUNT_TAKEN= (SELECT B.DISCOUNT_AMOUNT_TAKEN
13372: from IBY_HOOK_PAYMENTS_T B
13373: where A.PAYMENT_ID= B.PAYMENT_ID),
13374: bank_charge_amount = (SELECT B.bank_charge_amount
13375: from IBY_HOOK_PAYMENTS_T B
13376: where A.PAYMENT_ID= B.PAYMENT_ID)

Line 13375: from IBY_HOOK_PAYMENTS_T B

13371: DISCOUNT_AMOUNT_TAKEN= (SELECT B.DISCOUNT_AMOUNT_TAKEN
13372: from IBY_HOOK_PAYMENTS_T B
13373: where A.PAYMENT_ID= B.PAYMENT_ID),
13374: bank_charge_amount = (SELECT B.bank_charge_amount
13375: from IBY_HOOK_PAYMENTS_T B
13376: where A.PAYMENT_ID= B.PAYMENT_ID)
13377: ; */
13378:
13379: MERGE /*+ leading(ihp) */

Line 13381: USING IBY_HOOK_PAYMENTS_T ihp ON(ibpa.payment_id = ihp.payment_id

13377: ; */
13378:
13379: MERGE /*+ leading(ihp) */
13380: INTO IBY_PAYMENTS_ALL ibpa
13381: USING IBY_HOOK_PAYMENTS_T ihp ON(ibpa.payment_id = ihp.payment_id
13382: AND ibpa.payment_service_request_id = ihp.payment_service_request_id)
13383: WHEN MATCHED THEN UPDATE
13384: SET ibpa.PAYMENT_AMOUNT = ihp.PAYMENT_AMOUNT,
13385: ibpa.DISCOUNT_AMOUNT_TAKEN = ihp.DISCOUNT_AMOUNT_TAKEN,

Line 13393: IBY_HOOK_PAYMENTS_T B

13389: /*
13390: UPDATE IBY_PAYMENTS_ALL A
13391: SET PAYMENT_STATUS =
13392: (SELECT PAY_STATUS_CA_FAILED FROM
13393: IBY_HOOK_PAYMENTS_T B
13394: WHERE A.PAYMENT_ID= B.PAYMENT_ID AND
13395: B.DONT_PAY_FLAG ='Y')
13396: ;
13397: */

Line 13401: USING IBY_HOOK_PAYMENTS_T ihp ON(ibpa.payment_id = ihp.payment_id

13397: */
13398:
13399: MERGE /*+ leading(ihp)*/
13400: INTO IBY_PAYMENTS_ALL ibpa
13401: USING IBY_HOOK_PAYMENTS_T ihp ON(ibpa.payment_id = ihp.payment_id
13402: AND ibpa.payment_service_request_id = ihp.payment_service_request_id
13403: AND ihp.DONT_PAY_FLAG ='Y')
13404: WHEN MATCHED THEN UPDATE
13405: SET ibpa.PAYMENT_STATUS = PAY_STATUS_CA_FAILED

Line 13424: from iby_hook_payments_t

13420: END IF;
13421:
13422: select payment_amount
13423: into l_hook_pmt_amt
13424: from iby_hook_payments_t
13425: where payment_id = hookPmtsTab(j).payment_id;
13426: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13427: print_debuginfo(l_module_name, 'Hook Payment Amount: '
13428: || l_hook_pmt_amt

Line 14528: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE

14524: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
14525: '.getAdjustedPaymentData';
14526:
14527: TYPE t_calling_app_id IS TABLE OF
14528: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
14529: INDEX BY BINARY_INTEGER;
14530: TYPE t_call_app_pay_srv_req_code IS TABLE OF
14531: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
14532: INDEX BY BINARY_INTEGER;

Line 14531: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE

14527: TYPE t_calling_app_id IS TABLE OF
14528: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
14529: INDEX BY BINARY_INTEGER;
14530: TYPE t_call_app_pay_srv_req_code IS TABLE OF
14531: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
14532: INDEX BY BINARY_INTEGER;
14533: TYPE t_payment_service_request_id IS TABLE OF
14534: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
14535: INDEX BY BINARY_INTEGER;

Line 14534: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE

14530: TYPE t_call_app_pay_srv_req_code IS TABLE OF
14531: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
14532: INDEX BY BINARY_INTEGER;
14533: TYPE t_payment_service_request_id IS TABLE OF
14534: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
14535: INDEX BY BINARY_INTEGER;
14536: TYPE t_payment_id IS TABLE OF
14537: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
14538: INDEX BY BINARY_INTEGER;

Line 14537: IBY_HOOK_PAYMENTS_T.payment_id%TYPE

14533: TYPE t_payment_service_request_id IS TABLE OF
14534: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
14535: INDEX BY BINARY_INTEGER;
14536: TYPE t_payment_id IS TABLE OF
14537: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
14538: INDEX BY BINARY_INTEGER;
14539: TYPE t_payment_amount IS TABLE OF
14540: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
14541: INDEX BY BINARY_INTEGER;

Line 14540: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE

14536: TYPE t_payment_id IS TABLE OF
14537: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
14538: INDEX BY BINARY_INTEGER;
14539: TYPE t_payment_amount IS TABLE OF
14540: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
14541: INDEX BY BINARY_INTEGER;
14542: TYPE t_payment_currency_code IS TABLE OF
14543: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
14544: INDEX BY BINARY_INTEGER;

Line 14543: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE

14539: TYPE t_payment_amount IS TABLE OF
14540: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
14541: INDEX BY BINARY_INTEGER;
14542: TYPE t_payment_currency_code IS TABLE OF
14543: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
14544: INDEX BY BINARY_INTEGER;
14545: TYPE t_dont_pay_flag IS TABLE OF
14546: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
14547: INDEX BY BINARY_INTEGER;

Line 14546: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE

14542: TYPE t_payment_currency_code IS TABLE OF
14543: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
14544: INDEX BY BINARY_INTEGER;
14545: TYPE t_dont_pay_flag IS TABLE OF
14546: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
14547: INDEX BY BINARY_INTEGER;
14548: TYPE t_dont_pay_reason_code IS TABLE OF
14549: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
14550: INDEX BY BINARY_INTEGER;

Line 14549: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE

14545: TYPE t_dont_pay_flag IS TABLE OF
14546: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
14547: INDEX BY BINARY_INTEGER;
14548: TYPE t_dont_pay_reason_code IS TABLE OF
14549: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
14550: INDEX BY BINARY_INTEGER;
14551: TYPE t_dont_pay_description IS TABLE OF
14552: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
14553: INDEX BY BINARY_INTEGER;

Line 14552: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE

14548: TYPE t_dont_pay_reason_code IS TABLE OF
14549: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
14550: INDEX BY BINARY_INTEGER;
14551: TYPE t_dont_pay_description IS TABLE OF
14552: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
14553: INDEX BY BINARY_INTEGER;
14554: TYPE t_internal_bank_account_id IS TABLE OF
14555: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
14556: INDEX BY BINARY_INTEGER;

Line 14555: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE

14551: TYPE t_dont_pay_description IS TABLE OF
14552: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
14553: INDEX BY BINARY_INTEGER;
14554: TYPE t_internal_bank_account_id IS TABLE OF
14555: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
14556: INDEX BY BINARY_INTEGER;
14557: TYPE t_ext_payee_id IS TABLE OF
14558: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
14559: INDEX BY BINARY_INTEGER;

Line 14558: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE

14554: TYPE t_internal_bank_account_id IS TABLE OF
14555: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
14556: INDEX BY BINARY_INTEGER;
14557: TYPE t_ext_payee_id IS TABLE OF
14558: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
14559: INDEX BY BINARY_INTEGER;
14560: TYPE t_payee_party_id IS TABLE OF
14561: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
14562: INDEX BY BINARY_INTEGER;

Line 14561: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE

14557: TYPE t_ext_payee_id IS TABLE OF
14558: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
14559: INDEX BY BINARY_INTEGER;
14560: TYPE t_payee_party_id IS TABLE OF
14561: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
14562: INDEX BY BINARY_INTEGER;
14563: TYPE t_party_site_id IS TABLE OF
14564: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
14565: INDEX BY BINARY_INTEGER;

Line 14564: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE

14560: TYPE t_payee_party_id IS TABLE OF
14561: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
14562: INDEX BY BINARY_INTEGER;
14563: TYPE t_party_site_id IS TABLE OF
14564: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
14565: INDEX BY BINARY_INTEGER;
14566: TYPE t_supplier_site_id IS TABLE OF
14567: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
14568: INDEX BY BINARY_INTEGER;

Line 14567: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE

14563: TYPE t_party_site_id IS TABLE OF
14564: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
14565: INDEX BY BINARY_INTEGER;
14566: TYPE t_supplier_site_id IS TABLE OF
14567: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
14568: INDEX BY BINARY_INTEGER;
14569: TYPE t_org_id IS TABLE OF
14570: IBY_HOOK_PAYMENTS_T.org_id%TYPE
14571: INDEX BY BINARY_INTEGER;

Line 14570: IBY_HOOK_PAYMENTS_T.org_id%TYPE

14566: TYPE t_supplier_site_id IS TABLE OF
14567: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
14568: INDEX BY BINARY_INTEGER;
14569: TYPE t_org_id IS TABLE OF
14570: IBY_HOOK_PAYMENTS_T.org_id%TYPE
14571: INDEX BY BINARY_INTEGER;
14572: TYPE t_org_type IS TABLE OF
14573: IBY_HOOK_PAYMENTS_T.org_type%TYPE
14574: INDEX BY BINARY_INTEGER;

Line 14573: IBY_HOOK_PAYMENTS_T.org_type%TYPE

14569: TYPE t_org_id IS TABLE OF
14570: IBY_HOOK_PAYMENTS_T.org_id%TYPE
14571: INDEX BY BINARY_INTEGER;
14572: TYPE t_org_type IS TABLE OF
14573: IBY_HOOK_PAYMENTS_T.org_type%TYPE
14574: INDEX BY BINARY_INTEGER;
14575: TYPE t_external_bank_account_id IS TABLE OF
14576: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
14577: INDEX BY BINARY_INTEGER;

Line 14576: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE

14572: TYPE t_org_type IS TABLE OF
14573: IBY_HOOK_PAYMENTS_T.org_type%TYPE
14574: INDEX BY BINARY_INTEGER;
14575: TYPE t_external_bank_account_id IS TABLE OF
14576: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
14577: INDEX BY BINARY_INTEGER;
14578: TYPE t_discount_amount_taken IS TABLE OF
14579: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
14580: INDEX BY BINARY_INTEGER;

Line 14579: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE

14575: TYPE t_external_bank_account_id IS TABLE OF
14576: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
14577: INDEX BY BINARY_INTEGER;
14578: TYPE t_discount_amount_taken IS TABLE OF
14579: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
14580: INDEX BY BINARY_INTEGER;
14581: TYPE t_payment_date IS TABLE OF
14582: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
14583: INDEX BY BINARY_INTEGER;

Line 14582: IBY_HOOK_PAYMENTS_T.payment_date%TYPE

14578: TYPE t_discount_amount_taken IS TABLE OF
14579: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
14580: INDEX BY BINARY_INTEGER;
14581: TYPE t_payment_date IS TABLE OF
14582: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
14583: INDEX BY BINARY_INTEGER;
14584: TYPE t_bank_charge_amount IS TABLE OF
14585: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
14586: INDEX BY BINARY_INTEGER;

Line 14585: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE

14581: TYPE t_payment_date IS TABLE OF
14582: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
14583: INDEX BY BINARY_INTEGER;
14584: TYPE t_bank_charge_amount IS TABLE OF
14585: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
14586: INDEX BY BINARY_INTEGER;
14587: TYPE t_created_by IS TABLE OF
14588: IBY_HOOK_PAYMENTS_T.created_by%TYPE
14589: INDEX BY BINARY_INTEGER;

Line 14588: IBY_HOOK_PAYMENTS_T.created_by%TYPE

14584: TYPE t_bank_charge_amount IS TABLE OF
14585: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
14586: INDEX BY BINARY_INTEGER;
14587: TYPE t_created_by IS TABLE OF
14588: IBY_HOOK_PAYMENTS_T.created_by%TYPE
14589: INDEX BY BINARY_INTEGER;
14590: TYPE t_creation_date IS TABLE OF
14591: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
14592: INDEX BY BINARY_INTEGER;

Line 14591: IBY_HOOK_PAYMENTS_T.creation_date%TYPE

14587: TYPE t_created_by IS TABLE OF
14588: IBY_HOOK_PAYMENTS_T.created_by%TYPE
14589: INDEX BY BINARY_INTEGER;
14590: TYPE t_creation_date IS TABLE OF
14591: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
14592: INDEX BY BINARY_INTEGER;
14593: TYPE t_last_updated_by IS TABLE OF
14594: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
14595: INDEX BY BINARY_INTEGER;

Line 14594: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE

14590: TYPE t_creation_date IS TABLE OF
14591: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
14592: INDEX BY BINARY_INTEGER;
14593: TYPE t_last_updated_by IS TABLE OF
14594: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
14595: INDEX BY BINARY_INTEGER;
14596: TYPE t_last_update_date IS TABLE OF
14597: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
14598: INDEX BY BINARY_INTEGER;

Line 14597: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE

14593: TYPE t_last_updated_by IS TABLE OF
14594: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
14595: INDEX BY BINARY_INTEGER;
14596: TYPE t_last_update_date IS TABLE OF
14597: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
14598: INDEX BY BINARY_INTEGER;
14599: TYPE t_last_update_login IS TABLE OF
14600: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
14601: INDEX BY BINARY_INTEGER;

Line 14600: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE

14596: TYPE t_last_update_date IS TABLE OF
14597: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
14598: INDEX BY BINARY_INTEGER;
14599: TYPE t_last_update_login IS TABLE OF
14600: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
14601: INDEX BY BINARY_INTEGER;
14602: TYPE t_object_version_number IS TABLE OF
14603: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE
14604: INDEX BY BINARY_INTEGER;

Line 14603: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE

14599: TYPE t_last_update_login IS TABLE OF
14600: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
14601: INDEX BY BINARY_INTEGER;
14602: TYPE t_object_version_number IS TABLE OF
14603: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE
14604: INDEX BY BINARY_INTEGER;
14605:
14606: l_calling_app_id t_calling_app_id;
14607: l_call_app_pay_srv_req_code t_call_app_pay_srv_req_code;

Line 14664: FROM IBY_HOOK_PAYMENTS_T;

14660: last_updated_by,
14661: last_update_date,
14662: last_update_login,
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;

Line 15064: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE

15060: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
15061: '.getAdjustedPaymentData';
15062:
15063: TYPE t_calling_app_id IS TABLE OF
15064: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
15065: INDEX BY BINARY_INTEGER;
15066: TYPE t_call_app_pay_srv_req_code IS TABLE OF
15067: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
15068: INDEX BY BINARY_INTEGER;

Line 15067: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE

15063: TYPE t_calling_app_id IS TABLE OF
15064: IBY_HOOK_PAYMENTS_T.calling_app_id%TYPE
15065: INDEX BY BINARY_INTEGER;
15066: TYPE t_call_app_pay_srv_req_code IS TABLE OF
15067: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
15068: INDEX BY BINARY_INTEGER;
15069: TYPE t_payment_service_request_id IS TABLE OF
15070: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
15071: INDEX BY BINARY_INTEGER;

Line 15070: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE

15066: TYPE t_call_app_pay_srv_req_code IS TABLE OF
15067: IBY_HOOK_PAYMENTS_T.call_app_pay_service_req_code%TYPE
15068: INDEX BY BINARY_INTEGER;
15069: TYPE t_payment_service_request_id IS TABLE OF
15070: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
15071: INDEX BY BINARY_INTEGER;
15072: TYPE t_payment_id IS TABLE OF
15073: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
15074: INDEX BY BINARY_INTEGER;

Line 15073: IBY_HOOK_PAYMENTS_T.payment_id%TYPE

15069: TYPE t_payment_service_request_id IS TABLE OF
15070: IBY_HOOK_PAYMENTS_T.payment_service_request_id%TYPE
15071: INDEX BY BINARY_INTEGER;
15072: TYPE t_payment_id IS TABLE OF
15073: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
15074: INDEX BY BINARY_INTEGER;
15075: TYPE t_payment_amount IS TABLE OF
15076: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
15077: INDEX BY BINARY_INTEGER;

Line 15076: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE

15072: TYPE t_payment_id IS TABLE OF
15073: IBY_HOOK_PAYMENTS_T.payment_id%TYPE
15074: INDEX BY BINARY_INTEGER;
15075: TYPE t_payment_amount IS TABLE OF
15076: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
15077: INDEX BY BINARY_INTEGER;
15078: TYPE t_payment_currency_code IS TABLE OF
15079: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
15080: INDEX BY BINARY_INTEGER;

Line 15079: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE

15075: TYPE t_payment_amount IS TABLE OF
15076: IBY_HOOK_PAYMENTS_T.payment_amount%TYPE
15077: INDEX BY BINARY_INTEGER;
15078: TYPE t_payment_currency_code IS TABLE OF
15079: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
15080: INDEX BY BINARY_INTEGER;
15081: TYPE t_dont_pay_flag IS TABLE OF
15082: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
15083: INDEX BY BINARY_INTEGER;

Line 15082: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE

15078: TYPE t_payment_currency_code IS TABLE OF
15079: IBY_HOOK_PAYMENTS_T.payment_currency_code%TYPE
15080: INDEX BY BINARY_INTEGER;
15081: TYPE t_dont_pay_flag IS TABLE OF
15082: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
15083: INDEX BY BINARY_INTEGER;
15084: TYPE t_dont_pay_reason_code IS TABLE OF
15085: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
15086: INDEX BY BINARY_INTEGER;

Line 15085: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE

15081: TYPE t_dont_pay_flag IS TABLE OF
15082: IBY_HOOK_PAYMENTS_T.dont_pay_flag%TYPE
15083: INDEX BY BINARY_INTEGER;
15084: TYPE t_dont_pay_reason_code IS TABLE OF
15085: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
15086: INDEX BY BINARY_INTEGER;
15087: TYPE t_dont_pay_description IS TABLE OF
15088: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
15089: INDEX BY BINARY_INTEGER;

Line 15088: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE

15084: TYPE t_dont_pay_reason_code IS TABLE OF
15085: IBY_HOOK_PAYMENTS_T.dont_pay_reason_code%TYPE
15086: INDEX BY BINARY_INTEGER;
15087: TYPE t_dont_pay_description IS TABLE OF
15088: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
15089: INDEX BY BINARY_INTEGER;
15090: TYPE t_internal_bank_account_id IS TABLE OF
15091: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
15092: INDEX BY BINARY_INTEGER;

Line 15091: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE

15087: TYPE t_dont_pay_description IS TABLE OF
15088: IBY_HOOK_PAYMENTS_T.dont_pay_description%TYPE
15089: INDEX BY BINARY_INTEGER;
15090: TYPE t_internal_bank_account_id IS TABLE OF
15091: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
15092: INDEX BY BINARY_INTEGER;
15093: TYPE t_ext_payee_id IS TABLE OF
15094: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
15095: INDEX BY BINARY_INTEGER;

Line 15094: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE

15090: TYPE t_internal_bank_account_id IS TABLE OF
15091: IBY_HOOK_PAYMENTS_T.internal_bank_account_id%TYPE
15092: INDEX BY BINARY_INTEGER;
15093: TYPE t_ext_payee_id IS TABLE OF
15094: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
15095: INDEX BY BINARY_INTEGER;
15096: TYPE t_payee_party_id IS TABLE OF
15097: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
15098: INDEX BY BINARY_INTEGER;

Line 15097: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE

15093: TYPE t_ext_payee_id IS TABLE OF
15094: IBY_HOOK_PAYMENTS_T.ext_payee_id%TYPE
15095: INDEX BY BINARY_INTEGER;
15096: TYPE t_payee_party_id IS TABLE OF
15097: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
15098: INDEX BY BINARY_INTEGER;
15099: TYPE t_party_site_id IS TABLE OF
15100: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
15101: INDEX BY BINARY_INTEGER;

Line 15100: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE

15096: TYPE t_payee_party_id IS TABLE OF
15097: IBY_HOOK_PAYMENTS_T.payee_party_id%TYPE
15098: INDEX BY BINARY_INTEGER;
15099: TYPE t_party_site_id IS TABLE OF
15100: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
15101: INDEX BY BINARY_INTEGER;
15102: TYPE t_supplier_site_id IS TABLE OF
15103: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
15104: INDEX BY BINARY_INTEGER;

Line 15103: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE

15099: TYPE t_party_site_id IS TABLE OF
15100: IBY_HOOK_PAYMENTS_T.party_site_id%TYPE
15101: INDEX BY BINARY_INTEGER;
15102: TYPE t_supplier_site_id IS TABLE OF
15103: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
15104: INDEX BY BINARY_INTEGER;
15105: TYPE t_org_id IS TABLE OF
15106: IBY_HOOK_PAYMENTS_T.org_id%TYPE
15107: INDEX BY BINARY_INTEGER;

Line 15106: IBY_HOOK_PAYMENTS_T.org_id%TYPE

15102: TYPE t_supplier_site_id IS TABLE OF
15103: IBY_HOOK_PAYMENTS_T.supplier_site_id%TYPE
15104: INDEX BY BINARY_INTEGER;
15105: TYPE t_org_id IS TABLE OF
15106: IBY_HOOK_PAYMENTS_T.org_id%TYPE
15107: INDEX BY BINARY_INTEGER;
15108: TYPE t_org_type IS TABLE OF
15109: IBY_HOOK_PAYMENTS_T.org_type%TYPE
15110: INDEX BY BINARY_INTEGER;

Line 15109: IBY_HOOK_PAYMENTS_T.org_type%TYPE

15105: TYPE t_org_id IS TABLE OF
15106: IBY_HOOK_PAYMENTS_T.org_id%TYPE
15107: INDEX BY BINARY_INTEGER;
15108: TYPE t_org_type IS TABLE OF
15109: IBY_HOOK_PAYMENTS_T.org_type%TYPE
15110: INDEX BY BINARY_INTEGER;
15111: TYPE t_external_bank_account_id IS TABLE OF
15112: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
15113: INDEX BY BINARY_INTEGER;

Line 15112: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE

15108: TYPE t_org_type IS TABLE OF
15109: IBY_HOOK_PAYMENTS_T.org_type%TYPE
15110: INDEX BY BINARY_INTEGER;
15111: TYPE t_external_bank_account_id IS TABLE OF
15112: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
15113: INDEX BY BINARY_INTEGER;
15114: TYPE t_discount_amount_taken IS TABLE OF
15115: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
15116: INDEX BY BINARY_INTEGER;

Line 15115: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE

15111: TYPE t_external_bank_account_id IS TABLE OF
15112: IBY_HOOK_PAYMENTS_T.external_bank_account_id%TYPE
15113: INDEX BY BINARY_INTEGER;
15114: TYPE t_discount_amount_taken IS TABLE OF
15115: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
15116: INDEX BY BINARY_INTEGER;
15117: TYPE t_payment_date IS TABLE OF
15118: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
15119: INDEX BY BINARY_INTEGER;

Line 15118: IBY_HOOK_PAYMENTS_T.payment_date%TYPE

15114: TYPE t_discount_amount_taken IS TABLE OF
15115: IBY_HOOK_PAYMENTS_T.discount_amount_taken%TYPE
15116: INDEX BY BINARY_INTEGER;
15117: TYPE t_payment_date IS TABLE OF
15118: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
15119: INDEX BY BINARY_INTEGER;
15120: TYPE t_bank_charge_amount IS TABLE OF
15121: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
15122: INDEX BY BINARY_INTEGER;

Line 15121: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE

15117: TYPE t_payment_date IS TABLE OF
15118: IBY_HOOK_PAYMENTS_T.payment_date%TYPE
15119: INDEX BY BINARY_INTEGER;
15120: TYPE t_bank_charge_amount IS TABLE OF
15121: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
15122: INDEX BY BINARY_INTEGER;
15123: TYPE t_created_by IS TABLE OF
15124: IBY_HOOK_PAYMENTS_T.created_by%TYPE
15125: INDEX BY BINARY_INTEGER;

Line 15124: IBY_HOOK_PAYMENTS_T.created_by%TYPE

15120: TYPE t_bank_charge_amount IS TABLE OF
15121: IBY_HOOK_PAYMENTS_T.bank_charge_amount%TYPE
15122: INDEX BY BINARY_INTEGER;
15123: TYPE t_created_by IS TABLE OF
15124: IBY_HOOK_PAYMENTS_T.created_by%TYPE
15125: INDEX BY BINARY_INTEGER;
15126: TYPE t_creation_date IS TABLE OF
15127: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
15128: INDEX BY BINARY_INTEGER;

Line 15127: IBY_HOOK_PAYMENTS_T.creation_date%TYPE

15123: TYPE t_created_by IS TABLE OF
15124: IBY_HOOK_PAYMENTS_T.created_by%TYPE
15125: INDEX BY BINARY_INTEGER;
15126: TYPE t_creation_date IS TABLE OF
15127: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
15128: INDEX BY BINARY_INTEGER;
15129: TYPE t_last_updated_by IS TABLE OF
15130: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
15131: INDEX BY BINARY_INTEGER;

Line 15130: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE

15126: TYPE t_creation_date IS TABLE OF
15127: IBY_HOOK_PAYMENTS_T.creation_date%TYPE
15128: INDEX BY BINARY_INTEGER;
15129: TYPE t_last_updated_by IS TABLE OF
15130: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
15131: INDEX BY BINARY_INTEGER;
15132: TYPE t_last_update_date IS TABLE OF
15133: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
15134: INDEX BY BINARY_INTEGER;

Line 15133: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE

15129: TYPE t_last_updated_by IS TABLE OF
15130: IBY_HOOK_PAYMENTS_T.last_updated_by%TYPE
15131: INDEX BY BINARY_INTEGER;
15132: TYPE t_last_update_date IS TABLE OF
15133: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
15134: INDEX BY BINARY_INTEGER;
15135: TYPE t_last_update_login IS TABLE OF
15136: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
15137: INDEX BY BINARY_INTEGER;

Line 15136: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE

15132: TYPE t_last_update_date IS TABLE OF
15133: IBY_HOOK_PAYMENTS_T.last_update_date%TYPE
15134: INDEX BY BINARY_INTEGER;
15135: TYPE t_last_update_login IS TABLE OF
15136: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
15137: INDEX BY BINARY_INTEGER;
15138: TYPE t_object_version_number IS TABLE OF
15139: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE
15140: INDEX BY BINARY_INTEGER;

Line 15139: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE

15135: TYPE t_last_update_login IS TABLE OF
15136: IBY_HOOK_PAYMENTS_T.last_update_login%TYPE
15137: INDEX BY BINARY_INTEGER;
15138: TYPE t_object_version_number IS TABLE OF
15139: IBY_HOOK_PAYMENTS_T.object_version_number%TYPE
15140: INDEX BY BINARY_INTEGER;
15141:
15142: l_calling_app_id t_calling_app_id;
15143: l_call_app_pay_srv_req_code t_call_app_pay_srv_req_code;

Line 15200: FROM IBY_HOOK_PAYMENTS_T;

15196: last_updated_by,
15197: last_update_date,
15198: last_update_login,
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;