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_PAY_SERVICE_REQUESTS

Line 423: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

419: | NOTES:
420: |
421: *---------------------------------------------------------------------*/
422: PROCEDURE createPayments(
423: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
424: payment_service_request_id%TYPE,
425: p_pmt_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
426: payment_rejection_level_code%TYPE,
427: p_review_proposed_pmts_flag IN IBY_INTERNAL_PAYERS_ALL.

Line 1319: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

1315: | NOTES:
1316: |
1317: *---------------------------------------------------------------------*/
1318: PROCEDURE performDocumentGrouping(
1319: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
1320: payment_service_request_id%TYPE,
1321: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1322: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
1323: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

Line 1323: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

1319: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
1320: payment_service_request_id%TYPE,
1321: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1322: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
1323: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1324: calling_app_id%TYPE,
1325: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1326: call_app_pay_service_req_code
1327: %TYPE,

Line 1325: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

1321: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1322: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
1323: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1324: calling_app_id%TYPE,
1325: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1326: call_app_pay_service_req_code
1327: %TYPE,
1328: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
1329: payReqImposedCriteria

Line 1700: IBY_PAY_SERVICE_REQUESTS prq,

1696: /*TPP-Start*/
1697: FROM IBY_DOCS_PAYABLE_ALL docs,
1698: IBY_PMT_CREATION_RULES pcr,
1699: IBY_PAYMENT_PROFILES ppf,
1700: IBY_PAY_SERVICE_REQUESTS prq,
1701: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1702: IBY_PAYMENT_METHODS_B pmt_mthd,
1703: CE_BANK_ACCOUNTS iba
1704: WHERE prq.payment_service_request_id = p_payment_request_id

Line 3399: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

3395: | NOTES:
3396: |
3397: *---------------------------------------------------------------------*/
3398: PROCEDURE performDocumentGrouping(
3399: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
3400: payment_service_request_id%TYPE,
3401: --x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
3402: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3403: calling_app_id%TYPE,

Line 3402: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

3398: PROCEDURE performDocumentGrouping(
3399: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
3400: payment_service_request_id%TYPE,
3401: --x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
3402: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3403: calling_app_id%TYPE,
3404: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3405: call_app_pay_service_req_code
3406: %TYPE,

Line 3404: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

3400: payment_service_request_id%TYPE,
3401: --x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
3402: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3403: calling_app_id%TYPE,
3404: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3405: call_app_pay_service_req_code
3406: %TYPE,
3407: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
3408: payReqImposedCriteria

Line 3780: IBY_PAY_SERVICE_REQUESTS prq,

3776: docs.affects_rejection_level --AWT Enh 16296267
3777: FROM IBY_DOCS_PAYABLE_ALL docs,
3778: IBY_PMT_CREATION_RULES pcr,
3779: IBY_PAYMENT_PROFILES ppf,
3780: IBY_PAY_SERVICE_REQUESTS prq,
3781: IBY_EXTERNAL_PAYEES_ALL ext_payee,
3782: IBY_PAYMENT_METHODS_B pmt_mthd,
3783: CE_BANK_ACCOUNTS iba
3784: WHERE prq.payment_service_request_id = p_payment_request_id

Line 10302: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

10298: | NOTES:
10299: |
10300: *---------------------------------------------------------------------*/
10301: PROCEDURE performPaymentValidations(
10302: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
10303: payment_service_request_id%TYPE,
10304: x_paymentTab IN OUT NOCOPY paymentTabType,
10305: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
10306: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

Line 13250: from iby_pay_service_requests where

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
13251: call_app_pay_service_req_code =p_cap_payreq_cd
13252: );
13253:
13254:

Line 14328: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

14324: | NOTES:
14325: |
14326: *---------------------------------------------------------------------*/
14327: PROCEDURE callHook(
14328: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
14329: payment_service_request_id%type
14330: )
14331: IS
14332:

Line 14385: IBY_PAY_SERVICE_REQUESTS req

14381: INTO
14382: l_app_short_name
14383: FROM
14384: FND_APPLICATION fnd,
14385: IBY_PAY_SERVICE_REQUESTS req
14386: WHERE
14387: fnd.application_id = req.calling_app_id AND
14388: req.payment_service_request_id = p_payreq_id
14389: ;

Line 16091: ppr_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

16087: |
16088: *---------------------------------------------------------------------*/
16089: PROCEDURE flagSeparateRemitAdvicePmts(
16090: l_ca_payreq_cd IN VARCHAR2,
16091: ppr_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
16092: -- x_paymentTab IN OUT NOCOPY paymentTabType
16093: -- p_docsInPmtTab IN docsInPaymentTabType
16094: )
16095: IS

Line 16578: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

16574: | NOTES:
16575: |
16576: *---------------------------------------------------------------------*/
16577: PROCEDURE performDBUpdates(
16578: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
16579: payment_service_request_id%type,
16580: p_rej_level IN VARCHAR2,
16581: p_review_pmts_flag IN VARCHAR2,
16582: x_paymentTab IN OUT NOCOPY paymentTabType,

Line 17143: iby_pay_service_requests

17139: || p_payreq_id || ' to ' || l_request_status || '.');
17140: END IF;
17141:
17142: UPDATE
17143: iby_pay_service_requests
17144: SET
17145: payment_service_request_status = l_request_status
17146: WHERE
17147: payment_service_request_id = p_payreq_id

Line 17215: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

17211: | NOTES:
17212: |
17213: *---------------------------------------------------------------------*/
17214: PROCEDURE performDBUpdates(
17215: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
17216: payment_service_request_id%type,
17217: p_rej_level IN VARCHAR2,
17218: p_review_pmts_flag IN VARCHAR2,
17219: -- x_paymentTab IN OUT NOCOPY paymentTabType,

Line 17999: iby_pay_service_requests

17995: || p_payreq_id || ' to ' || l_request_status || '.');
17996: END IF;
17997:
17998: UPDATE
17999: iby_pay_service_requests
18000: SET
18001: payment_service_request_status = l_request_status
18002: WHERE
18003: payment_service_request_id = p_payreq_id

Line 18079: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

18075: | NOTES:
18076: |
18077: *---------------------------------------------------------------------*/
18078: PROCEDURE applyPaymentValidationSets(
18079: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
18080: payment_service_request_id%TYPE,
18081:
18082: l_trx_valid_index IN BINARY_INTEGER,
18083: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 19387: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.

19383: /*
19384: * Cursor to get list of failed documents which are part of payments
19385: * created for the given payment service request.
19386: */
19387: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.
19388: payment_service_request_id%TYPE)
19389: IS
19390: SELECT
19391: doc.document_payable_id,

Line 22364: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

22360: | NOTES:
22361: |
22362: *---------------------------------------------------------------------*/
22363: FUNCTION get_payreq_status (
22364: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
22365: RETURN VARCHAR2
22366: IS
22367:
22368: l_payreq_status VARCHAR2(100);

Line 22379: IBY_PAY_SERVICE_REQUESTS

22375: payment_service_request_status
22376: INTO
22377: l_payreq_status
22378: FROM
22379: IBY_PAY_SERVICE_REQUESTS
22380: WHERE
22381: payment_service_request_id = l_payreq_id;
22382:
22383: RETURN l_payreq_status;

Line 22422: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

22418: | NOTES:
22419: |
22420: *---------------------------------------------------------------------*/
22421: PROCEDURE rebuildPayments(
22422: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
22423: payment_service_request_id%TYPE,
22424: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
22425: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
22426: docsInPaymentTabType,

Line 22427: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

22423: payment_service_request_id%TYPE,
22424: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
22425: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
22426: docsInPaymentTabType,
22427: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22428: calling_app_id%TYPE,
22429: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22430: call_app_pay_service_req_code
22431: %TYPE,

Line 22429: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

22425: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
22426: docsInPaymentTabType,
22427: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22428: calling_app_id%TYPE,
22429: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22430: call_app_pay_service_req_code
22431: %TYPE,
22432: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
22433: payReqImposedCriteria

Line 22719: IBY_PAY_SERVICE_REQUESTS

22715: INTO
22716: l_ca_id,
22717: l_ca_payreq_cd
22718: FROM
22719: IBY_PAY_SERVICE_REQUESTS
22720: WHERE
22721: PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id
22722: ;
22723: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 22787: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

22783: | NOTES:
22784: |
22785: *---------------------------------------------------------------------*/
22786: PROCEDURE rebuildPayments(
22787: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
22788: payment_service_request_id%TYPE,
22789: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
22790: -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
22791: -- docsInPaymentTabType,

Line 22792: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

22788: payment_service_request_id%TYPE,
22789: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
22790: -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
22791: -- docsInPaymentTabType,
22792: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22793: calling_app_id%TYPE,
22794: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22795: call_app_pay_service_req_code
22796: %TYPE,

Line 22794: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

22790: -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
22791: -- docsInPaymentTabType,
22792: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22793: calling_app_id%TYPE,
22794: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
22795: call_app_pay_service_req_code
22796: %TYPE,
22797: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
22798: payReqImposedCriteria

Line 23060: IBY_PAY_SERVICE_REQUESTS

23056: INTO
23057: l_ca_id,
23058: l_ca_payreq_cd
23059: FROM
23060: IBY_PAY_SERVICE_REQUESTS
23061: WHERE
23062: PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id
23063: ;
23064: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 25772: IBY_PAY_SERVICE_REQUESTS payreq,

25768: payreq.call_app_pay_service_req_code,-- ppr name
25769: fnd_app.application_name -- source product -- 88
25770: FROM
25771: /* Payment service request related */
25772: IBY_PAY_SERVICE_REQUESTS payreq,
25773: FND_APPLICATION_ALL_VIEW fnd_app
25774:
25775: WHERE
25776: