APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_PAY_SERVICE_REQUESTS

Line 137: IN IBY_PAY_SERVICE_REQUESTS.

133: |
134: *---------------------------------------------------------------------*/
135: PROCEDURE performDBUpdates(
136: p_pay_service_request_id
137: IN IBY_PAY_SERVICE_REQUESTS.
138: payment_service_request_id%type,
139: p_allDocsTab IN docPayTabType,
140: x_errorDocsTab IN OUT NOCOPY docStatusTabType,
141: p_allDocsSuccessFlag IN BOOLEAN,

Line 393: IBY_PAY_SERVICE_REQUESTS

389: print_debuginfo(l_module_name, 'Updating status of payment request '
390: || p_pay_service_request_id || ' to ' || l_request_status || '.');
391:
392: UPDATE
393: IBY_PAY_SERVICE_REQUESTS
394: SET
395: payment_service_request_status = l_request_status
396: WHERE
397: payment_service_request_id = p_pay_service_request_id;

Line 509: p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.

505: | NOTES:
506: |
507: *---------------------------------------------------------------------*/
508: PROCEDURE applyDocumentValidationSets(
509: p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.
510: payment_service_request_id%TYPE,
511: p_doc_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
512: document_rejection_level_code%TYPE,
513: p_is_singpay_flag IN BOOLEAN,

Line 548: req_ca_payreq_cd iby_pay_service_requests.

544: /* holds list of format linked to each profile */
545: l_profile_format_tab profileFormatTabType;
546:
547: /* variables for fields from payment request */
548: req_ca_payreq_cd iby_pay_service_requests.
549: call_app_pay_service_req_code%TYPE;
550: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
551:
552: l_bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;

Line 550: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;

546:
547: /* variables for fields from payment request */
548: req_ca_payreq_cd iby_pay_service_requests.
549: call_app_pay_service_req_code%TYPE;
550: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
551:
552: l_bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;
553:
554: l_print_var VARCHAR2(1) := '';

Line 572: CURSOR c_docs_list(p_pay_service_request_id IBY_PAY_SERVICE_REQUESTS.

568: * end up with a situation where no documents are picked up
569: * by this cursor, and the request will be left unprocessed
570: * during payment re-validation flow.
571: */
572: CURSOR c_docs_list(p_pay_service_request_id IBY_PAY_SERVICE_REQUESTS.
573: payment_service_request_id%TYPE)
574: IS
575: SELECT DISTINCT
576: docs.document_payable_id,

Line 4658: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

4654: | NOTES:
4655: |
4656: *---------------------------------------------------------------------*/
4657: PROCEDURE getRequestAttributes(
4658: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
4659: x_caPayReqCd IN OUT NOCOPY
4660: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
4661: x_caId IN OUT NOCOPY
4662: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE

Line 4660: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

4656: *---------------------------------------------------------------------*/
4657: PROCEDURE getRequestAttributes(
4658: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
4659: x_caPayReqCd IN OUT NOCOPY
4660: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
4661: x_caId IN OUT NOCOPY
4662: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE
4663: )
4664: IS

Line 4662: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE

4658: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
4659: x_caPayReqCd IN OUT NOCOPY
4660: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
4661: x_caId IN OUT NOCOPY
4662: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE
4663: )
4664: IS
4665: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getRequestAttributes';
4666: BEGIN

Line 4675: IBY_PAY_SERVICE_REQUESTS

4671: INTO
4672: x_caPayReqCd,
4673: x_caId
4674: FROM
4675: IBY_PAY_SERVICE_REQUESTS
4676: WHERE
4677: payment_service_request_id = p_payReqId;
4678:
4679: END getRequestAttributes;

Line 5656: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.

5652: /*
5653: * Cursor to get list of failed documents for a payment service
5654: * request.
5655: */
5656: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.
5657: payment_service_request_id%TYPE)
5658: IS
5659: SELECT
5660: doc.document_payable_id,