APPS.IBY_PAYINSTR_PUB dependencies on IBY_PAY_SERVICE_REQUESTS

Line 131: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

127: -- as well.
128: --
129: TYPE instrGroupCriteriaType IS RECORD (
130: calling_app_payreq_cd
131: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
132: calling_app_id
133: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
134: pay_service_req_id
135: IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

Line 133: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

129: TYPE instrGroupCriteriaType IS RECORD (
130: calling_app_payreq_cd
131: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
132: calling_app_id
133: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
134: pay_service_req_id
135: IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
136: payment_id
137: IBY_PAYMENTS_ALL.payment_id%TYPE,

Line 135: IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

131: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
132: calling_app_id
133: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
134: pay_service_req_id
135: IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
136: payment_id
137: IBY_PAYMENTS_ALL.payment_id%TYPE,
138: int_bank_acct_id
139: IBY_PAYMENTS_ALL.internal_bank_account_id%TYPE,

Line 292: ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,

288: payment_ref IBY_PAYMENTS_ALL.payment_reference_number%TYPE,
289: instr_id IBY_PAY_INSTRUCTIONS_ALL.payment_instruction_id%TYPE,
290: instr_status IBY_PAY_INSTRUCTIONS_ALL.
291: payment_instruction_status%TYPE,
292: ca_id IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE,
293: le_id IBY_PAYMENTS_ALL.legal_entity_id%TYPE,
294: doc_cat_code IBY_PAYMENT_METHODS_VL.document_category_code%TYPE,
295: payment_date IBY_PAYMENTS_ALL.payment_date%TYPE,
296: ledger_id GL_LEDGER_LE_V.ledger_id%TYPE := -1,

Line 388: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.

384:
385: /*-- selection criteria --*/
386: p_payment_profile_id IN IBY_PAYMENTS_ALL.
387: payment_profile_id%TYPE,
388: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.
389: calling_app_id%TYPE,
390: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
391: call_app_pay_service_req_code
392: %TYPE,

Line 390: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.

386: p_payment_profile_id IN IBY_PAYMENTS_ALL.
387: payment_profile_id%TYPE,
388: p_calling_app_id IN IBY_PAY_SERVICE_REQUESTS.
389: calling_app_id%TYPE,
390: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
391: call_app_pay_service_req_code
392: %TYPE,
393: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
394: payment_service_request_id

Line 393: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.

389: calling_app_id%TYPE,
390: p_calling_app_payreq_cd IN IBY_PAY_SERVICE_REQUESTS.
391: call_app_pay_service_req_code
392: %TYPE,
393: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
394: payment_service_request_id
395: %TYPE,
396: p_internal_bank_account_id IN IBY_PAYMENTS_ALL.
397: internal_bank_account_id%TYPE,