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_DISBURSE_SUBMIT_PUB_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 617: * IBY_DOCS_PAYABLE_ALL table.

613: /*
614: * STEP 2:
615: *
616: * Insert the documents of this payment request into the
617: * IBY_DOCS_PAYABLE_ALL table.
618: */
619:
620: BEGIN
621:

Line 976: IBY_DOCS_PAYABLE_ALL

972: || 'documents of payment request '
973: || l_payreq_id);
974:
975: UPDATE
976: IBY_DOCS_PAYABLE_ALL
977: SET
978: document_status = DOC_STATUS_RDY_FOR_VAL
979: WHERE
980: payment_service_request_id = l_payreq_id AND

Line 3587: || 'IBY_DOCS_PAYABLE_ALL_S.nextval, '

3583: || 'calling_app_doc_unique_ref4, '
3584: || 'calling_app_doc_unique_ref5, '
3585: || 'calling_app_doc_ref_number, '
3586: || 'call_app_pay_service_req_code, '
3587: || 'IBY_DOCS_PAYABLE_ALL_S.nextval, '
3588: || 'payment_function, '
3589: || 'payment_date, '
3590: || 'document_date, '
3591: || 'document_type, '

Line 3785: * IBY_DOCS_PAYABLE_ALL into a PLSQL record structure.

3781: || to_char(iby_disburse_submit_pub_pkg.docspayTab.document_payable_id(l_trx_line_index)));
3782:
3783: /*
3784: * Populate rest of the document attributes required in the table
3785: * IBY_DOCS_PAYABLE_ALL into a PLSQL record structure.
3786: * We will use this structure in doing a bulk insert into the
3787: * IBY_DOCS_PAYABLE_ALL table.
3788: */
3789: iby_disburse_submit_pub_pkg.docspayTab.payment_service_request_id(l_trx_line_index)

Line 3787: * IBY_DOCS_PAYABLE_ALL table.

3783: /*
3784: * Populate rest of the document attributes required in the table
3785: * IBY_DOCS_PAYABLE_ALL into a PLSQL record structure.
3786: * We will use this structure in doing a bulk insert into the
3787: * IBY_DOCS_PAYABLE_ALL table.
3788: */
3789: iby_disburse_submit_pub_pkg.docspayTab.payment_service_request_id(l_trx_line_index)
3790: := p_payreq_id;
3791: -- iby_disburse_submit_pub_pkg.docspayTab.document_payable_id

Line 3795: -- into the IBY_DOCS_PAYABLE_ALL table.

3791: -- iby_disburse_submit_pub_pkg.docspayTab.document_payable_id
3792: -- := getNextDocumentPayableID();
3793: --
3794: -- Set document status ot 'submitted' when docs are first inserted
3795: -- into the IBY_DOCS_PAYABLE_ALL table.
3796: --
3797: iby_disburse_submit_pub_pkg.docspayTab.document_status(l_trx_line_index) := DOC_STATUS_SUBMITTED;
3798:
3799: iby_disburse_submit_pub_pkg.docspayTab.exclusive_payment_flag(l_trx_line_index)

Line 3872: * Insert document info in IBY_DOCS_PAYABLE_ALL

3868:
3869: END LOOP; -- for limited set of documents fetched
3870:
3871: /*
3872: * Insert document info in IBY_DOCS_PAYABLE_ALL
3873: */
3874:
3875: print_debuginfo(l_module_name, 'Before insert ' );
3876:

Line 3980: INSERT INTO IBY_DOCS_PAYABLE_ALL

3976: print_debuginfo(l_module_name, '1' || iby_disburse_submit_pub_pkg.docspayTab.relationship_id(l_trx_line_index));
3977: END LOOP;
3978:
3979: FORALL l_trx_line_index IN nvl(iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code.FIRST,0) .. nvl(iby_disburse_submit_pub_pkg.docspayTab.pay_proc_trxn_type_code.LAST,-99)
3980: INSERT INTO IBY_DOCS_PAYABLE_ALL
3981: (
3982: pay_proc_trxn_type_code,
3983: calling_app_id,
3984: calling_app_doc_ref_number,

Line 4185: || ' documents into IBY_DOCS_PAYABLE_ALL'

4181: iby_disburse_submit_pub_pkg.docspayTab.relationship_id(l_trx_line_index)
4182: );
4183:
4184: print_debuginfo(l_module_name, 'Finished inserting'
4185: || ' documents into IBY_DOCS_PAYABLE_ALL'
4186: || ' table');
4187:
4188: EXIT WHEN l_docs_cursor%NOTFOUND;
4189:

Line 4293: l_docPayID IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;

4289: FUNCTION getNextDocumentPayableID
4290: RETURN NUMBER
4291: IS
4292:
4293: l_docPayID IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4294:
4295: BEGIN
4296:
4297: SELECT IBY_DOCS_PAYABLE_ALL_S.nextval INTO l_docPayID

Line 4297: SELECT IBY_DOCS_PAYABLE_ALL_S.nextval INTO l_docPayID

4293: l_docPayID IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4294:
4295: BEGIN
4296:
4297: SELECT IBY_DOCS_PAYABLE_ALL_S.nextval INTO l_docPayID
4298: FROM DUAL;
4299:
4300: RETURN l_docPayID;
4301:

Line 4358: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id

4354: | NOTES:
4355: |
4356: *---------------------------------------------------------------------*/
4357: PROCEDURE deriveDistinctAccessTypsForReq(
4358: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
4359: %TYPE,
4360: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
4361: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
4362: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

Line 4360: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,

4356: *---------------------------------------------------------------------*/
4357: PROCEDURE deriveDistinctAccessTypsForReq(
4358: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
4359: %TYPE,
4360: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
4361: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
4362: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
4363: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
4364: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab

Line 4361: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

4357: PROCEDURE deriveDistinctAccessTypsForReq(
4358: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
4359: %TYPE,
4360: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
4361: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
4362: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
4363: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
4364: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
4365: )

Line 4362: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

4358: p_payreq_id IN IBY_DOCS_PAYABLE_ALL.payment_service_request_id
4359: %TYPE,
4360: p_pmt_function IN IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
4361: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
4362: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
4363: x_pmtFxAccessTypesTab IN OUT NOCOPY distinctPmtFxAccessTab,
4364: x_orgAccessTypesTab IN OUT NOCOPY distinctOrgAccessTab
4365: )
4366: IS