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 50: l_profile_id IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

46: --
47: TRXN_ERROR_ACTIVE CONSTANT VARCHAR2(100) := 'ACTIVE';
48:
49: TYPE l_prof_der_rec_type IS RECORD(
50: l_profile_id IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
51: l_valid_flag VARCHAR2(1)
52: );
53:
54: TYPE l_prof_der_tbl_type IS TABLE OF l_prof_der_rec_type INDEX BY VARCHAR2(2000);

Line 722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

718: |
719: *---------------------------------------------------------------------*/
720: PROCEDURE createErrorRecord(
721: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
726: calling_app_doc_unique_ref1%TYPE,

Line 723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,

719: *---------------------------------------------------------------------*/
720: PROCEDURE createErrorRecord(
721: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
726: calling_app_doc_unique_ref1%TYPE,
727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.

Line 724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

720: PROCEDURE createErrorRecord(
721: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
726: calling_app_doc_unique_ref1%TYPE,
727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
728: calling_app_doc_unique_ref2%TYPE,

Line 725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.

721: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
726: calling_app_doc_unique_ref1%TYPE,
727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
728: calling_app_doc_unique_ref2%TYPE,
729: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.

Line 727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.

723: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
724: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
726: calling_app_doc_unique_ref1%TYPE,
727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
728: calling_app_doc_unique_ref2%TYPE,
729: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
730: calling_app_doc_unique_ref3%TYPE,
731: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.

Line 729: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.

725: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
726: calling_app_doc_unique_ref1%TYPE,
727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
728: calling_app_doc_unique_ref2%TYPE,
729: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
730: calling_app_doc_unique_ref3%TYPE,
731: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
732: calling_app_doc_unique_ref4%TYPE,
733: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.

Line 731: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.

727: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
728: calling_app_doc_unique_ref2%TYPE,
729: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
730: calling_app_doc_unique_ref3%TYPE,
731: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
732: calling_app_doc_unique_ref4%TYPE,
733: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
734: calling_app_doc_unique_ref5%TYPE,
735: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 733: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.

729: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
730: calling_app_doc_unique_ref3%TYPE,
731: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
732: calling_app_doc_unique_ref4%TYPE,
733: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
734: calling_app_doc_unique_ref5%TYPE,
735: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
736: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
737: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,

Line 735: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

731: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
732: calling_app_doc_unique_ref4%TYPE,
733: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
734: calling_app_doc_unique_ref5%TYPE,
735: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
736: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
737: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
738: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE -- AWT Enh 16296267
739: DEFAULT NULL,

Line 738: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE -- AWT Enh 16296267

734: calling_app_doc_unique_ref5%TYPE,
735: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
736: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
737: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
738: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE -- AWT Enh 16296267
739: DEFAULT NULL,
740: p_error_code IN VARCHAR2 DEFAULT NULL
741: )
742: IS

Line 939: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

935: END IF;
936: END createPmtErrorRecord;
937:
938: PROCEDURE getProfListFromProfileDrivers(
939: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

936: END createPmtErrorRecord;
937:
938: PROCEDURE getProfListFromProfileDrivers(
939: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
944: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

Line 941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

937:
938: PROCEDURE getProfListFromProfileDrivers(
939: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
944: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
945: p_valid_flag OUT NOCOPY VARCHAR2

Line 942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

938: PROCEDURE getProfListFromProfileDrivers(
939: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
944: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
945: p_valid_flag OUT NOCOPY VARCHAR2
946: )

Line 943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

939: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
944: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
945: p_valid_flag OUT NOCOPY VARCHAR2
946: )
947: IS

Line 944: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

940: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
941: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
942: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
943: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
944: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
945: p_valid_flag OUT NOCOPY VARCHAR2
946: )
947: IS
948: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 1188: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

1184: | NOTES:
1185: |
1186: *---------------------------------------------------------------------*/
1187: PROCEDURE getProfListFromProfileDrivers(
1188: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1189: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1190: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1191: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1192: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 1189: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1185: |
1186: *---------------------------------------------------------------------*/
1187: PROCEDURE getProfListFromProfileDrivers(
1188: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1189: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1190: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1191: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1192: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1193: x_profilesTab IN OUT NOCOPY pmtProfTabType

Line 1190: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1186: *---------------------------------------------------------------------*/
1187: PROCEDURE getProfListFromProfileDrivers(
1188: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1189: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1190: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1191: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1192: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1193: x_profilesTab IN OUT NOCOPY pmtProfTabType
1194: )

Line 1191: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

1187: PROCEDURE getProfListFromProfileDrivers(
1188: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1189: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1190: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1191: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1192: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1193: x_profilesTab IN OUT NOCOPY pmtProfTabType
1194: )
1195: IS

Line 1192: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

1188: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1189: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1190: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1191: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1192: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1193: x_profilesTab IN OUT NOCOPY pmtProfTabType
1194: )
1195: IS
1196: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||

Line 1254: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.

1250: * Redundant joins of the form where a=b=c=a execute faster than
1251: * where a=b=c joins. That's why this select has a redundant join.
1252: */
1253: CURSOR c_profiles(
1254: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
1255: payment_method_code%TYPE,
1256: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1257: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1258: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.

Line 1256: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1252: */
1253: CURSOR c_profiles(
1254: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
1255: payment_method_code%TYPE,
1256: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1257: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1258: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
1259: payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.

Line 1257: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1253: CURSOR c_profiles(
1254: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
1255: payment_method_code%TYPE,
1256: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1257: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1258: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
1259: payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.
1261: internal_bank_account_id%TYPE

Line 1258: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.

1254: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.
1255: payment_method_code%TYPE,
1256: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1257: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1258: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
1259: payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.
1261: internal_bank_account_id%TYPE
1262: )

Line 1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.

1256: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1257: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1258: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.
1259: payment_currency_code%TYPE,
1260: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.
1261: internal_bank_account_id%TYPE
1262: )
1263: IS
1264: SELECT

Line 1637: IBY_DOCS_PAYABLE_ALL

1633: (
1634: SELECT
1635: document_payable_id
1636: FROM
1637: IBY_DOCS_PAYABLE_ALL
1638: WHERE
1639: payment_id = p_trxn_id
1640: )
1641: AND

Line 1665: IBY_DOCS_PAYABLE_ALL doc

1661: );
1662:
1663: END IF;
1664: UPDATE
1665: IBY_DOCS_PAYABLE_ALL doc
1666: SET
1667: doc.document_status = DOC_STATUS_VALIDATED
1668: WHERE
1669: doc.document_payable_id = p_trxn_id

Line 1800: IBY_DOCS_PAYABLE_ALL docs

1796: (
1797: SELECT
1798: docs.document_payable_id
1799: FROM
1800: IBY_DOCS_PAYABLE_ALL docs
1801: WHERE
1802: docs.document_status = DOC_STATUS_PAY_VAL_FAIL AND
1803: docs.payment_service_request_id = p_payment_request_id
1804: )

Line 1880: IBY_DOCS_PAYABLE_ALL

1876: (
1877: SELECT
1878: document_payable_id
1879: FROM
1880: IBY_DOCS_PAYABLE_ALL
1881: WHERE
1882: payment_service_request_id = p_payment_request_id AND
1883: document_status = DOC_STATUS_FAIL_VALID
1884: )

Line 1892: IBY_DOCS_PAYABLE_ALL

1888: * Reset the status of documents that are to be re-validated to
1889: * 'VALIDATED'.
1890: */
1891: UPDATE
1892: IBY_DOCS_PAYABLE_ALL
1893: SET
1894: document_status = DOC_STATUS_VALIDATED
1895: WHERE
1896: payment_service_request_id = p_payment_request_id AND