APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_INSTANCE_STATUSES

Line 124: FROM csi_instance_statuses

120: IF p_instance_status_id IS NOT NULL
121: THEN
122: SELECT terminated_flag -- service_order_allowed_flag Bug # 3945813 srramakr
123: INTO l_flag
124: FROM csi_instance_statuses
125: WHERE instance_status_id = p_instance_status_id;
126: -- IF upper(l_flag)='N' -- check for N while selecting service_order_allowed_flag
127: IF upper(l_flag)='Y' -- check for Y while selecting terminated_flag
128: THEN

Line 2055: -- Verify the Instance Status is valid (CSI_INSTANCE_STATUSES) . If not

2051: IS
2052: l_dummy VARCHAR2(30);
2053: l_stack_err_msg BOOLEAN DEFAULT TRUE;
2054:
2055: -- Verify the Instance Status is valid (CSI_INSTANCE_STATUSES) . If not
2056: -- raise the CSI_API_INVALID_INST_STATUS exception.
2057: BEGIN
2058:
2059: IF ((p_instance_status_id IS NULL) OR

Line 2076: FROM csi_instance_statuses

2072: ELSE
2073: BEGIN
2074: SELECT '1'
2075: INTO l_dummy
2076: FROM csi_instance_statuses
2077: WHERE instance_status_id = p_instance_status_id;
2078:
2079: l_return_value := TRUE;
2080: EXCEPTION

Line 2385: /* by looking through the csi_instance_statuses */

2381: END Valid_currency_code;
2382:
2383: /*---------------------------------------------------------*/
2384: /* This function checks if status is updateable */
2385: /* by looking through the csi_instance_statuses */
2386: /*---------------------------------------------------------*/
2387: FUNCTION is_status_updateable
2388: (
2389: p_instance_status IN NUMBER,

Line 2400: FROM csi_instance_statuses

2396: BEGIN
2397: BEGIN
2398: SELECT status_change_allowed_flag
2399: INTO l_change_allowed
2400: FROM csi_instance_statuses
2401: WHERE instance_status_id = p_current_status;
2402: IF NVL(l_change_allowed,'Y')='Y'
2403: THEN
2404: l_return_value := TRUE;

Line 4053: FROM csi_instance_statuses

4049: BEGIN
4050:
4051: SELECT '1'
4052: INTO l_dummy
4053: FROM csi_instance_statuses
4054: WHERE instance_status_id = p_status_id
4055: AND terminated_flag = 'Y';
4056: RETURN TRUE;
4057: