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.AP_VENDOR_PUB_PKG dependencies on HR_OPERATING_UNITS

Line 240: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG

236: ELSIF (x_org_id is NULL and x_org_name is NOT NULL) THEN
237: SELECT count(*)
238: INTO l_dup_count_org_name
239: -- bug 7430783 Changing validation table to ap_supplier_sites_all
240: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG
241: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
242: WHERE SITE.vendor_id = x_vendor_id
243: AND ORG.name = x_org_name
244: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)

Line 241: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG

237: SELECT count(*)
238: INTO l_dup_count_org_name
239: -- bug 7430783 Changing validation table to ap_supplier_sites_all
240: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG
241: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
242: WHERE SITE.vendor_id = x_vendor_id
243: AND ORG.name = x_org_name
244: AND UPPER(vendor_site_code) = UPPER(x_vendor_site_code)
245: AND SITE.org_id = ORG.organization_id;

Line 323: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG

319: ELSIF (x_org_id is NULL and x_org_name is NOT NULL) THEN
320:
321: SELECT count(*)
322: INTO l_dup_count_org_name
323: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG
324: WHERE SITE.vendor_id = x_vendor_id
325: AND ORG.name = x_org_name
326: AND SITE.org_id = ORG.organization_id
327: AND ((x_vendor_site_ID is not null and SITE.vendor_site_ID <> x_vendor_site_ID) OR

Line 1823: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;

1819: p_int_key IN NUMBER,
1820: x_valid OUT NOCOPY BOOLEAN
1821: ) IS
1822:
1823: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
1824: l_org_name HR_OPERATING_UNITS.name%TYPE;
1825: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name';
1826: BEGIN
1827: x_valid := TRUE;

Line 1824: l_org_name HR_OPERATING_UNITS.name%TYPE;

1820: x_valid OUT NOCOPY BOOLEAN
1821: ) IS
1822:
1823: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
1824: l_org_name HR_OPERATING_UNITS.name%TYPE;
1825: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name';
1826: BEGIN
1827: x_valid := TRUE;
1828:

Line 1833: FROM HR_OPERATING_UNITS

1829: IF (p_org_id is NOT NULL and p_org_name is NOT NULL) THEN
1830: BEGIN
1831: SELECT organization_id
1832: INTO l_org_id
1833: FROM HR_OPERATING_UNITS
1834: WHERE organization_id = p_org_id
1835: AND name = p_org_name
1836: AND sysdate < nvl(date_to, sysdate + 1);
1837:

Line 1872: FROM HR_OPERATING_UNITS

1868:
1869: BEGIN
1870: SELECT organization_id
1871: INTO p_org_id
1872: FROM HR_OPERATING_UNITS
1873: WHERE name = p_org_name
1874: AND sysdate < nvl(date_to, sysdate + 1);
1875:
1876: EXCEPTION

Line 1910: FROM HR_OPERATING_UNITS

1906:
1907: BEGIN
1908: SELECT name
1909: INTO l_org_name
1910: FROM HR_OPERATING_UNITS
1911: WHERE organization_id = p_org_id
1912: AND sysdate < nvl(date_to, sysdate + 1);
1913:
1914: EXCEPTION

Line 2256: HR_OPERATING_UNITS HR

2252: l_future_pay_ccid,
2253: l_home_country_code,
2254: p_ship_via_lookup_code
2255: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
2256: HR_OPERATING_UNITS HR
2257: WHERE HR.organization_id = FIN.org_id
2258: AND ( HR.name = p_org_name OR
2259: HR.organization_id = p_org_id);
2260:

Line 2535: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2531: IF p_tolerance_type = 'QUANTITY' then
2532:
2533: SELECT ASP.tolerance_id
2534: INTO l_default_tolerance
2535: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2536: WHERE ASP.org_id = ORG.organization_id
2537: AND (ORG.organization_id = p_org_id OR
2538: ORG.name = p_org_name);
2539:

Line 2544: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2540: ELSE
2541:
2542: SELECT ASP.services_tolerance_id
2543: INTO l_default_tolerance
2544: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2545: WHERE ASP.org_id = ORG.organization_id
2546: AND (ORG.organization_id = p_org_id OR
2547: ORG.name = p_org_name);
2548:

Line 2901: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;

2897: p_int_table IN VARCHAR2,
2898: p_int_key IN VARCHAR2,
2899: x_valid OUT NOCOPY BOOLEAN) IS
2900:
2901: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2902: l_org_name HR_OPERATING_UNITS.name%TYPE;
2903: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
2904: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name_Site_Code';
2905: l_match_count NUMBER;

Line 2902: l_org_name HR_OPERATING_UNITS.name%TYPE;

2898: p_int_key IN VARCHAR2,
2899: x_valid OUT NOCOPY BOOLEAN) IS
2900:
2901: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2902: l_org_name HR_OPERATING_UNITS.name%TYPE;
2903: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
2904: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name_Site_Code';
2905: l_match_count NUMBER;
2906: BEGIN

Line 3047: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG

3043:
3044: BEGIN
3045: SELECT SITE.vendor_site_code,vendor_site_id
3046: INTO l_vendor_site_code,p_vendor_site_id
3047: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG
3048: WHERE ORG.name = p_org_name
3049: AND SITE.org_id = ORG.organization_id
3050: AND SITE.vendor_site_code = p_vendor_site_code;
3051:

Line 3115: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;

3111: p_int_table IN VARCHAR2,
3112: p_int_key IN VARCHAR2,
3113: x_valid OUT NOCOPY BOOLEAN) IS
3114:
3115: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
3116: l_org_name HR_OPERATING_UNITS.name%TYPE;
3117: l_party_site_name hz_party_sites.party_site_name%TYPE;
3118: l_api_name CONSTANT VARCHAR2(30) := 'Check_org_id_party_site_name';
3119: l_match_sitename_cnt NUMBER;

Line 3116: l_org_name HR_OPERATING_UNITS.name%TYPE;

3112: p_int_key IN VARCHAR2,
3113: x_valid OUT NOCOPY BOOLEAN) IS
3114:
3115: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
3116: l_org_name HR_OPERATING_UNITS.name%TYPE;
3117: l_party_site_name hz_party_sites.party_site_name%TYPE;
3118: l_api_name CONSTANT VARCHAR2(30) := 'Check_org_id_party_site_name';
3119: l_match_sitename_cnt NUMBER;
3120: BEGIN

Line 3212: HR_OPERATING_UNITS ORG

3208: BEGIN
3209: SELECT hzps.party_site_name, hzps.party_site_id
3210: INTO l_party_site_name,p_party_site_id
3211: FROM hz_party_sites hzps, ap_supplier_sites_all aps,
3212: HR_OPERATING_UNITS ORG
3213: WHERE ORG.name = p_org_name
3214: AND aps.org_id = ORG.organization_id
3215: AND hzps.party_site_name = p_party_site_name
3216: AND hzps.party_site_id = aps.party_site_id