APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_INSTANCE_STATUSES

Line 125: FROM csi_instance_statuses

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

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

2096: IS
2097: l_dummy VARCHAR2(30);
2098: l_stack_err_msg BOOLEAN DEFAULT TRUE;
2099:
2100: -- Verify the Instance Status is valid (CSI_INSTANCE_STATUSES) . If not
2101: -- raise the CSI_API_INVALID_INST_STATUS exception.
2102: BEGIN
2103:
2104: IF ((p_instance_status_id IS NULL) OR

Line 2121: FROM csi_instance_statuses

2117: ELSE
2118: BEGIN
2119: SELECT '1'
2120: INTO l_dummy
2121: FROM csi_instance_statuses
2122: WHERE instance_status_id = p_instance_status_id;
2123:
2124: l_return_value := TRUE;
2125: EXCEPTION

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

2426: END Valid_currency_code;
2427:
2428: /*---------------------------------------------------------*/
2429: /* This function checks if status is updateable */
2430: /* by looking through the csi_instance_statuses */
2431: /*---------------------------------------------------------*/
2432: FUNCTION is_status_updateable
2433: (
2434: p_instance_status IN NUMBER,

Line 2445: FROM csi_instance_statuses

2441: BEGIN
2442: BEGIN
2443: SELECT status_change_allowed_flag
2444: INTO l_change_allowed
2445: FROM csi_instance_statuses
2446: WHERE instance_status_id = p_current_status;
2447: IF NVL(l_change_allowed,'Y')='Y'
2448: THEN
2449: l_return_value := TRUE;

Line 4137: FROM csi_instance_statuses

4133: BEGIN
4134:
4135: SELECT '1'
4136: INTO l_dummy
4137: FROM csi_instance_statuses
4138: WHERE instance_status_id = p_status_id
4139: AND terminated_flag = 'Y';
4140: RETURN TRUE;
4141: