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 1576: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

1572: -- as well.
1573: --
1574: TYPE paymentGroupCriteriaType IS RECORD (
1575: calling_app_payreq_cd
1576: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
1577: document_id
1578: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1579: calling_app_id
1580: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

Line 1714: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,

1710: IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE,
1711: decl_threshold_amount
1712: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE,
1713: max_payment_amount
1714: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1715: min_payment_amount
1716: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1717: allow_zero_pmts_flag
1718: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,

Line 1716: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,

1712: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE,
1713: max_payment_amount
1714: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1715: min_payment_amount
1716: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1717: allow_zero_pmts_flag
1718: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,
1719: support_prom_notes_flag
1720: IBY_PAYMENT_METHODS_VL.support_bills_payable_flag%TYPE

Line 1718: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,

1714: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1715: min_payment_amount
1716: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1717: allow_zero_pmts_flag
1718: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,
1719: support_prom_notes_flag
1720: IBY_PAYMENT_METHODS_VL.support_bills_payable_flag%TYPE
1721: );
1722:

Line 1737: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,

1733: -- the usual payment validation rules.
1734: --
1735: TYPE payReqImposedCriteria IS RECORD (
1736: max_pmt_amt_limit
1737: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1738: min_pmt_amt_limit
1739: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1740: allow_zero_pmts_flag
1741: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE

Line 1739: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,

1735: TYPE payReqImposedCriteria IS RECORD (
1736: max_pmt_amt_limit
1737: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1738: min_pmt_amt_limit
1739: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1740: allow_zero_pmts_flag
1741: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
1742: );
1743:

Line 1741: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE

1737: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1738: min_pmt_amt_limit
1739: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1740: allow_zero_pmts_flag
1741: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
1742: );
1743:
1744: --
1745: -- This record stores one validation set applicable to

Line 2191: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

2187: | NOTES:
2188: |
2189: *---------------------------------------------------------------------*/
2190: PROCEDURE createPayments(
2191: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2192: payment_service_request_id%TYPE,
2193: p_pmt_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
2194: payment_rejection_level_code%TYPE,
2195: p_review_proposed_pmts_flag IN IBY_INTERNAL_PAYERS_ALL.

Line 2225: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

2221: | NOTES: Mark for Removal after Dependencies Checking
2222: |
2223: *---------------------------------------------------------------------*/
2224: PROCEDURE performDocumentGrouping(
2225: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2226: payment_service_request_id%TYPE,
2227: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2228: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2229: docsInPaymentTabType,

Line 2230: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

2226: payment_service_request_id%TYPE,
2227: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2228: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2229: docsInPaymentTabType,
2230: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2231: calling_app_id%TYPE,
2232: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2233: call_app_pay_service_req_code
2234: %TYPE,

Line 2232: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

2228: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2229: docsInPaymentTabType,
2230: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2231: calling_app_id%TYPE,
2232: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2233: call_app_pay_service_req_code
2234: %TYPE,
2235: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
2236: payReqImposedCriteria

Line 2262: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

2258: | NOTES:
2259: |
2260: *---------------------------------------------------------------------*/
2261: PROCEDURE performDocumentGrouping(
2262: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2263: payment_service_request_id%TYPE,
2264: -- x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2265: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2266: calling_app_id%TYPE,

Line 2265: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

2261: PROCEDURE performDocumentGrouping(
2262: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2263: payment_service_request_id%TYPE,
2264: -- x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2265: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2266: calling_app_id%TYPE,
2267: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2268: call_app_pay_service_req_code
2269: %TYPE,

Line 2267: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

2263: payment_service_request_id%TYPE,
2264: -- x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2265: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2266: calling_app_id%TYPE,
2267: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2268: call_app_pay_service_req_code
2269: %TYPE,
2270: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
2271: payReqImposedCriteria

Line 2568: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2564: | NOTES: Mark for Removal after Dependencies Checking
2565: |
2566: *---------------------------------------------------------------------*/
2567: PROCEDURE performDBUpdates(
2568: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2569: payment_service_request_id%type,
2570: p_rej_level IN VARCHAR2,
2571: p_review_pmts_flag IN VARCHAR2,
2572: x_paymentTab IN OUT NOCOPY paymentTabType,

Line 2609: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2605: | NOTES:
2606: |
2607: *---------------------------------------------------------------------*/
2608: PROCEDURE performDBUpdates(
2609: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2610: payment_service_request_id%type,
2611: p_rej_level IN VARCHAR2,
2612: p_review_pmts_flag IN VARCHAR2,
2613: -- x_paymentTab IN OUT NOCOPY paymentTabType,

Line 2724: ppr_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

2720: |
2721: *---------------------------------------------------------------------*/
2722: PROCEDURE flagSeparateRemitAdvicePmts(
2723: l_ca_payreq_cd IN VARCHAR2,
2724: ppr_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
2725: -- x_paymentTab IN OUT NOCOPY paymentTabType
2726: -- p_docsInPmtTab IN docsInPaymentTabType
2727: );
2728:

Line 2836: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

2832: | NOTES:
2833: |
2834: *---------------------------------------------------------------------*/
2835: PROCEDURE performPaymentValidations(
2836: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2837: payment_service_request_id%TYPE,
2838: x_paymentTab IN OUT NOCOPY paymentTabType,
2839: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
2840: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

Line 3186: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

3182: | NOTES:
3183: |
3184: *---------------------------------------------------------------------*/
3185: PROCEDURE callHook(
3186: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
3187: payment_service_request_id%type
3188: );
3189:
3190: /*--------------------------------------------------------------------

Line 3367: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

3363: | NOTES:
3364: |
3365: *---------------------------------------------------------------------*/
3366: PROCEDURE applyPaymentValidationSets(
3367: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
3368: payment_service_request_id%TYPE,
3369: --x_paymentTab IN OUT NOCOPY paymentTabType,
3370: l_trx_valid_index IN BINARY_INTEGER,
3371: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,

Line 3943: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

3939: | NOTES:
3940: |
3941: *---------------------------------------------------------------------*/
3942: FUNCTION get_payreq_status (
3943: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
3944: RETURN VARCHAR2;
3945:
3946: /*--------------------------------------------------------------------
3947: | NAME:

Line 3967: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

3963: | NOTES: Mark for Removal after Dependencies Checking
3964: |
3965: *---------------------------------------------------------------------*/
3966: PROCEDURE rebuildPayments(
3967: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
3968: payment_service_request_id%TYPE,
3969: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
3970: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
3971: docsInPaymentTabType,

Line 3972: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

3968: payment_service_request_id%TYPE,
3969: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
3970: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
3971: docsInPaymentTabType,
3972: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3973: calling_app_id%TYPE,
3974: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3975: call_app_pay_service_req_code
3976: %TYPE,

Line 3974: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

3970: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
3971: docsInPaymentTabType,
3972: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3973: calling_app_id%TYPE,
3974: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
3975: call_app_pay_service_req_code
3976: %TYPE,
3977: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
3978: payReqImposedCriteria

Line 4004: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

4000: | NOTES:
4001: |
4002: *---------------------------------------------------------------------*/
4003: PROCEDURE rebuildPayments(
4004: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
4005: payment_service_request_id%TYPE,
4006: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
4007: -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
4008: -- docsInPaymentTabType,

Line 4009: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

4005: payment_service_request_id%TYPE,
4006: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
4007: -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
4008: -- docsInPaymentTabType,
4009: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
4010: calling_app_id%TYPE,
4011: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
4012: call_app_pay_service_req_code
4013: %TYPE,

Line 4011: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

4007: -- x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
4008: -- docsInPaymentTabType,
4009: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
4010: calling_app_id%TYPE,
4011: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
4012: call_app_pay_service_req_code
4013: %TYPE,
4014: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
4015: payReqImposedCriteria