[Home] [Help]
178: AND o.object_type_code = t.object_type_code;
179:
180: SELECT COUNT(*)
181: INTO v_count
182: FROM fem_pl_object_defs
183: WHERE object_definition_id = p_object_definition_id;
184:
185: IF (p_object_definition_id < 10000) THEN
186: x_data_edit_lock_exists := 'T';
253: p_init_msg_list => p_init_msg_list);
254:
255: SELECT min(r.effective_date), max(r.effective_date)
256: INTO v_rslts_start_date, v_rslts_end_date
257: FROM fem_pl_requests r, fem_pl_object_defs d
258: WHERE r.request_id = d.request_id
259: AND d.object_definition_id = p_object_definition_id;
260:
261: IF p_new_effective_start_date > v_rslts_start_date OR
1237: -- Insert object execution data in FEM_PL_OBJECT_EXECUTIONS.
1238: -- IF object is a GL incremental load, RCM_PROCESS_RULE, or TP_PROCESS_RULE THEN
1239: -- Set FEM_PL_OBJECT_EXECUTIONS.DISPLAY_FLAG = N for previous executions.
1240: -- END IF;
1241: -- Register executed object definition in FEM_PL_OBJECT_DEFS.
1242: -- IF cannot register object definition, rollback and return an error status ELSE
1243: -- Issue a commit to release exclusive table lock. END IF;
1244: -- END IF;
1245: -- EXCEPTION
1959:
1960: -- Initialize API return status to success
1961: x_return_status := G_RET_STS_SUCCESS;
1962:
1963: INSERT INTO fem_pl_object_defs (request_id, object_id, object_definition_id,
1964: created_by, creation_date, last_updated_by, last_update_date,
1965: last_update_login)
1966: SELECT
1967: request_id, object_id, p_object_definition_id,