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_BUILD_INSTRUCTIONS_PUB_PKG dependencies on IBY_PAY_SERVICE_REQUESTS

Line 187: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;

183: l_ret_status VARCHAR2(300);
184: l_error_code VARCHAR2(3000);
185: l_api_version CONSTANT NUMBER := 1.0;
186:
187: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
188: l_pmtdoc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE; --Bug 11059189
189: l_int_bank_acct_id IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE; --Bug 16041562
190: l_module_name VARCHAR2(200) := G_PKG_NAME || '.build_payment_instructions';
191: l_not_provided CONSTANT VARCHAR2(100) := '';

Line 188: l_pmtdoc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE; --Bug 11059189

184: l_error_code VARCHAR2(3000);
185: l_api_version CONSTANT NUMBER := 1.0;
186:
187: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
188: l_pmtdoc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE; --Bug 11059189
189: l_int_bank_acct_id IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE; --Bug 16041562
190: l_module_name VARCHAR2(200) := G_PKG_NAME || '.build_payment_instructions';
191: l_not_provided CONSTANT VARCHAR2(100) := '';
192:

Line 189: l_int_bank_acct_id IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE; --Bug 16041562

185: l_api_version CONSTANT NUMBER := 1.0;
186:
187: l_payreq_id IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE;
188: l_pmtdoc_id IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE; --Bug 11059189
189: l_int_bank_acct_id IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE; --Bug 16041562
190: l_module_name VARCHAR2(200) := G_PKG_NAME || '.build_payment_instructions';
191: l_not_provided CONSTANT VARCHAR2(100) := '';
192:
193: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;

Line 1829: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

1825: | NOTES:
1826: |
1827: *---------------------------------------------------------------------*/
1828: FUNCTION get_payreq_id (
1829: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1830: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1831: call_app_pay_service_req_code%TYPE
1832: )
1833: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

Line 1830: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

1826: |
1827: *---------------------------------------------------------------------*/
1828: FUNCTION get_payreq_id (
1829: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1830: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1831: call_app_pay_service_req_code%TYPE
1832: )
1833: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1834: IS

Line 1833: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

1829: l_ca_id IN IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
1830: l_ca_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
1831: call_app_pay_service_req_code%TYPE
1832: )
1833: RETURN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1834: IS
1835:
1836: l_payreq_id NUMBER := -1;
1837: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_payreq_id';

Line 1850: IBY_PAY_SERVICE_REQUESTS

1846: payment_service_request_id
1847: INTO
1848: l_payreq_id
1849: FROM
1850: IBY_PAY_SERVICE_REQUESTS
1851: WHERE
1852: calling_app_id = l_ca_id
1853: AND
1854: call_app_pay_service_req_code = l_ca_payreq_cd;

Line 1905: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

1901: | NOTES:
1902: |
1903: *---------------------------------------------------------------------*/
1904: FUNCTION get_paydoc_id (
1905: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1906: )
1907: RETURN IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE
1908: IS
1909:

Line 1907: RETURN IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE

1903: *---------------------------------------------------------------------*/
1904: FUNCTION get_paydoc_id (
1905: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1906: )
1907: RETURN IBY_PAY_SERVICE_REQUESTS.payment_document_id%TYPE
1908: IS
1909:
1910: l_paydoc_id NUMBER := NULL;
1911: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_paydoc_id';

Line 1924: IBY_PAY_SERVICE_REQUESTS

1920: payment_document_id
1921: INTO
1922: l_paydoc_id
1923: FROM
1924: IBY_PAY_SERVICE_REQUESTS
1925: WHERE
1926: payment_service_request_id = l_payreq_id;
1927:
1928: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1977: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE

1973: | NOTES:
1974: |
1975: *---------------------------------------------------------------------*/
1976: FUNCTION get_int_bank_acct_id (
1977: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1978: )
1979: RETURN IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE
1980: IS
1981:

Line 1979: RETURN IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE

1975: *---------------------------------------------------------------------*/
1976: FUNCTION get_int_bank_acct_id (
1977: l_payreq_id IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE
1978: )
1979: RETURN IBY_PAY_SERVICE_REQUESTS.internal_bank_account_id%TYPE
1980: IS
1981:
1982: l_int_bank_acct_id NUMBER := NULL;
1983: l_module_name VARCHAR2(200) := G_PKG_NAME || '.get_int_bank_acct_id';

Line 1996: IBY_PAY_SERVICE_REQUESTS

1992: internal_bank_account_id
1993: INTO
1994: l_int_bank_acct_id
1995: FROM
1996: IBY_PAY_SERVICE_REQUESTS
1997: WHERE
1998: payment_service_request_id = l_payreq_id;
1999:
2000: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN