DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on IBY_PAY_SERVICE_REQUESTS

Line 919: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

915: -- as well.
916: --
917: TYPE paymentGroupCriteriaType IS RECORD (
918: calling_app_payreq_cd
919: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
920: document_id
921: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
922: calling_app_id
923: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

Line 1057: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,

1053: IBY_PAYMENT_PROFILES.declaration_currency_code%TYPE,
1054: decl_threshold_amount
1055: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE,
1056: max_payment_amount
1057: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1058: min_payment_amount
1059: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1060: allow_zero_pmts_flag
1061: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,

Line 1059: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,

1055: IBY_PAYMENT_PROFILES.declaration_threshold_amount%TYPE,
1056: max_payment_amount
1057: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1058: min_payment_amount
1059: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1060: allow_zero_pmts_flag
1061: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,
1062: support_prom_notes_flag
1063: IBY_PAYMENT_METHODS_VL.support_bills_payable_flag%TYPE

Line 1061: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,

1057: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1058: min_payment_amount
1059: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1060: allow_zero_pmts_flag
1061: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE,
1062: support_prom_notes_flag
1063: IBY_PAYMENT_METHODS_VL.support_bills_payable_flag%TYPE
1064: );
1065:

Line 1080: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,

1076: -- the usual payment validation rules.
1077: --
1078: TYPE payReqImposedCriteria IS RECORD (
1079: max_pmt_amt_limit
1080: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1081: min_pmt_amt_limit
1082: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1083: allow_zero_pmts_flag
1084: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE

Line 1082: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,

1078: TYPE payReqImposedCriteria IS RECORD (
1079: max_pmt_amt_limit
1080: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1081: min_pmt_amt_limit
1082: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1083: allow_zero_pmts_flag
1084: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
1085: );
1086:

Line 1084: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE

1080: IBY_PAY_SERVICE_REQUESTS.maximum_payment_amount%TYPE,
1081: min_pmt_amt_limit
1082: IBY_PAY_SERVICE_REQUESTS.minimum_payment_amount%TYPE,
1083: allow_zero_pmts_flag
1084: IBY_PAY_SERVICE_REQUESTS.allow_zero_payments_flag%TYPE
1085: );
1086:
1087: --
1088: -- This record stores one validation set applicable to

Line 1509: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

1505: | NOTES:
1506: |
1507: *---------------------------------------------------------------------*/
1508: PROCEDURE createPayments(
1509: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
1510: payment_service_request_id%TYPE,
1511: p_pmt_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
1512: payment_rejection_level_code%TYPE,
1513: p_review_proposed_pmts_flag IN IBY_INTERNAL_PAYERS_ALL.

Line 1539: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

1535: | NOTES:
1536: |
1537: *---------------------------------------------------------------------*/
1538: PROCEDURE performDocumentGrouping(
1539: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
1540: payment_service_request_id%TYPE,
1541: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1542: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
1543: docsInPaymentTabType,

Line 1544: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

1540: payment_service_request_id%TYPE,
1541: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
1542: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
1543: docsInPaymentTabType,
1544: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1545: calling_app_id%TYPE,
1546: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1547: call_app_pay_service_req_code
1548: %TYPE,

Line 1546: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

1542: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
1543: docsInPaymentTabType,
1544: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1545: calling_app_id%TYPE,
1546: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
1547: call_app_pay_service_req_code
1548: %TYPE,
1549: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
1550: payReqImposedCriteria

Line 1713: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

1709: | NOTES:
1710: |
1711: *---------------------------------------------------------------------*/
1712: PROCEDURE performDBUpdates(
1713: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
1714: payment_service_request_id%type,
1715: p_rej_level IN VARCHAR2,
1716: p_review_pmts_flag IN VARCHAR2,
1717: x_paymentTab IN OUT NOCOPY paymentTabType,

Line 2052: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

2048: | NOTES:
2049: |
2050: *---------------------------------------------------------------------*/
2051: PROCEDURE callHook(
2052: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2053: payment_service_request_id%type
2054: );
2055:
2056: /*--------------------------------------------------------------------

Line 2702: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)

2698: | NOTES:
2699: |
2700: *---------------------------------------------------------------------*/
2701: FUNCTION get_payreq_status (
2702: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE)
2703: RETURN VARCHAR2;
2704:
2705: /*--------------------------------------------------------------------
2706: | NAME:

Line 2726: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.

2722: | NOTES:
2723: |
2724: *---------------------------------------------------------------------*/
2725: PROCEDURE rebuildPayments(
2726: p_payment_request_id IN IBY_PAY_SERVICE_REQUESTS.
2727: payment_service_request_id%TYPE,
2728: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2729: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2730: docsInPaymentTabType,

Line 2731: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

2727: payment_service_request_id%TYPE,
2728: x_paymentTab IN OUT NOCOPY IBY_PAYGROUP_PUB.paymentTabType,
2729: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2730: docsInPaymentTabType,
2731: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2732: calling_app_id%TYPE,
2733: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2734: call_app_pay_service_req_code
2735: %TYPE,

Line 2733: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.

2729: x_docsInPmtTab IN OUT NOCOPY IBY_PAYGROUP_PUB.
2730: docsInPaymentTabType,
2731: x_ca_id IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2732: calling_app_id%TYPE,
2733: x_ca_payreq_cd IN OUT NOCOPY IBY_PAY_SERVICE_REQUESTS.
2734: call_app_pay_service_req_code
2735: %TYPE,
2736: x_payReqCriteria IN OUT NOCOPY IBY_PAYGROUP_PUB.
2737: payReqImposedCriteria