DBA Data[Home] [Help]

APPS.FEM_ALLOC_BR_UTIL_PKG dependencies on FEM_VT_OBJ_DEF_ATTRIBS

Line 3126: FROM fem_vt_obj_def_attribs

3122: END;
3123:
3124:
3125: SELECT count(*) INTO v_row_count
3126: FROM fem_vt_obj_def_attribs
3127: WHERE object_definition_id = p_object_definition_id;
3128:
3129: IF v_row_count = 0 THEN
3130: INSERT INTO fem_vt_obj_def_attribs(object_definition_id,source_enabled_flg,

Line 3130: INSERT INTO fem_vt_obj_def_attribs(object_definition_id,source_enabled_flg,

3126: FROM fem_vt_obj_def_attribs
3127: WHERE object_definition_id = p_object_definition_id;
3128:
3129: IF v_row_count = 0 THEN
3130: INSERT INTO fem_vt_obj_def_attribs(object_definition_id,source_enabled_flg,
3131: driver_enabled_flg,trace_contribution_enabled_flg,
3132: created_by,creation_date,last_updated_by,
3133: last_update_date,last_update_login,object_version_number)
3134: VALUES (p_object_definition_id,v_src_flag,

Line 3139: UPDATE fem_vt_obj_def_attribs

3135: v_drv_flag,v_trace_contrib_flag,
3136: c_user_id,sysdate,c_user_id,sysdate,c_login_id,0);
3137: ELSE
3138:
3139: UPDATE fem_vt_obj_def_attribs
3140: SET source_enabled_flg = v_src_flag,driver_enabled_flg = v_drv_flag,
3141: trace_contribution_enabled_flg = v_trace_contrib_flag ,
3142: Last_update_date = sysdate,last_update_login =c_login_id,
3143: last_updated_by=c_user_id,object_version_number = (object_version_number+1)