206:
207: /*-----------------------------------------------------------*/
208: /* Procedure name: Is_Update_Status_Exists */
209: /* Description : Check if the update status is */
210: /* defined in CSI_LOOKUPS */
211: /*-----------------------------------------------------------*/
212:
213: FUNCTION Is_Update_Status_Exists
214: (
221: l_asset_lookup_type VARCHAR2(30) := 'CSI_ASSET_UPDATE_STATUS_CODE';
222:
223: CURSOR c1 IS
224: SELECT 'x'
225: FROM CSI_LOOKUPS
226: WHERE UPPER(lookup_code) = UPPER(p_update_status)
227: AND lookup_type = l_asset_lookup_type;
228: BEGIN
229: OPEN c1;