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

Line 677: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

673: |
674: *---------------------------------------------------------------------*/
675: PROCEDURE createErrorRecord(
676: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
677: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
681: calling_app_doc_unique_ref1%TYPE,

Line 678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,

674: *---------------------------------------------------------------------*/
675: PROCEDURE createErrorRecord(
676: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
677: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
681: calling_app_doc_unique_ref1%TYPE,
682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.

Line 679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

675: PROCEDURE createErrorRecord(
676: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
677: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
681: calling_app_doc_unique_ref1%TYPE,
682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
683: calling_app_doc_unique_ref2%TYPE,

Line 680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.

676: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
677: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
681: calling_app_doc_unique_ref1%TYPE,
682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
683: calling_app_doc_unique_ref2%TYPE,
684: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.

Line 682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.

678: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
679: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
681: calling_app_doc_unique_ref1%TYPE,
682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
683: calling_app_doc_unique_ref2%TYPE,
684: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
685: calling_app_doc_unique_ref3%TYPE,
686: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.

Line 684: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.

680: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
681: calling_app_doc_unique_ref1%TYPE,
682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
683: calling_app_doc_unique_ref2%TYPE,
684: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
685: calling_app_doc_unique_ref3%TYPE,
686: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
687: calling_app_doc_unique_ref4%TYPE,
688: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.

Line 686: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.

682: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
683: calling_app_doc_unique_ref2%TYPE,
684: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
685: calling_app_doc_unique_ref3%TYPE,
686: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
687: calling_app_doc_unique_ref4%TYPE,
688: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
689: calling_app_doc_unique_ref5%TYPE,
690: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 688: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.

684: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
685: calling_app_doc_unique_ref3%TYPE,
686: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
687: calling_app_doc_unique_ref4%TYPE,
688: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
689: calling_app_doc_unique_ref5%TYPE,
690: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
691: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
692: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,

Line 690: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

686: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
687: calling_app_doc_unique_ref4%TYPE,
688: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
689: calling_app_doc_unique_ref5%TYPE,
690: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
691: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
692: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
693: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
694: DEFAULT NULL,

Line 693: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE

689: calling_app_doc_unique_ref5%TYPE,
690: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
691: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
692: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
693: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
694: DEFAULT NULL,
695: p_error_code IN VARCHAR2 DEFAULT NULL
696: )
697: IS

Line 901: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

897: | NOTES:
898: |
899: *---------------------------------------------------------------------*/
900: PROCEDURE getProfListFromProfileDrivers(
901: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
902: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
903: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
904: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
905: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 902: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

898: |
899: *---------------------------------------------------------------------*/
900: PROCEDURE getProfListFromProfileDrivers(
901: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
902: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
903: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
904: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
905: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
906: x_profilesTab IN OUT NOCOPY pmtProfTabType

Line 903: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

899: *---------------------------------------------------------------------*/
900: PROCEDURE getProfListFromProfileDrivers(
901: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
902: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
903: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
904: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
905: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
906: x_profilesTab IN OUT NOCOPY pmtProfTabType
907: )

Line 904: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

900: PROCEDURE getProfListFromProfileDrivers(
901: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
902: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
903: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
904: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
905: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
906: x_profilesTab IN OUT NOCOPY pmtProfTabType
907: )
908: IS

Line 905: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

901: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
902: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
903: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
904: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
905: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
906: x_profilesTab IN OUT NOCOPY pmtProfTabType
907: )
908: IS
909: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 967: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.

963: * Redundant joins of the form where a=b=c=a execute faster than
964: * where a=b=c joins. That's why this select has a redundant join.
965: */
966: CURSOR c_profiles(
967: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
968: payment_method_code%TYPE,
969: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
970: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
971: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.

Line 969: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

965: */
966: CURSOR c_profiles(
967: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
968: payment_method_code%TYPE,
969: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
970: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
971: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
972: payment_currency_code%TYPE,
973: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.

Line 970: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

966: CURSOR c_profiles(
967: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
968: payment_method_code%TYPE,
969: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
970: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
971: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
972: payment_currency_code%TYPE,
973: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.
974: internal_bank_account_id%TYPE

Line 971: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.

967: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
968: payment_method_code%TYPE,
969: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
970: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
971: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
972: payment_currency_code%TYPE,
973: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.
974: internal_bank_account_id%TYPE
975: )

Line 973: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.

969: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
970: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
971: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
972: payment_currency_code%TYPE,
973: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.
974: internal_bank_account_id%TYPE
975: )
976: IS
977: SELECT

Line 1312: IBY_DOCS_PAYABLE_ALL

1308: (
1309: SELECT
1310: document_payable_id
1311: FROM
1312: IBY_DOCS_PAYABLE_ALL
1313: WHERE
1314: payment_id = p_trxn_id
1315: )
1316: AND

Line 1338: IBY_DOCS_PAYABLE_ALL doc

1334: || DOC_STATUS_VALIDATED
1335: );
1336:
1337: UPDATE
1338: IBY_DOCS_PAYABLE_ALL doc
1339: SET
1340: doc.document_status = DOC_STATUS_VALIDATED
1341: WHERE
1342: doc.document_payable_id = p_trxn_id