[Home] [Help]
1246: v_ignore_dependency_errs_flag VARCHAR2(1);
1247: v_count NUMBER;
1248: v_exec_status_code VARCHAR2(30);
1249: v_obj_def_name FEM_OBJECT_DEFINITION_TL.display_name%TYPE;
1250: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
1251:
1252: -- This cursor retrieves the snapshot and all other incremental loads that make
1253: -- up a GL load.
1254: -- 10-AUG-04 KFN - The cursor also retrieves all RCM Process Rule executions
2132: v_output_dataset_code NUMBER;
2133: v_num_of_upd_dependents NUMBER;
2134: v_upd_dep_calc_id NUMBER;
2135: v_return_status VARCHAR2(30);
2136: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
2137:
2138: -- Cursor to retrieve an object execution's UPDATE dependents
2139: -- Note that this only applies to ACCOUNT tables.
2140: CURSOR c1 (v_upd_dep_calc_id IN NUMBER) IS
2346: v_undo_list_ever_exec VARCHAR2(1);
2347: v_num_of_upd_dependents NUMBER;
2348: v_upd_dep_calc_id NUMBER;
2349: v_exec_status_code VARCHAR2(30);
2350: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
2351:
2352: -- Cursor to retrieve an object execution's UPDATE dependents
2353: -- Note that this only applies to ACCOUNT tables.
2354: CURSOR c1 IS
6656: e_api_error EXCEPTION;
6657: e_objexec_running EXCEPTION;
6658: e_chain_exists EXCEPTION;
6659: v_object_type FEM_OBJECT_CATALOG_B.object_type_code%TYPE;
6660: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
6661: v_request_id FEM_PL_REQUESTS.request_id%TYPE;
6662: v_dep_req_id FEM_PL_REQUESTS.request_id%TYPE;
6663: v_dep_obj_id FEM_OBJECT_CATALOG_B.object_id%TYPE;
6664: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;
6982: --
6983: e_api_error EXCEPTION;
6984: e_objexec_running EXCEPTION;
6985: v_undo_flag FEM_OBJECT_TYPES_B.undo_flag%TYPE;
6986: v_object_name FEM_OBJECT_CATALOG_TL.object_name%TYPE;
6987: v_exec_status_code FEM_PL_REQUESTS.exec_status_code%TYPE;
6988: v_count NUMBER;
6989: --
6990: CURSOR c_object_name (p_object_id NUMBER) IS