APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on HR_LOCATIONS_ALL_TL

Line 1110: FROM HR_LOCATIONS_ALL_TL

1106: l_progress := '020';
1107: BEGIN
1108: SELECT location_code
1109: INTO x_location_name
1110: FROM HR_LOCATIONS_ALL_TL
1111: WHERE location_id = p_location_id
1112: AND language = userenv('LANG');
1113: EXCEPTION
1114: WHEN OTHERS THEN

Line 1116: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from HR_LOCATIONS_ALL_TL: '||SQLERRM); END IF;

1112: AND language = userenv('LANG');
1113: EXCEPTION
1114: WHEN OTHERS THEN
1115: l_progress := '030';
1116: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from HR_LOCATIONS_ALL_TL: '||SQLERRM); END IF;
1117:
1118: x_location_name := p_location_id;
1119: END;
1120: -- ECO bug 5584556: End

Line 1176: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;

1172: l_index NUMBER;
1173: i NUMBER;
1174: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1175:
1176: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;
1177: BEGIN
1178: l_progress := '010';
1179: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1180:

Line 1374: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;

1370: l_index NUMBER;
1371: i NUMBER;
1372: l_subscript_array PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
1373:
1374: l_location_name HR_LOCATIONS_ALL_TL.location_code%TYPE;
1375: BEGIN
1376: l_progress := '010';
1377: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;
1378: