APPS.JTF_LOC_AREAS_PVT dependencies on JTF_LOC_AREAS_VL

Line 41: FROM JTF_LOC_AREAS_VL

37: FROM DUAL;
38:
39: CURSOR c_loc_area_count(loc_area_id IN NUMBER) IS
40: SELECT COUNT(*)
41: FROM JTF_LOC_AREAS_VL
42: WHERE location_area_id = loc_area_id;
43:
44: BEGIN
45: -- initialize

Line 1130: 'JTF_LOC_AREAS_VL',

1126: AND p_loc_area_rec.location_area_id IS NOT NULL
1127: THEN
1128: l_uk_flag := JTF_Utility_PVT.check_uniqueness
1129: (
1130: 'JTF_LOC_AREAS_VL',
1131: 'location_area_id = ' || p_loc_area_rec.location_area_id
1132: );
1133: END IF;
1134:

Line 1158: 'JTF_LOC_AREAS_VL',

1154:
1155: IF p_loc_area_rec.location_area_id IS NOT NULL THEN
1156: l_uk_flag := JTF_Utility_PVT.check_uniqueness
1157: (
1158: 'JTF_LOC_AREAS_VL',
1159: 'location_area_id <> ' || p_loc_area_rec.location_area_id
1160: || ' AND location_area_code = ''' || p_loc_area_rec.location_area_code || ''''
1161: || l_parent_loc_str
1162: );

Line 1166: 'JTF_LOC_AREAS_VL',

1162: );
1163: ELSE
1164: l_uk_flag := JTF_Utility_PVT.check_uniqueness
1165: (
1166: 'JTF_LOC_AREAS_VL',
1167: 'location_area_code = ''' || p_loc_area_rec.location_area_code || ''''
1168: || l_parent_loc_str
1169: );
1170: END IF;

Line 1252: 'JTF_LOC_AREAS_VL',

1248: AND p_loc_area_rec.parent_location_area_id <> FND_API.g_miss_num
1249: THEN
1250: l_fk_flag := JTF_Utility_PVT.check_fk_exists
1251: (
1252: 'JTF_LOC_AREAS_VL',
1253: 'location_area_id',
1254: p_loc_area_rec.parent_location_area_id
1255: );
1256:

Line 1328: SELECT * FROM JTF_LOC_AREAS_VL

1324: )
1325: IS
1326:
1327: CURSOR c_loc_area IS
1328: SELECT * FROM JTF_LOC_AREAS_VL
1329: WHERE location_area_id = p_loc_area_rec.location_area_id;
1330:
1331: l_loc_area_rec c_loc_area%ROWTYPE;
1332: