APPS.IBY_BUILD_INSTRUCTIONS_PUB_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 164: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

160: l_ret_status VARCHAR2(300);
161: l_error_code VARCHAR2(3000);
162: l_api_version CONSTANT NUMBER := 1.0;
163:
164: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
165: l_module_name VARCHAR2(200) := G_PKG_NAME || '.build_payment_instructions';
166: l_not_provided CONSTANT VARCHAR2(100) := '';
167:
168: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;

Line 1446: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

1442: | NOTES:
1443: |
1444: *---------------------------------------------------------------------*/
1445: FUNCTION get_payreq_id (
1446: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1447: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1448: call_app_pay_service_req_code%TYPE
1449: )
1450: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

Line 1447: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

1443: |
1444: *---------------------------------------------------------------------*/
1445: FUNCTION get_payreq_id (
1446: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1447: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1448: call_app_pay_service_req_code%TYPE
1449: )
1450: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1451: IS

Line 1450: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

1446: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1447: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1448: call_app_pay_service_req_code%TYPE
1449: )
1450: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1451: IS
1452:
1453: l_payreq_id NUMBER := -1;
1454: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_payreq_id';

Line 1465: IBY_PAY_SERVICE_REQUESTS

1461: payment_service_request_id
1462: INTO
1463: l_payreq_id
1464: FROM
1465: IBY_PAY_SERVICE_REQUESTS
1466: WHERE
1467: calling_app_id = l_ca_id
1468: AND
1469: call_app_pay_service_req_code = l_ca_payreq_cd;