APPS.ICX_POR_EXT_DIAG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 10: gInventoryOrgName hr_all_organization_units.name%TYPE;

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;
13: gValidateFlag VARCHAR2(1);
14: gStructureId NUMBER;

Line 54: FROM hr_all_organization_units

50: SELECT organization_id,
51: name
52: INTO gInventoryOrgId,
53: gInventoryOrgName
54: FROM hr_all_organization_units
55: WHERE organization_id = pInventoryOrgId;
56: END IF;
57: RETURN gInventoryOrgName;
58: EXCEPTION

Line 342: xInventoryOrg hr_all_organization_units.name%TYPE;

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,
346: ICX_POR_EXT_ITEM.CONTRACT_TYPE,

Line 839: xOrgName hr_all_organization_units.name%TYPE;

835: xErrLoc PLS_INTEGER := 100;
836: xStatus PLS_INTEGER := VALID_FOR_EXTRACT;
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

Line 874: hr_all_organization_units hr

870: po_vendors pv,
871: financials_system_params_all fsp,
872: mtl_system_items_kfv mi,
873: mtl_item_categories mic,
874: hr_all_organization_units hr
875: WHERE pasl.asl_id = pASLId
876: AND (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
877: AND fsp.inventory_organization_id = pasl.owning_organization_id
878: AND pasl.vendor_id = pv.vendor_id

Line 930: xOrgName hr_all_organization_units.name%TYPE;

926: xStatus1 PLS_INTEGER;
927: xStatus2 PLS_INTEGER;
928: xItemId NUMBER;
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:

Line 964: hr_all_organization_units hr

960: xOrgName
961: FROM financials_system_params_all fsp,
962: mtl_system_items_kfv mi,
963: mtl_item_categories mic,
964: hr_all_organization_units hr
965: WHERE (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
966: AND fsp.inventory_organization_id = mi.organization_id
967: AND mi.concatenated_segments = pItemNum
968: AND mic.category_set_id = gCategorySetId