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 3555: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,

3551: | NOTES:
3552: |
3553: *---------------------------------------------------------------------*/
3554: FUNCTION derivePayeeIdFromContext(
3555: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

Line 3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,

3552: |
3553: *---------------------------------------------------------------------*/
3554: FUNCTION derivePayeeIdFromContext(
3555: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

Line 3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,

3553: *---------------------------------------------------------------------*/
3554: FUNCTION derivePayeeIdFromContext(
3555: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3561: )

Line 3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,

3554: FUNCTION derivePayeeIdFromContext(
3555: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3561: )
3562: RETURN NUMBER

Line 3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

3555: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3561: )
3562: RETURN NUMBER
3563: IS

Line 3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

3556: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3557: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3558: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3559: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3561: )
3562: RETURN NUMBER
3563: IS
3564: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

Line 3564: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

3560: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3561: )
3562: RETURN NUMBER
3563: IS
3564: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3565: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3566: '.derivePayeeIdFromContext';
3567:
3568: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

Line 3568: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

3564: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3565: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3566: '.derivePayeeIdFromContext';
3567:
3568: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;
3569:
3570: l_payee_index VARCHAR2(200);
3571:
3572:

Line 3663: IBY_EXTERNAL_PAYEES_ALL

3659: */
3660: SELECT
3661: ext_payee_id INTO l_payee_id
3662: FROM
3663: IBY_EXTERNAL_PAYEES_ALL
3664: WHERE
3665: payee_party_id = p_payee_party_id AND
3666: payment_function = p_pmt_function AND
3667: NVL(party_site_id, '0') = NVL(l_payee_party_site_id, '0') AND

Line 3745: IBY_EXTERNAL_PAYEES_ALL

3741: */
3742: SELECT
3743: ext_payee_id INTO l_payee_id
3744: FROM
3745: IBY_EXTERNAL_PAYEES_ALL
3746: WHERE
3747: payee_party_id = p_payee_party_id AND
3748: payment_function = p_pmt_function AND
3749: NVL(party_site_id, '0') = NVL(l_payee_party_site_id, '0') AND

Line 3831: IBY_EXTERNAL_PAYEES_ALL

3827:
3828: SELECT
3829: ext_payee_id INTO l_payee_id
3830: FROM
3831: IBY_EXTERNAL_PAYEES_ALL
3832: WHERE
3833: payee_party_id = p_payee_party_id AND
3834: payment_function = p_pmt_function AND
3835: party_site_id IS NULL AND

Line 3951: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,

3947: | NOTES:
3948: |
3949: *---------------------------------------------------------------------*/
3950: FUNCTION deriveExactPayeeIdFromContext(
3951: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

Line 3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,

3948: |
3949: *---------------------------------------------------------------------*/
3950: FUNCTION deriveExactPayeeIdFromContext(
3951: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

Line 3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,

3949: *---------------------------------------------------------------------*/
3950: FUNCTION deriveExactPayeeIdFromContext(
3951: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3957: )

Line 3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,

3950: FUNCTION deriveExactPayeeIdFromContext(
3951: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3957: )
3958: RETURN NUMBER

Line 3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,

3951: p_payee_party_id IN IBY_EXTERNAL_PAYEES_ALL.payee_party_id%TYPE,
3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3957: )
3958: RETURN NUMBER
3959: IS

Line 3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE

3952: p_payee_party_site_id IN IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE,
3953: p_supplier_site_id IN IBY_EXTERNAL_PAYEES_ALL.supplier_site_id%TYPE,
3954: p_org_id IN IBY_EXTERNAL_PAYEES_ALL.org_id%TYPE,
3955: p_org_type IN IBY_EXTERNAL_PAYEES_ALL.org_type%TYPE,
3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3957: )
3958: RETURN NUMBER
3959: IS
3960: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

Line 3960: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

3956: p_pmt_function IN IBY_EXTERNAL_PAYEES_ALL.payment_function%TYPE
3957: )
3958: RETURN NUMBER
3959: IS
3960: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3961: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3962: '.deriveExactPayeeIdFromContext';
3963:
3964: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

Line 3964: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;

3960: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
3961: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
3962: '.deriveExactPayeeIdFromContext';
3963:
3964: l_payee_party_site_id IBY_EXTERNAL_PAYEES_ALL.party_site_id%TYPE;
3965:
3966: BEGIN
3967:
3968: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4035: IBY_EXTERNAL_PAYEES_ALL

4031: */
4032: SELECT
4033: ext_payee_id INTO l_payee_id
4034: FROM
4035: IBY_EXTERNAL_PAYEES_ALL
4036: WHERE
4037: payee_party_id = p_payee_party_id AND
4038: payment_function = p_pmt_function AND
4039: NVL(party_site_id, '0') = NVL(l_payee_party_site_id, '0') AND

Line 4197: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;

4193:
4194: l_lines_view_name VARCHAR2(200);
4195:
4196: /* payee conext generated internally based on supplied payee fields */
4197: l_payee_id IBY_EXTERNAL_PAYEES_ALL.ext_payee_id%TYPE;
4198:
4199: l_pmtFxAccessTypesTab distinctPmtFxAccessTab;
4200: l_orgAccessTypesTab distinctOrgAccessTab;
4201:

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

4586:
4587: --
4588: -- From the given payee context (payee party id, payee party site
4589: -- id, supplier site id, org id and org type) on the document,
4590: -- derive the payee id from the IBY_EXTERNAL_PAYEES_ALL table.
4591: --
4592: l_payee_id := derivePayeeIdFromContext(
4593: iby_disburse_submit_pub_pkg.docspayTab.payee_party_id(l_trx_line_index),
4594: iby_disburse_submit_pub_pkg.docspayTab.party_site_id(l_trx_line_index),