APPS.FEM_ADMIN_UTIL_PKG dependencies on FEM_MP_PROCESS_OPTIONS

Line 174: -- * Multiprocessing options for the new rule (FEM_MP_PROCESS_OPTIONS)

170: -- for a table to be supported by the Detail Client Data Loader program.
171: -- This metadata consists of:
172: -- * Rule and rule definintion for the table (FEM_OBJECT_CATALOG_VL,
173: -- FEM_OBJECT_DEFINITION_VL)
174: -- * Multiprocessing options for the new rule (FEM_MP_PROCESS_OPTIONS)
175: -- * Link between the new rule and client data table (FEM_DATA_LOADER_OBJECTS)
176:
177: -- This procedure enables user-defined tables that qualify as a
178: -- clieant data loader table to be supported by the loader.

Line 274: INSERT INTO fem_mp_process_options (

270: p_msg_text => 'New loader object id = '||v_obj_id
271: ||' , object def id = '||v_obj_def_id);
272: END IF;
273:
274: INSERT INTO fem_mp_process_options (
275: OBJECT_TYPE_CODE,
276: STEP_NAME,
277: OBJECT_ID,
278: DATA_SLICE_TYPE_CODE,

Line 1510: FROM fem_mp_process_options

1506:
1507: -- Select all multiprocessing option assignments specific to the given Object ID.
1508: CURSOR c1 (cp_object_id IN NUMBER) IS
1509: SELECT process_data_slices_cd
1510: FROM fem_mp_process_options
1511: WHERE object_id = cp_object_id
1512: FOR UPDATE;
1513:
1514: BEGIN

Line 1556: DELETE FROM fem_mp_process_options

1552: FOR process_option IN c1 (p_object_id) LOOP
1553:
1554: v_process_ds_cd := process_option.process_data_slices_cd;
1555:
1556: DELETE FROM fem_mp_process_options
1557: WHERE CURRENT OF c1;
1558:
1559: DELETE FROM fem_mp_data_slices
1560: WHERE process_data_slices_cd = v_process_ds_cd

Line 1563: FROM fem_mp_process_options

1559: DELETE FROM fem_mp_data_slices
1560: WHERE process_data_slices_cd = v_process_ds_cd
1561: AND NOT EXISTS
1562: (SELECT NULL
1563: FROM fem_mp_process_options
1564: WHERE process_data_slices_cd = v_process_ds_cd);
1565:
1566: DELETE FROM fem_mp_data_slice_cols
1567: WHERE process_data_slices_cd = v_process_ds_cd

Line 1570: FROM fem_mp_process_options

1566: DELETE FROM fem_mp_data_slice_cols
1567: WHERE process_data_slices_cd = v_process_ds_cd
1568: AND NOT EXISTS
1569: (SELECT NULL
1570: FROM fem_mp_process_options
1571: WHERE process_data_slices_cd = v_process_ds_cd);
1572:
1573: END LOOP;
1574: