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 96: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE

92:
93: l_internal_bank_accts_index varchar2(2000);
94:
95: TYPE payeeTabType is TABLE OF
96: IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE
97: INDEX BY BINARY_INTEGER;
98:
99: l_storedAwtPayees payeeTabType; --Enh 16296267
100:

Line 389: IBY_DOCS_PAYABLE_ALL

385:
386: FOR i in x_errorDocsTab.FIRST..x_errorDocsTab.LAST LOOP
387:
388: UPDATE
389: IBY_DOCS_PAYABLE_ALL
390: SET
391: document_status = x_errorDocsTab(i).doc_status,
392:
393: /*

Line 426: IBY_DOCS_PAYABLE_ALL

422: * validated.
423: */
424: /* Update the status of the valid documents */
425: UPDATE
426: IBY_DOCS_PAYABLE_ALL
427: SET
428: document_status = DOC_STATUS_VALIDATED
429: WHERE
430: document_status NOT IN

Line 651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;

647: l_int_bank_acct_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
648: l_country CE_BANK_BRANCHES_V.country%TYPE;
649: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
650:
651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;
652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;
653:
654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;

Line 652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;

648: l_country CE_BANK_BRANCHES_V.country%TYPE;
649: l_bank_home_country CE_BANK_BRANCHES_V.bank_home_country%TYPE;
650:
651: l_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE;
652: l_payee_party_id IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE;
653:
654: l_profile_id IBY_PAYMENT_PROFILES.payment_profile_id%TYPE;
655: l_payment_format_cd IBY_PAYMENT_PROFILES.payment_format_code%TYPE;
656: l_bepid IBY_PAYMENT_PROFILES.bepid%TYPE;

Line 703: IBY_DOCS_PAYABLE_ALL docs

699: docs.party_site_id,
700: docs.payment_function,
701: docs.affects_rejection_level --AWT Enh 16296267
702: FROM
703: IBY_DOCS_PAYABLE_ALL docs
704: WHERE
705: docs.payment_service_request_id = p_pay_service_request_id
706: AND docs.document_status IN
707: (

Line 719: CURSOR c_validation_sets(p_document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

715: /*
716: * Pick up all validation sets applicable to the
717: * specified document
718: */
719: CURSOR c_validation_sets(p_document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,

716: * Pick up all validation sets applicable to the
717: * specified document
718: */
719: CURSOR c_validation_sets(p_document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,

Line 721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

717: * specified document
718: */
719: CURSOR c_validation_sets(p_document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,

Line 722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

718: */
719: CURSOR c_validation_sets(p_document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,

Line 723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

719: CURSOR c_validation_sets(p_document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
720: p_payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
721: p_ext_payee_id IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
722: p_payment_method_code IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
723: p_int_bank_acct_id IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
724: p_payment_format_code IBY_PAYMENT_PROFILES.payment_format_code%TYPE,
725: p_bepid IBY_PAYMENT_PROFILES.bepid%TYPE,
726: p_transmit_protocol_code IBY_PAYMENT_PROFILES.transmit_protocol_code%TYPE,
727: p_country CE_BANK_BRANCHES_V.country%TYPE

Line 2169: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,

2165: | NOTES:
2166: |
2167: *---------------------------------------------------------------------*/
2168: PROCEDURE performOnlineValidations(
2169: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%type,
2170: x_return_status IN OUT NOCOPY NUMBER)
2171: IS
2172: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
2173: '.performOnlineValidations';

Line 2365: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

2361: | NOTES:
2362: |
2363: *---------------------------------------------------------------------*/
2364: PROCEDURE initDocumentData(
2365: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
2366: x_document_rec IN OUT NOCOPY documentRecType,
2367: p_isOnline IN VARCHAR2
2368: )
2369: IS

Line 2383: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

2379: * modify the fields in the 'documentRecType' record in the spec
2380: * as well.
2381: */
2382: CURSOR c_documentInfo (p_doc_id
2383: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2384: RETURN documentRecType
2385: IS
2386: SELECT
2387: docs.calling_app_id ,

Line 2485: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

2481: * Therefore, perform an outer join with all entities other than
2482: * the IBY_DOCS_PAYABLE_GT.
2483: */
2484: CURSOR c_onlineDocumentInfo(p_doc_id
2485: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2486: RETURN documentRecType
2487: IS
2488: SELECT
2489: docs.calling_app_id calling_app_id,

Line 2575: * attributes from IBY_DOCS_PAYABLE_ALL table.

2571: * cursors pick up the same data except that the
2572: * online document cursor picks up the document attributes
2573: * from IBY_DOCS_PAYABLE_GT whereas the offline
2574: * document validation cursor picks up the document
2575: * attributes from IBY_DOCS_PAYABLE_ALL table.
2576: *
2577: * In fix for bug 5997016, we made the offline doc validation
2578: * cursor pick up the address data dynamically from
2579: * HR or TCA tables depending on the address source column.

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

2580: *
2581: * In the online validation cursor, we will not propagate
2582: * the same logic. There are some reasons for this -
2583: *
2584: * 1. Some columns that are present in IBY_DOCS_PAYABLE_ALL
2585: * table are not present in IBY_DOCS_PAYABLE_GT table.
2586: * E.g., address_source is not available in the GT table.
2587: * Therefore, to support the dynamic payee address
2588: * functionality we would need to make a data model change.

Line 2662: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

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

Line 2675: IBY_DOCS_PAYABLE_ALL docs

2671: docs.calling_app_doc_unique_ref5 calling_app_doc_id5,
2672: docs.pay_proc_trxn_type_code pay_proc_trxn_type_cd,
2673: docs.document_payable_id document_id
2674: FROM
2675: IBY_DOCS_PAYABLE_ALL docs
2676: WHERE
2677: docs.document_payable_id = p_doc_id
2678: ;
2679:

Line 2688: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)

2684: * validation, and we need to provide the identifying fields
2685: * to the validation sets.
2686: */
2687: CURSOR c_basicOnlineDocumentInfo (p_doc_id
2688: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE)
2689: RETURN basicDocRecType
2690: IS
2691: SELECT
2692: docs.calling_app_id calling_app_id,

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

2770: * doc fields will be fetched. This will lead to an empty
2771: * document being returned which causes the program to abort.
2772: *
2773: * In such a case, pick up only the document fields from
2774: * IBY_DOCS_PAYABLE_ALL and pass it back. This document
2775: * will surely fail validation because of the missing fields.
2776: * Since we passed back the basic doc fields, this document
2777: * can be failed in a graceful manner.
2778: */

Line 2875: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

2871: | NOTES:
2872: |
2873: *---------------------------------------------------------------------*/
2874: PROCEDURE initCharValData(
2875: p_document_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
2876: x_charval_rec IN OUT NOCOPY charValRecType
2877: )
2878: IS
2879:

Line 2882: CURSOR c_charval_fields (p_doc_id IBY_DOCS_PAYABLE_ALL.

2878: IS
2879:
2880: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME || '.initCharValData';
2881:
2882: CURSOR c_charval_fields (p_doc_id IBY_DOCS_PAYABLE_ALL.
2883: document_payable_id%TYPE)
2884: IS
2885: SELECT
2886:

Line 3002: IBY_DOCS_PAYABLE_ALL doc,

2998: eba.short_acct_name, -- payee bank account short name
2999: '' -- payee bank acct holder name alt
3000: FROM
3001: /* Document related */
3002: IBY_DOCS_PAYABLE_ALL doc,
3003: IBY_PAYMENT_REASONS_VL pmt_reason,
3004: IBY_DELIVERY_CHANNELS_VL dlv,
3005: IBY_DOCUMENT_LINES lines,
3006: /* Payer */

Line 3146: FROM iby_docs_payable_all

3142:
3143: -- Get payment_reason_count (for Belgium)
3144: SELECT count(distinct payment_reason_code)
3145: INTO x_payment_rec.pmt_payment_reason_count
3146: FROM iby_docs_payable_all
3147: WHERE payment_id = p_payment_id;
3148:
3149: CLOSE c_payment_rec;
3150:

Line 3233: from iby_docs_payable_all d, iby_payments_all p

3229: select sum(d.document_amount),
3230: count(d.document_payable_id)
3231: into x_instruction_rec.ins_amount,
3232: x_instruction_rec.ins_document_count
3233: from iby_docs_payable_all d, iby_payments_all p
3234: where p.payment_instruction_id = p_instruction_id
3235: and p.payment_id = d.payment_id
3236:
3237: /*

Line 5129: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE

5125: --l_doc_err_rec docErrorRecType;
5126: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5127:
5128: TYPE pmtGrpNumTabType is TABLE OF
5129: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
5130: INDEX BY BINARY_INTEGER;
5131:
5132: l_storedPmtGrpNumTab pmtGrpNumTabType;
5133: l_already_processed_flag BOOLEAN := FALSE;

Line 5336: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE

5332: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5333: l_doc_token_tab trxnErrTokenTabType;
5334:
5335: TYPE payeeTabType is TABLE OF
5336: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE
5337: INDEX BY BINARY_INTEGER;
5338:
5339: l_storedPayeesTab payeeTabType;
5340: l_already_processed_flag BOOLEAN := FALSE;

Line 5567: l_triggering_doc IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE;

5563: l_print_var VARCHAR2(1) := '';
5564: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5565: l_doc_token_tab trxnErrTokenTabType;
5566: l_index NUMBER := 0;
5567: l_triggering_doc IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE;
5568:
5569: BEGIN
5570:
5571: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5899: || 'FROM iby_docs_payable_all '

5895: || 'calling_app_doc_unique_ref3, '
5896: || 'calling_app_doc_unique_ref4, '
5897: || 'calling_app_doc_unique_ref5, '
5898: || 'pay_proc_trxn_type_code '
5899: || 'FROM iby_docs_payable_all '
5900: || 'WHERE payment_service_request_id = :payreq_id '
5901: || 'AND document_status <> :doc_status';
5902:
5903: l_ctx := DBMS_XMLQuery.newContext(l_sql);

Line 6009: IBY_DOCS_PAYABLE_ALL doc

6005: SELECT
6006: doc.document_payable_id,
6007: doc.document_status
6008: FROM
6009: IBY_DOCS_PAYABLE_ALL doc
6010: WHERE
6011: doc.payment_service_request_id = p_payreq_id AND
6012: doc.document_status <> DOC_STATUS_VALIDATED
6013: ;

Line 6072: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

6068: |
6069: |
6070: *---------------------------------------------------------------------*/
6071: FUNCTION checkIfDocFailed(
6072: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6073: p_failedDocsTab IN docStatusTabType
6074: )
6075: RETURN BOOLEAN
6076: IS

Line 6400: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

6396: |
6397: |
6398: *---------------------------------------------------------------------*/
6399: FUNCTION validateProfileFromProfDrivers(
6400: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

Line 6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

6397: |
6398: *---------------------------------------------------------------------*/
6399: FUNCTION validateProfileFromProfDrivers(
6400: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6405: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

Line 6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

6398: *---------------------------------------------------------------------*/
6399: FUNCTION validateProfileFromProfDrivers(
6400: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6405: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6406: )

Line 6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

6399: FUNCTION validateProfileFromProfDrivers(
6400: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6405: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6406: )
6407: RETURN BOOLEAN

Line 6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

6400: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6405: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6406: )
6407: RETURN BOOLEAN
6408: IS

Line 6405: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE

6401: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
6402: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
6403: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
6404: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
6405: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE
6406: )
6407: RETURN BOOLEAN
6408: IS
6409: l_return_flag BOOLEAN := FALSE;

Line 6415: l_profile_id IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE;

6411: := G_PKG_NAME ||
6412: '.validateProfileFromProfDrivers';
6413:
6414: l_valid_flag VARCHAR2(1);
6415: l_profile_id IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE;
6416:
6417: BEGIN
6418:
6419: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6498: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

6494: | NOTES:
6495: |
6496: *---------------------------------------------------------------------*/
6497: FUNCTION checkProfileFormatCompat(
6498: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6499: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
6500: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
6501: ) RETURN BOOLEAN
6502: IS

Line 6499: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

6495: |
6496: *---------------------------------------------------------------------*/
6497: FUNCTION checkProfileFormatCompat(
6498: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6499: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
6500: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
6501: ) RETURN BOOLEAN
6502: IS
6503: l_return_flag BOOLEAN;

Line 6500: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE

6496: *---------------------------------------------------------------------*/
6497: FUNCTION checkProfileFormatCompat(
6498: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
6499: p_payee_id IN IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
6500: p_profile_id IN IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
6501: ) RETURN BOOLEAN
6502: IS
6503: l_return_flag BOOLEAN;
6504: l_module_name CONSTANT VARCHAR2(200)

Line 6969: IBY_DOCS_PAYABLE_ALL docs,

6965: docs.payment_method_code payment_method_cd,
6966: docs.payment_format_code payee_payment_format_cd,
6967: payeesite.party_site_name payee_party_site_name
6968: FROM
6969: IBY_DOCS_PAYABLE_ALL docs,
6970: IBY_PP_FIRST_PARTY_V payer,
6971: HZ_PARTIES payee,
6972: HZ_PARTY_SITES payeesite,
6973: CE_BANK_ACCOUNTS iba,

Line 7612: IBY_DOCS_PAYABLE_ALL doc,

7608: ) add_concat,
7609: doc.document_payable_id document_payable_id
7610:
7611: FROM
7612: IBY_DOCS_PAYABLE_ALL doc,
7613:
7614: /* Employee address related */
7615: HR_LOCATIONS per_loc,
7616: PER_ADDRESSES per_addr,