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

Line 181: IN IBY_PAY_SERVICE_REQUESTS.

177: |
178: *---------------------------------------------------------------------*/
179: PROCEDURE performDBUpdates(
180: p_pay_service_request_id
181: IN IBY_PAY_SERVICE_REQUESTS.
182: payment_service_request_id%type,
183: p_allDocsTab IN docPayTabType,
184: x_errorDocsTab IN OUT NOCOPY docStatusTabType,
185: p_allDocsSuccessFlag IN BOOLEAN,

Line 457: IBY_PAY_SERVICE_REQUESTS

453: || p_pay_service_request_id || ' to ' || l_request_status || '.');
454:
455: END IF;
456: UPDATE
457: IBY_PAY_SERVICE_REQUESTS
458: SET
459: payment_service_request_status = l_request_status
460: WHERE
461: payment_service_request_id = p_pay_service_request_id;

Line 588: p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.

584: | This was orginally always assumed to be true
585: |
586: *---------------------------------------------------------------------*/
587: PROCEDURE applyDocumentValidationSets(
588: p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.
589: payment_service_request_id%TYPE,
590: p_doc_rejection_level IN IBY_INTERNAL_PAYERS_ALL.
591: document_rejection_level_code%TYPE,
592: p_is_singpay_flag IN BOOLEAN,

Line 633: req_ca_payreq_cd iby_pay_service_requests.

629: l_rejection_level VARCHAR2(200);
630:
631:
632: /* variables for fields from payment request */
633: req_ca_payreq_cd iby_pay_service_requests.
634: call_app_pay_service_req_code%TYPE;
635: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
636:
637: --l_bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;

Line 635: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;

631:
632: /* variables for fields from payment request */
633: req_ca_payreq_cd iby_pay_service_requests.
634: call_app_pay_service_req_code%TYPE;
635: req_ca_id iby_pay_service_requests.calling_app_id%TYPE;
636:
637: --l_bankAccountsArray CE_BANK_AND_ACCOUNT_UTIL.BankAcctIdTable;
638:
639: l_print_var VARCHAR2(1) := '';

Line 674: CURSOR c_docs_list(p_pay_service_request_id IBY_PAY_SERVICE_REQUESTS.

670: * end up with a situation where no documents are picked up
671: * by this cursor, and the request will be left unprocessed
672: * during payment re-validation flow.
673: */
674: CURSOR c_docs_list(p_pay_service_request_id IBY_PAY_SERVICE_REQUESTS.
675: payment_service_request_id%TYPE)
676: IS
677: SELECT docs.document_payable_id,
678: docs.calling_app_doc_unique_ref1,

Line 4757: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,

4753: | NOTES:
4754: |
4755: *---------------------------------------------------------------------*/
4756: PROCEDURE getRequestAttributes(
4757: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
4758: x_caPayReqCd IN OUT NOCOPY
4759: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
4760: x_caId IN OUT NOCOPY
4761: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE

Line 4759: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,

4755: *---------------------------------------------------------------------*/
4756: PROCEDURE getRequestAttributes(
4757: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
4758: x_caPayReqCd IN OUT NOCOPY
4759: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
4760: x_caId IN OUT NOCOPY
4761: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE
4762: )
4763: IS

Line 4761: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE

4757: p_payReqId IN IBY_PAY_SERVICE_REQUESTS.payment_service_request_id%TYPE,
4758: x_caPayReqCd IN OUT NOCOPY
4759: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
4760: x_caId IN OUT NOCOPY
4761: IBY_PAY_SERVICE_REQUESTS.calling_app_id%TYPE
4762: )
4763: IS
4764: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.getRequestAttributes';
4765: BEGIN

Line 4774: IBY_PAY_SERVICE_REQUESTS

4770: INTO
4771: x_caPayReqCd,
4772: x_caId
4773: FROM
4774: IBY_PAY_SERVICE_REQUESTS
4775: WHERE
4776: payment_service_request_id = p_payReqId;
4777:
4778: END getRequestAttributes;

Line 6002: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.

5998: /*
5999: * Cursor to get list of failed documents for a payment service
6000: * request.
6001: */
6002: CURSOR c_rejected_docs (p_payreq_id IBY_PAY_SERVICE_REQUESTS.
6003: payment_service_request_id%TYPE)
6004: IS
6005: SELECT
6006: doc.document_payable_id,

Line 6756: p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.

6752: | NOTES:
6753: |
6754: *---------------------------------------------------------------------*/
6755: PROCEDURE initDocDataForPPR(
6756: p_pay_service_request_id IN IBY_PAY_SERVICE_REQUESTS.
6757: payment_service_request_id%TYPE
6758: )
6759:
6760: IS

Line 6763: l_process_type IBY_PAY_SERVICE_REQUESTS.PROCESS_TYPE%TYPE; --Bug 16679530

6759:
6760: IS
6761: l_module_name CONSTANT VARCHAR2(200)
6762: := G_PKG_NAME || '.initDocDataForPPR';
6763: l_process_type IBY_PAY_SERVICE_REQUESTS.PROCESS_TYPE%TYPE; --Bug 16679530
6764:
6765: BEGIN
6766:
6767: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6774: FROM iby_pay_service_requests

6770: END IF;
6771:
6772: SELECT PROCESS_TYPE
6773: INTO l_process_type
6774: FROM iby_pay_service_requests
6775: WHERE payment_service_request_id = p_pay_service_request_id; --Bug 16679530
6776:
6777: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
6778: print_debuginfo(l_module_name, 'Process Type is:'||l_process_type); --Bug 16679530