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 115: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

111: | NOTES:
112: |
113: *---------------------------------------------------------------------*/
114: PROCEDURE createPayments(
115: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
116: payment_service_request_id%TYPE,
117: p_pmt_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
118: payment_rejection_level_code%TYPE,
119: p_review_proposed_pmts_flag IN IBY_INTERNAL_PAYERS_ALL.

Line 649: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

645: | NOTES:
646: |
647: *---------------------------------------------------------------------*/
648: PROCEDURE performDocumentGrouping(
649: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
650: payment_service_request_id%TYPE,
651: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
652: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
653: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

Line 653: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

649: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
650: payment_service_request_id%TYPE,
651: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
652: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
653: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
654: calling_app_id%TYPE,
655: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
656: call_app_pay_service_req_code
657: %TYPE,

Line 655: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

651: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
652: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.docsInPaymentTabType,
653: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
654: calling_app_id%TYPE,
655: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
656: call_app_pay_service_req_code
657: %TYPE,
658: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
659: payReqImposedCriteria

Line 1027: IBY_PAY_SERVICE_REQUESTS prq,

1023: /*TPP-Start*/
1024: FROM IBY_DOCS_PAYABLE_ALL docs,
1025: IBY_PMT_CREATION_RULES pcr,
1026: IBY_PAYMENT_PROFILES ppf,
1027: IBY_PAY_SERVICE_REQUESTS prq,
1028: IBY_EXTERNAL_PAYEES_ALL ext_payee,
1029: IBY_PAYMENT_METHODS_B pmt_mthd,
1030: CE_BANK_ACCOUNTS iba
1031: WHERE prq.payment_service_request_id = p_payment_request_id

Line 6468: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

6464: | NOTES:
6465: |
6466: *---------------------------------------------------------------------*/
6467: PROCEDURE callHook(
6468: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
6469: payment_service_request_id%type
6470: )
6471: IS
6472:

Line 6523: IBY_PAY_SERVICE_REQUESTS req

6519: INTO
6520: l_app_short_name
6521: FROM
6522: FND_APPLICATION fnd,
6523: IBY_PAY_SERVICE_REQUESTS req
6524: WHERE
6525: fnd.application_id = req.calling_app_id AND
6526: req.payment_service_request_id = p_payreq_id
6527: ;

Line 7587: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

7583: | NOTES:
7584: |
7585: *---------------------------------------------------------------------*/
7586: PROCEDURE performDBUpdates(
7587: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
7588: payment_service_request_id%type,
7589: p_rej_level IN VARCHAR2,
7590: p_review_pmts_flag IN VARCHAR2,
7591: x_paymentTab IN OUT NOCOPY paymentTabType,

Line 8004: iby_pay_service_requests

8000: print_debuginfo(l_module_name, 'Updating status of payment request '
8001: || p_payreq_id || ' to ' || l_request_status || '.');
8002:
8003: UPDATE
8004: iby_pay_service_requests
8005: SET
8006: payment_service_request_status = l_request_status
8007: WHERE
8008: payment_service_request_id = p_payreq_id

Line 9065: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.

9061: /*
9062: * Cursor to get list of failed documents which are part of payments
9063: * created for the given payment service request.
9064: */
9065: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.
9066: payment_service_request_id%TYPE)
9067: IS
9068: SELECT
9069: doc.document_payable_id,

Line 11127: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

11123: | NOTES:
11124: |
11125: *---------------------------------------------------------------------*/
11126: FUNCTION get_payreq_status (
11127: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
11128: RETURN VARCHAR2
11129: IS
11130:
11131: l_payreq_status VARCHAR2(100);

Line 11142: IBY_PAY_SERVICE_REQUESTS

11138: payment_service_request_status
11139: INTO
11140: l_payreq_status
11141: FROM
11142: IBY_PAY_SERVICE_REQUESTS
11143: WHERE
11144: payment_service_request_id = l_payreq_id;
11145:
11146: RETURN l_payreq_status;

Line 11183: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

11179: | NOTES:
11180: |
11181: *---------------------------------------------------------------------*/
11182: PROCEDURE rebuildPayments(
11183: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
11184: payment_service_request_id%TYPE,
11185: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
11186: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
11187: docsInPaymentTabType,

Line 11188: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

11184: payment_service_request_id%TYPE,
11185: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
11186: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
11187: docsInPaymentTabType,
11188: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
11189: calling_app_id%TYPE,
11190: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
11191: call_app_pay_service_req_code
11192: %TYPE,

Line 11190: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

11186: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
11187: docsInPaymentTabType,
11188: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
11189: calling_app_id%TYPE,
11190: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
11191: call_app_pay_service_req_code
11192: %TYPE,
11193: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
11194: payReqImposedCriteria

Line 11474: IBY_PAY_SERVICE_REQUESTS

11470: INTO
11471: l_ca_id,
11472: l_ca_payreq_cd
11473: FROM
11474: IBY_PAY_SERVICE_REQUESTS
11475: WHERE
11476: PAYMENT_SERVICE_REQUEST_ID = p_payment_request_id
11477: ;
11478: print_debuginfo(l_module_name, 'For payment request '

Line 11888: IBY_PAY_SERVICE_REQUESTS payreq,

11884: /* Remit advice related */
11885: IBY_REMIT_ADVICE_SETUP remit_advice,
11886:
11887: /* Payment service request related */
11888: IBY_PAY_SERVICE_REQUESTS payreq,
11889: FND_APPLICATION_ALL_VIEW fnd_app,
11890:
11891: /* Delivery channel related */
11892: IBY_DELIVERY_CHANNELS_VL deliv,

Line 13033: IBY_PAY_SERVICE_REQUESTS payreq,

13029: /* Remit advice related */
13030: IBY_REMIT_ADVICE_SETUP remit_advice,
13031:
13032: /* Payment service request related */
13033: IBY_PAY_SERVICE_REQUESTS payreq,
13034: FND_APPLICATION_ALL_VIEW fnd_app,
13035:
13036: /* Delivery channel related */
13037: IBY_DELIVERY_CHANNELS_VL deliv,