DBA Data[Home] [Help]

APPS.ICX_POR_EXT_DIAG dependencies on HR_OPERATING_UNITS

Line 8: gOperatingUnitName hr_operating_units.name%TYPE;

4: --------------------------------------------------------------
5: -- Global Variables --
6: --------------------------------------------------------------
7: gOperatingUnitId NUMBER := -999;
8: gOperatingUnitName hr_operating_units.name%TYPE;
9: gInventoryOrgId NUMBER := -999;
10: gInventoryOrgName hr_all_organization_units.name%TYPE;
11:
12: gCategorySetId NUMBER;

Line 30: FROM hr_operating_units

26: SELECT organization_id,
27: name
28: INTO gOperatingUnitId,
29: gOperatingUnitName
30: FROM hr_operating_units
31: WHERE organization_id = pOperatingUnitId;
32: END IF;
33: RETURN gOperatingUnitName;
34: EXCEPTION

Line 341: xOperatingUnit hr_operating_units.name%TYPE;

337: p_supplier_part_num IN VARCHAR2)
338: RETURN VARCHAR2
339: IS
340: xReport VARCHAR2(4000) := '';
341: xOperatingUnit hr_operating_units.name%TYPE;
342: xInventoryOrg hr_all_organization_units.name%TYPE;
343: xItemNum VARCHAR2(2000);
344: BEGIN
345: IF p_document_type IN (ICX_POR_EXT_ITEM.TEMPLATE_TYPE,

Line 664: xOperatingUnit hr_operating_units.name%TYPE;

660: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
661: xContractLineId NUMBER;
662: xItemNum VARCHAR2(700);
663: xCategoryId NUMBER;
664: xOperatingUnit hr_operating_units.name%TYPE;
665:
666: BEGIN
667: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
668: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 751: xOperatingUnit hr_operating_units.name%TYPE;

747: xErrLoc PLS_INTEGER := 100;
748: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
749: xItemNum VARCHAR2(700);
750: xCategoryId NUMBER;
751: xOperatingUnit hr_operating_units.name%TYPE;
752:
753: BEGIN
754: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
755: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 841: xOperatingUnit hr_operating_units.name%TYPE;

837: xSupplier po_vendors.vendor_name%TYPE;
838: xItemNum VARCHAR2(700);
839: xOrgName hr_all_organization_units.name%TYPE;
840: xCategoryId NUMBER;
841: xOperatingUnit hr_operating_units.name%TYPE;
842:
843: BEGIN
844: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
845: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 933: xOperatingUnit hr_operating_units.name%TYPE;

929: xCategoryId NUMBER;
930: xOrgName hr_all_organization_units.name%TYPE;
931: xLoadPurchasing VARCHAR2(1);
932: xLoadInternal VARCHAR2(1);
933: xOperatingUnit hr_operating_units.name%TYPE;
934:
935: BEGIN
936: IF ICX_POR_EXT_UTL.gDebugLevel >= ICX_POR_EXT_UTL.DEBUG_LEVEL THEN
937: ICX_POR_EXT_UTL.debug(ICX_POR_EXT_UTL.DEBUG_LEVEL,

Line 1242: FROM hr_operating_units

1238: -- Check operating unit
1239: BEGIN
1240: SELECT organization_id
1241: INTO xOperatingUnitId
1242: FROM hr_operating_units
1243: WHERE business_group_id = xBusinessGroupId
1244: AND name = pOperatingUnit;
1245: EXCEPTION
1246: WHEN OTHERS THEN