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_DOCS_PAYABLE_ALL

Line 327: IBY_DOCS_PAYABLE_ALL

323:
324: FOR i in x_errorDocsTab.FIRST..x_errorDocsTab.LAST LOOP
325:
326: UPDATE
327: IBY_DOCS_PAYABLE_ALL
328: SET
329: document_status = x_errorDocsTab(i).doc_status,
330:
331: /*

Line 364: IBY_DOCS_PAYABLE_ALL

360: * validated.
361: */
362: /* Update the status of the valid documents */
363: UPDATE
364: IBY_DOCS_PAYABLE_ALL
365: SET
366: document_status = DOC_STATUS_VALIDATED
367: WHERE
368: document_status NOT IN

Line 599: IBY_DOCS_PAYABLE_ALL docs,

595: nvl(iba_branch.country,iba_branch.bank_home_country) int_bank_country_code,
596: eba.country_code ext_bank_country_code,
597: eba.foreign_payment_use_flag foreign_pmts_allowed_flag
598: FROM
599: IBY_DOCS_PAYABLE_ALL docs,
600: CE_BANK_ACCOUNTS iba,
601: CE_BANK_BRANCHES_V iba_branch,
602: IBY_EXT_BANK_ACCOUNTS_V eba
603: WHERE

Line 623: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

619: * Pick up all validation sets applicable to the
620: * specified document
621: */
622: CURSOR c_validation_sets(p_document_payable_id
623: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
624: IS
625: SELECT DISTINCT
626: docs.document_payable_id,
627: docs.payment_grouping_number,

Line 638: IBY_DOCS_PAYABLE_ALL docs,

634: val.validation_set_display_name
635: FROM
636: IBY_VALIDATION_SETS_VL val,
637: IBY_VAL_ASSIGNMENTS val_options,
638: IBY_DOCS_PAYABLE_ALL docs,
639: IBY_SYS_PMT_PROFILES_B sys_prof,
640: IBY_ACCT_PMT_PROFILES_B acct_prof,
641: IBY_TRANSMIT_CONFIGS_B txconf,
642: IBY_TRANSMIT_PROTOCOLS_B txproto,

Line 1597: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,

1593: | NOTES:
1594: |
1595: *---------------------------------------------------------------------*/
1596: PROCEDURE performOnlineValidations(
1597: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
1598: x_return_status IN OUT NOCOPY NUMBER)
1599: IS
1600: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
1601: '.performOnlineValidations';

Line 1775: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

1771: | NOTES:
1772: |
1773: *---------------------------------------------------------------------*/
1774: PROCEDURE initDocumentData(
1775: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1776: x_document_rec IN OUT NOCOPY documentRecType,
1777: p_isOnline IN VARCHAR2
1778: )
1779: IS

Line 1793: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

1789: * modify the fields in the 'documentRecType' record in the spec
1790: * as well.
1791: */
1792: CURSOR c_documentInfo (p_doc_id
1793: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
1794: RETURN documentRecType
1795: IS
1796: SELECT
1797: docs.calling_app_id calling_app_id,

Line 1880: IBY_DOCS_PAYABLE_ALL docs,

1876: docs.payment_reason_code payment_reason_code,
1877: docs.payment_method_code payment_method_cd,
1878: docs.payment_format_code payee_payment_format_cd
1879: FROM
1880: IBY_DOCS_PAYABLE_ALL docs,
1881: IBY_PP_FIRST_PARTY_V payer,
1882: HZ_PARTIES payee,
1883: CE_BANK_ACCOUNTS iba,
1884: CE_BANK_BRANCHES_V iba_bnk_branch,

Line 2428: IBY_DOCS_PAYABLE_ALL doc,

2424: )
2425: ) add_concat
2426:
2427: FROM
2428: IBY_DOCS_PAYABLE_ALL doc,
2429:
2430: /* Employee address related */
2431: HR_LOCATIONS per_loc,
2432: PER_ADDRESSES per_addr,

Line 2476: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

2472: * Therefore, perform an outer join with all entities other than
2473: * the IBY_DOCS_PAYABLE_GT.
2474: */
2475: CURSOR c_onlineDocumentInfo(p_doc_id
2476: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2477: RETURN documentRecType
2478: IS
2479: SELECT
2480: docs.calling_app_id calling_app_id,

Line 2557: * attributes from IBY_DOCS_PAYABLE_ALL table.

2553: * cursors pick up the same data except that the
2554: * online document cursor picks up the document attributes
2555: * from IBY_DOCS_PAYABLE_GT whereas the offline
2556: * document validation cursor picks up the document
2557: * attributes from IBY_DOCS_PAYABLE_ALL table.
2558: *
2559: * In fix for bug 5997016, we made the offline doc validation
2560: * cursor pick up the address data dynamically from
2561: * HR or TCA tables depending on the address source column.

Line 2566: * 1. Some columns that are present in IBY_DOCS_PAYABLE_ALL

2562: *
2563: * In the online validation cursor, we will not propagate
2564: * the same logic. There are some reasons for this -
2565: *
2566: * 1. Some columns that are present in IBY_DOCS_PAYABLE_ALL
2567: * table are not present in IBY_DOCS_PAYABLE_GT table.
2568: * E.g., address_source is not available in the GT table.
2569: * Therefore, to support the dynamic payee address
2570: * functionality we would need to make a data model change.

Line 2639: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

2635: * validation, and we need to provide the identifying fields
2636: * to the validation sets.
2637: */
2638: CURSOR c_basicDocumentInfo (p_doc_id
2639: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2640: RETURN basicDocRecType
2641: IS
2642: SELECT
2643: docs.calling_app_id calling_app_id,

Line 2652: IBY_DOCS_PAYABLE_ALL docs

2648: docs.calling_app_doc_unique_ref5 calling_app_doc_id5,
2649: docs.pay_proc_trxn_type_code pay_proc_trxn_type_cd,
2650: docs.document_payable_id document_id
2651: FROM
2652: IBY_DOCS_PAYABLE_ALL docs
2653: WHERE
2654: docs.document_payable_id = p_doc_id
2655: ;
2656:

Line 2665: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

2661: * validation, and we need to provide the identifying fields
2662: * to the validation sets.
2663: */
2664: CURSOR c_basicOnlineDocumentInfo (p_doc_id
2665: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2666: RETURN basicDocRecType
2667: IS
2668: SELECT
2669: docs.calling_app_id calling_app_id,

Line 2745: * IBY_DOCS_PAYABLE_ALL and pass it back. This document

2741: * doc fields will be fetched. This will lead to an empty
2742: * document being returned which causes the program to abort.
2743: *
2744: * In such a case, pick up only the document fields from
2745: * IBY_DOCS_PAYABLE_ALL and pass it back. This document
2746: * will surely fail validation because of the missing fields.
2747: * Since we passed back the basic doc fields, this document
2748: * can be failed in a graceful manner.
2749: */

Line 2840: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

2836: | NOTES:
2837: |
2838: *---------------------------------------------------------------------*/
2839: PROCEDURE initCharValData(
2840: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
2841: x_charval_rec IN OUT NOCOPY charValRecType
2842: )
2843: IS
2844:

Line 2847: CURSOR c_charval_fields (p_doc_id IBY_DOCS_PAYABLE_ALL.

2843: IS
2844:
2845: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.initCharValData';
2846:
2847: CURSOR c_charval_fields (p_doc_id IBY_DOCS_PAYABLE_ALL.
2848: document_payable_id%TYPE)
2849: IS
2850: SELECT
2851:

Line 2967: IBY_DOCS_PAYABLE_ALL doc,

2963: eba.short_acct_name, -- payee bank account short name
2964: '' -- payee bank acct holder name alt
2965: FROM
2966: /* Document related */
2967: IBY_DOCS_PAYABLE_ALL doc,
2968: IBY_PAYMENT_REASONS_VL pmt_reason,
2969: IBY_DELIVERY_CHANNELS_VL dlv,
2970: IBY_DOCUMENT_LINES lines,
2971: /* Payer */

Line 3099: FROM iby_docs_payable_all

3095:
3096: -- Get payment_reason_count (for Belgium)
3097: SELECT count(distinct payment_reason_code)
3098: INTO x_payment_rec.pmt_payment_reason_count
3099: FROM iby_docs_payable_all
3100: WHERE payment_id = p_payment_id;
3101:
3102: CLOSE c_payment_rec;
3103:

Line 3182: from iby_docs_payable_all d, iby_payments_all p

3178: select sum(d.document_amount),
3179: count(d.document_payable_id)
3180: into x_instruction_rec.ins_amount,
3181: x_instruction_rec.ins_document_count
3182: from iby_docs_payable_all d, iby_payments_all p
3183: where p.payment_instruction_id = p_instruction_id
3184: and p.payment_id = d.payment_id
3185:
3186: /*

Line 5000: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE

4996: --l_doc_err_rec docErrorRecType;
4997: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
4998:
4999: TYPE pmtGrpNumTabType is TABLE OF
5000: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
5001: INDEX BY BINARY_INTEGER;
5002:
5003: l_storedPmtGrpNumTab pmtGrpNumTabType;
5004: l_already_processed_flag BOOLEAN := FALSE;

Line 5197: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

5193: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5194: l_doc_token_tab trxnErrTokenTabType;
5195:
5196: TYPE payeeTabType is TABLE OF
5197: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
5198: INDEX BY BINARY_INTEGER;
5199:
5200: l_storedPayeesTab payeeTabType;
5201: l_already_processed_flag BOOLEAN := FALSE;

Line 5414: l_triggering_doc IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;

5410: l_print_var VARCHAR2(1) := '';
5411: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5412: l_doc_token_tab trxnErrTokenTabType;
5413: l_index NUMBER := 0;
5414: l_triggering_doc IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
5415:
5416: BEGIN
5417:
5418: print_debuginfo(l_module_name, 'ENTER');

Line 5561: || 'FROM iby_docs_payable_all '

5557: || 'calling_app_doc_unique_ref3, '
5558: || 'calling_app_doc_unique_ref4, '
5559: || 'calling_app_doc_unique_ref5, '
5560: || 'pay_proc_trxn_type_code '
5561: || 'FROM iby_docs_payable_all '
5562: || 'WHERE payment_service_request_id = :payreq_id '
5563: || 'AND document_status <> :doc_status';
5564:
5565: l_ctx := DBMS_XMLQuery.newContext(l_sql);

Line 5663: IBY_DOCS_PAYABLE_ALL doc

5659: SELECT
5660: doc.document_payable_id,
5661: doc.document_status
5662: FROM
5663: IBY_DOCS_PAYABLE_ALL doc
5664: WHERE
5665: doc.payment_service_request_id = p_payreq_id AND
5666: doc.document_status <> DOC_STATUS_VALIDATED
5667: ;

Line 5722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

5718: |
5719: |
5720: *---------------------------------------------------------------------*/
5721: FUNCTION checkIfDocFailed(
5722: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
5723: p_failedDocsTab IN docStatusTabType
5724: )
5725: RETURN BOOLEAN
5726: IS

Line 6026: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

6022: |
6023: |
6024: *---------------------------------------------------------------------*/
6025: FUNCTION validateProfileFromProfDrivers(
6026: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

Line 6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

6023: |
6024: *---------------------------------------------------------------------*/
6025: FUNCTION validateProfileFromProfDrivers(
6026: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6031: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

Line 6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

6024: *---------------------------------------------------------------------*/
6025: FUNCTION validateProfileFromProfDrivers(
6026: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6031: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6032: )

Line 6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

6025: FUNCTION validateProfileFromProfDrivers(
6026: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6031: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6032: )
6033: RETURN BOOLEAN

Line 6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

6026: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6031: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6032: )
6033: RETURN BOOLEAN
6034: IS

Line 6031: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

6027: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6028: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6029: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6030: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6031: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6032: )
6033: RETURN BOOLEAN
6034: IS
6035: l_return_flag BOOLEAN := FALSE;

Line 6138: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

6134: | NOTES:
6135: |
6136: *---------------------------------------------------------------------*/
6137: FUNCTION checkProfileFormatCompat(
6138: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6139: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
6140: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6141: p_payeeFormatTab IN payeeFormatTabType,
6142: p_profileFormatTab IN profileFormatTabType

Line 6139: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

6135: |
6136: *---------------------------------------------------------------------*/
6137: FUNCTION checkProfileFormatCompat(
6138: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6139: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
6140: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6141: p_payeeFormatTab IN payeeFormatTabType,
6142: p_profileFormatTab IN profileFormatTabType
6143: ) RETURN BOOLEAN

Line 6140: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

6136: *---------------------------------------------------------------------*/
6137: FUNCTION checkProfileFormatCompat(
6138: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6139: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
6140: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6141: p_payeeFormatTab IN payeeFormatTabType,
6142: p_profileFormatTab IN profileFormatTabType
6143: ) RETURN BOOLEAN
6144: IS