APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_LOOKUPS

Line 2264: /* by looking through the CSI lookups */

2260: END Is_Valid_System_Id;
2261:
2262: /*-----------------------------------------------------*/
2263: /* This function checks for the instance type code */
2264: /* by looking through the CSI lookups */
2265: /*-----------------------------------------------------*/
2266:
2267: FUNCTION Is_Valid_Instance_Type
2268: (

Line 2278: -- Validate the Instance Type Code against CSI_LOOKUPS table .

2274: l_dummy VARCHAR2(30);
2275: l_return_value BOOLEAN := TRUE;
2276: l_inst_lookup_type VARCHAR2(30) := 'CSI_INST_TYPE_CODE';
2277:
2278: -- Validate the Instance Type Code against CSI_LOOKUPS table .
2279: BEGIN
2280:
2281: IF ((p_instance_type_code IS NULL) OR
2282: (p_instance_type_code = FND_API.G_MISS_CHAR)) THEN

Line 2288: FROM csi_lookups

2284: ELSE
2285: BEGIN
2286: SELECT '1'
2287: INTO l_dummy
2288: FROM csi_lookups
2289: WHERE lookup_code = UPPER(p_instance_type_code)
2290: AND lookup_type = l_inst_lookup_type;
2291: l_return_value := TRUE;
2292:

Line 2308: /* by looking through the CSI lookups */

2304: END Is_Valid_Instance_Type;
2305:
2306: /*-----------------------------------------------------*/
2307: /* This function checks for the instance usage code */
2308: /* by looking through the CSI lookups */
2309: /*-----------------------------------------------------*/
2310:
2311: FUNCTION Valid_Inst_Usage_Code
2312: (

Line 2322: -- Validate the System ID against CSI_LOOKUPS table .

2318: l_dummy VARCHAR2(30);
2319: l_return_value BOOLEAN := TRUE;
2320: l_usage_lookup_type VARCHAR2(30) := 'CSI_INSTANCE_USAGE_CODE';
2321:
2322: -- Validate the System ID against CSI_LOOKUPS table .
2323: BEGIN
2324:
2325: IF ((p_inst_usage_code IS NULL) OR
2326: (p_inst_usage_code = FND_API.G_MISS_CHAR)) THEN

Line 2332: FROM csi_lookups

2328: ELSE
2329: BEGIN
2330: SELECT '1'
2331: INTO l_dummy
2332: FROM csi_lookups
2333: WHERE lookup_code = UPPER(p_inst_usage_code)
2334: AND lookup_type = l_usage_lookup_type;
2335: l_return_value := TRUE;
2336:

Line 2352: /* by looking through the CSI lookups */

2348: END Valid_Inst_Usage_Code;
2349:
2350: /*---------------------------------------------------------*/
2351: /* This function checks for the operational status code */
2352: /* by looking through the CSI lookups */
2353: /*---------------------------------------------------------*/
2354:
2355: FUNCTION Valid_operational_status
2356: (

Line 2365: -- Validate the System ID against CSI_LOOKUPS table .

2361: l_dummy VARCHAR2(30);
2362: l_return_value BOOLEAN := TRUE;
2363: l_operational_lookup_type VARCHAR2(30) := 'CSI_OPERATIONAL_STATUS_CODE';
2364:
2365: -- Validate the System ID against CSI_LOOKUPS table .
2366: BEGIN
2367: IF ((p_operational_status IS NULL) OR
2368: (p_operational_status = FND_API.G_MISS_CHAR))
2369: THEN

Line 2375: FROM csi_lookups

2371: ELSE
2372: BEGIN
2373: SELECT '1'
2374: INTO l_dummy
2375: FROM csi_lookups
2376: WHERE lookup_code = UPPER(p_operational_status)
2377: AND lookup_type = l_operational_lookup_type;
2378: l_return_value := TRUE;
2379:

Line 2580: /* by looking through the CSI lookups */

2576: END validate_uniqueness;
2577:
2578: /*-----------------------------------------------------*/
2579: /* This function checks for the location type code */
2580: /* by looking through the CSI lookups */
2581: /*-----------------------------------------------------*/
2582:
2583:
2584: FUNCTION Is_Valid_Location_Source

Line 2604: FROM csi_lookups

2600: ELSE
2601: BEGIN
2602: SELECT '1'
2603: INTO l_dummy
2604: FROM csi_lookups
2605: WHERE lookup_code = UPPER(p_loc_source_table)
2606: AND lookup_type = l_loc_lookup_type;
2607:
2608: l_return_value:= TRUE;

Line 4330: -- Validate the Location Type and check if exists in csi_lookups table with type

4326: -- from HR_ALL_ORGANIZATION_UNITS upfront.
4327: --
4328: l_return_value := TRUE;
4329: --
4330: -- Validate the Location Type and check if exists in csi_lookups table with type
4331: -- CSI_INST_LOCATION_SOURCE_CODE. If not raise the CSI_API_INVALID_LOCATION_TYPE exception
4332: -- Added the following code for R12
4333: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR
4334: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )

Line 4346: FROM csi_lookups

4342: -- Validate location type code
4343: BEGIN
4344: SELECT lookup_code
4345: INTO l_location_source_table
4346: FROM csi_lookups
4347: WHERE lookup_code = upper(p_location_source_table)
4348: AND lookup_type = l_location_lookup_type;
4349: l_return_value := TRUE;
4350: