APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_LOOKUPS

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

2215: END Is_Valid_System_Id;
2216:
2217: /*-----------------------------------------------------*/
2218: /* This function checks for the instance type code */
2219: /* by looking through the CSI lookups */
2220: /*-----------------------------------------------------*/
2221:
2222: FUNCTION Is_Valid_Instance_Type
2223: (

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

2229: l_dummy VARCHAR2(30);
2230: l_return_value BOOLEAN := TRUE;
2231: l_inst_lookup_type VARCHAR2(30) := 'CSI_INST_TYPE_CODE';
2232:
2233: -- Validate the Instance Type Code against CSI_LOOKUPS table .
2234: BEGIN
2235:
2236: IF ((p_instance_type_code IS NULL) OR
2237: (p_instance_type_code = FND_API.G_MISS_CHAR)) THEN

Line 2243: FROM csi_lookups

2239: ELSE
2240: BEGIN
2241: SELECT '1'
2242: INTO l_dummy
2243: FROM csi_lookups
2244: WHERE lookup_code = UPPER(p_instance_type_code)
2245: AND lookup_type = l_inst_lookup_type;
2246: l_return_value := TRUE;
2247:

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

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

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

2273: l_dummy VARCHAR2(30);
2274: l_return_value BOOLEAN := TRUE;
2275: l_usage_lookup_type VARCHAR2(30) := 'CSI_INSTANCE_USAGE_CODE';
2276:
2277: -- Validate the System ID against CSI_LOOKUPS table .
2278: BEGIN
2279:
2280: IF ((p_inst_usage_code IS NULL) OR
2281: (p_inst_usage_code = FND_API.G_MISS_CHAR)) THEN

Line 2287: FROM csi_lookups

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

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

2303: END Valid_Inst_Usage_Code;
2304:
2305: /*---------------------------------------------------------*/
2306: /* This function checks for the operational status code */
2307: /* by looking through the CSI lookups */
2308: /*---------------------------------------------------------*/
2309:
2310: FUNCTION Valid_operational_status
2311: (

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

2316: l_dummy VARCHAR2(30);
2317: l_return_value BOOLEAN := TRUE;
2318: l_operational_lookup_type VARCHAR2(30) := 'CSI_OPERATIONAL_STATUS_CODE';
2319:
2320: -- Validate the System ID against CSI_LOOKUPS table .
2321: BEGIN
2322: IF ((p_operational_status IS NULL) OR
2323: (p_operational_status = FND_API.G_MISS_CHAR))
2324: THEN

Line 2330: FROM csi_lookups

2326: ELSE
2327: BEGIN
2328: SELECT '1'
2329: INTO l_dummy
2330: FROM csi_lookups
2331: WHERE lookup_code = UPPER(p_operational_status)
2332: AND lookup_type = l_operational_lookup_type;
2333: l_return_value := TRUE;
2334:

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

2524: END validate_uniqueness;
2525:
2526: /*-----------------------------------------------------*/
2527: /* This function checks for the location type code */
2528: /* by looking through the CSI lookups */
2529: /*-----------------------------------------------------*/
2530:
2531:
2532: FUNCTION Is_Valid_Location_Source

Line 2552: FROM csi_lookups

2548: ELSE
2549: BEGIN
2550: SELECT '1'
2551: INTO l_dummy
2552: FROM csi_lookups
2553: WHERE lookup_code = UPPER(p_loc_source_table)
2554: AND lookup_type = l_loc_lookup_type;
2555:
2556: l_return_value:= TRUE;

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

4240: -- from HR_ALL_ORGANIZATION_UNITS upfront.
4241: --
4242: l_return_value := TRUE;
4243: --
4244: -- Validate the Location Type and check if exists in csi_lookups table with type
4245: -- CSI_INST_LOCATION_SOURCE_CODE. If not raise the CSI_API_INVALID_LOCATION_TYPE exception
4246: -- Added the following code for R12
4247: IF ((p_location_source_table IS NULL) OR (p_location_source_table = FND_API.G_MISS_CHAR) OR
4248: (p_location_id IS NULL) OR (p_location_id = FND_API.G_MISS_NUM) )

Line 4260: FROM csi_lookups

4256: -- Validate location type code
4257: BEGIN
4258: SELECT lookup_code
4259: INTO l_location_source_table
4260: FROM csi_lookups
4261: WHERE lookup_code = upper(p_location_source_table)
4262: AND lookup_type = l_location_lookup_type;
4263: l_return_value := TRUE;
4264: