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_EXTERNAL_PAYEES_ALL

Line 2905: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,

2901: | NOTES:
2902: |
2903: *---------------------------------------------------------------------*/
2904: FUNCTION derivePayeeIdFromContext(
2905: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

Line 2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,

2902: |
2903: *---------------------------------------------------------------------*/
2904: FUNCTION derivePayeeIdFromContext(
2905: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

Line 2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,

2903: *---------------------------------------------------------------------*/
2904: FUNCTION derivePayeeIdFromContext(
2905: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
2911: )

Line 2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,

2904: FUNCTION derivePayeeIdFromContext(
2905: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
2911: )
2912: RETURN NUMBER

Line 2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

2905: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
2911: )
2912: RETURN NUMBER
2913: IS

Line 2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

2906: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
2907: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
2908: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
2909: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
2911: )
2912: RETURN NUMBER
2913: IS
2914: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

Line 2914: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

2910: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
2911: )
2912: RETURN NUMBER
2913: IS
2914: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
2915: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
2916: '.derivePayeeIdFromContext';
2917:
2918: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

Line 2918: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

2914: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
2915: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
2916: '.derivePayeeIdFromContext';
2917:
2918: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;
2919:
2920: l_payee_index VARCHAR2(200);
2921:
2922:

Line 3006: IBY_EXTERNAL_PAYEES_ALL

3002:
3003: SELECT
3004: ext_payee_id INTO l_payee_id
3005: FROM
3006: IBY_EXTERNAL_PAYEES_ALL
3007: WHERE
3008: payee_party_id = p_payee_party_id AND
3009: payment_function = p_pmt_function AND
3010: NVL(party_site_id, '0') = NVL(l_payee_party_site_id, '0') AND

Line 3074: IBY_EXTERNAL_PAYEES_ALL

3070:
3071: SELECT
3072: ext_payee_id INTO l_payee_id
3073: FROM
3074: IBY_EXTERNAL_PAYEES_ALL
3075: WHERE
3076: payee_party_id = p_payee_party_id AND
3077: payment_function = p_pmt_function AND
3078: NVL(party_site_id, '0') = NVL(l_payee_party_site_id, '0') AND

Line 3145: IBY_EXTERNAL_PAYEES_ALL

3141:
3142: SELECT
3143: ext_payee_id INTO l_payee_id
3144: FROM
3145: IBY_EXTERNAL_PAYEES_ALL
3146: WHERE
3147: payee_party_id = p_payee_party_id AND
3148: payment_function = p_pmt_function AND
3149: party_site_id IS NULL AND

Line 3250: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,

3246: | NOTES:
3247: |
3248: *---------------------------------------------------------------------*/
3249: FUNCTION deriveExactPayeeIdFromContext(
3250: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

Line 3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,

3247: |
3248: *---------------------------------------------------------------------*/
3249: FUNCTION deriveExactPayeeIdFromContext(
3250: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

Line 3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,

3248: *---------------------------------------------------------------------*/
3249: FUNCTION deriveExactPayeeIdFromContext(
3250: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3256: )

Line 3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,

3249: FUNCTION deriveExactPayeeIdFromContext(
3250: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3256: )
3257: RETURN NUMBER

Line 3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

3250: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3256: )
3257: RETURN NUMBER
3258: IS

Line 3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

3251: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3252: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3253: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3254: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3256: )
3257: RETURN NUMBER
3258: IS
3259: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

Line 3259: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

3255: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3256: )
3257: RETURN NUMBER
3258: IS
3259: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3260: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3261: '.deriveExactPayeeIdFromContext';
3262:
3263: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

Line 3263: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

3259: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3260: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3261: '.deriveExactPayeeIdFromContext';
3262:
3263: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;
3264:
3265: BEGIN
3266:
3267: print_debuginfo(l_module_name, 'ENTER');

Line 3327: IBY_EXTERNAL_PAYEES_ALL

3323:
3324: SELECT
3325: ext_payee_id INTO l_payee_id
3326: FROM
3327: IBY_EXTERNAL_PAYEES_ALL
3328: WHERE
3329: payee_party_id = p_payee_party_id AND
3330: payment_function = p_pmt_function AND
3331: NVL(party_site_id, '0') = NVL(l_payee_party_site_id, '0') AND

Line 3476: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

3472:
3473: l_lines_view_name VARCHAR2(200);
3474:
3475: /* payee conext generated internally based on supplied payee fields */
3476: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3477:
3478: l_pmtFxAccessTypesTab distinctPmtFxAccessTab;
3479: l_orgAccessTypesTab distinctOrgAccessTab;
3480:

Line 3805: -- derive the payee id from the IBY_EXTERNAL_PAYEES_ALL table.

3801:
3802: --
3803: -- From the given payee context (payee party id, payee party site
3804: -- id, supplier site id, org id and org type) on the document,
3805: -- derive the payee id from the IBY_EXTERNAL_PAYEES_ALL table.
3806: --
3807: l_payee_id := derivePayeeIdFromContext(
3808: iby_disburse_submit_pub_pkg.docspayTab.payee_party_id(l_trx_line_index),
3809: iby_disburse_submit_pub_pkg.docspayTab.party_site_id(l_trx_line_index),