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 237: --FROM po_vendor_sites_all SITE, HR_OPERATING_UNITS ORG

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

Line 238: FROM ap_supplier_sites_all SITE, HR_OPERATING_UNITS ORG

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

Line 1555: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;

1551: p_int_key IN NUMBER,
1552: x_valid OUT NOCOPY BOOLEAN
1553: ) IS
1554:
1555: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
1556: l_org_name HR_OPERATING_UNITS.name%TYPE;
1557: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name';
1558: BEGIN
1559: x_valid := TRUE;

Line 1556: l_org_name HR_OPERATING_UNITS.name%TYPE;

1552: x_valid OUT NOCOPY BOOLEAN
1553: ) IS
1554:
1555: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
1556: l_org_name HR_OPERATING_UNITS.name%TYPE;
1557: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name';
1558: BEGIN
1559: x_valid := TRUE;
1560:

Line 1565: FROM HR_OPERATING_UNITS

1561: IF (p_org_id is NOT NULL and p_org_name is NOT NULL) THEN
1562: BEGIN
1563: SELECT organization_id
1564: INTO l_org_id
1565: FROM HR_OPERATING_UNITS
1566: WHERE organization_id = p_org_id
1567: AND name = p_org_name
1568: AND sysdate < nvl(date_to, sysdate + 1);
1569:

Line 1604: FROM HR_OPERATING_UNITS

1600:
1601: BEGIN
1602: SELECT organization_id
1603: INTO p_org_id
1604: FROM HR_OPERATING_UNITS
1605: WHERE name = p_org_name
1606: AND sysdate < nvl(date_to, sysdate + 1);
1607:
1608: EXCEPTION

Line 1642: FROM HR_OPERATING_UNITS

1638:
1639: BEGIN
1640: SELECT name
1641: INTO l_org_name
1642: FROM HR_OPERATING_UNITS
1643: WHERE organization_id = p_org_id
1644: AND sysdate < nvl(date_to, sysdate + 1);
1645:
1646: EXCEPTION

Line 1971: HR_OPERATING_UNITS HR

1967: l_future_pay_ccid,
1968: l_home_country_code,
1969: p_ship_via_lookup_code
1970: FROM FINANCIALS_SYSTEM_PARAMS_ALL FIN,
1971: HR_OPERATING_UNITS HR
1972: WHERE HR.organization_id = FIN.org_id
1973: AND ( HR.name = p_org_name OR
1974: HR.organization_id = p_org_id);
1975:

Line 2224: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2220: IF p_tolerance_type = 'QUANTITY' then
2221:
2222: SELECT ASP.tolerance_id
2223: INTO l_default_tolerance
2224: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2225: WHERE ASP.org_id = ORG.organization_id
2226: AND (ORG.organization_id = p_org_id OR
2227: ORG.name = p_org_name);
2228:

Line 2233: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG

2229: ELSE
2230:
2231: SELECT ASP.services_tolerance_id
2232: INTO l_default_tolerance
2233: FROM ap_system_parameters_all ASP, HR_OPERATING_UNITS ORG
2234: WHERE ASP.org_id = ORG.organization_id
2235: AND (ORG.organization_id = p_org_id OR
2236: ORG.name = p_org_name);
2237:

Line 2587: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;

2583: p_int_table IN VARCHAR2,
2584: p_int_key IN VARCHAR2,
2585: x_valid OUT NOCOPY BOOLEAN) IS
2586:
2587: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2588: l_org_name HR_OPERATING_UNITS.name%TYPE;
2589: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
2590: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name_Site_Code';
2591: BEGIN

Line 2588: l_org_name HR_OPERATING_UNITS.name%TYPE;

2584: p_int_key IN VARCHAR2,
2585: x_valid OUT NOCOPY BOOLEAN) IS
2586:
2587: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2588: l_org_name HR_OPERATING_UNITS.name%TYPE;
2589: l_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
2590: l_api_name CONSTANT VARCHAR2(30) := 'Check_Org_Id_Name_Site_Code';
2591: BEGIN
2592: x_valid := TRUE;

Line 2654: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG

2650:
2651: BEGIN
2652: SELECT SITE.vendor_site_code,vendor_site_id
2653: INTO l_vendor_site_code,p_vendor_site_id
2654: FROM PO_VENDOR_SITES_ALL SITE, HR_OPERATING_UNITS ORG
2655: WHERE ORG.name = p_org_name
2656: AND SITE.org_id = ORG.organization_id
2657: AND SITE.vendor_site_code = p_vendor_site_code;
2658:

Line 2722: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;

2718: p_int_table IN VARCHAR2,
2719: p_int_key IN VARCHAR2,
2720: x_valid OUT NOCOPY BOOLEAN) IS
2721:
2722: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2723: l_org_name HR_OPERATING_UNITS.name%TYPE;
2724: l_party_site_name hz_party_sites.party_site_name%TYPE;
2725: l_api_name CONSTANT VARCHAR2(30) := 'Check_org_id_party_site_name';
2726: BEGIN

Line 2723: l_org_name HR_OPERATING_UNITS.name%TYPE;

2719: p_int_key IN VARCHAR2,
2720: x_valid OUT NOCOPY BOOLEAN) IS
2721:
2722: l_org_id HR_OPERATING_UNITS.organization_id%TYPE;
2723: l_org_name HR_OPERATING_UNITS.name%TYPE;
2724: l_party_site_name hz_party_sites.party_site_name%TYPE;
2725: l_api_name CONSTANT VARCHAR2(30) := 'Check_org_id_party_site_name';
2726: BEGIN
2727: x_valid := TRUE;

Line 2771: HR_OPERATING_UNITS ORG

2767: BEGIN
2768: SELECT hzps.party_site_name, hzps.party_site_id
2769: INTO l_party_site_name,p_party_site_id
2770: FROM hz_party_sites hzps, ap_supplier_sites_all aps,
2771: HR_OPERATING_UNITS ORG
2772: WHERE ORG.name = p_org_name
2773: AND aps.org_id = ORG.organization_id
2774: AND hzps.party_site_name = p_party_site_name
2775: AND hzps.party_site_id = aps.party_site_id