[Home] [Help]
271: v_ledger_id NUMBER;
272: v_output_dataset_code NUMBER;
273: v_object_execution_date DATE;
274: v_source_system_code NUMBER;
275: v_object_name FEM_OBJECT_CATALOG_VL.object_name%TYPE;
276: v_cal_period_name FEM_CAL_PERIODS_VL.cal_period_name%TYPE;
277: v_calendar_display_code FEM_CALENDARS_VL.calendar_display_code%TYPE;
278: v_calendar_name FEM_CALENDARS_VL.calendar_name%TYPE;
279: v_dataset_display_code FEM_DATASETS_VL.dataset_display_code%TYPE;
360: -- Retrieve Object Name
361: BEGIN
362: SELECT object_name
363: INTO v_object_name
364: FROM fem_object_catalog_vl
365: WHERE object_id = p_object_id;
366: EXCEPTION WHEN NO_DATA_FOUND THEN
367: v_object_name := 'OBJECT_ID:'||p_object_id;
368: END;
1538:
1539: BEGIN
1540: SELECT object_name
1541: INTO v_object_name
1542: FROM fem_object_catalog_vl
1543: WHERE object_id = p_object_id;
1544: EXCEPTION
1545: WHEN others THEN
1546: v_object_name := to_char(p_object_id);
2226: WHEN e_cannot_gen_cand_upd_dep THEN
2227: BEGIN
2228: SELECT object_name
2229: INTO v_object_name
2230: FROM fem_object_catalog_vl
2231: WHERE object_id = p_object_id;
2232: EXCEPTION
2233: WHEN others THEN
2234: v_object_name := to_char(p_object_id);
2587:
2588: BEGIN
2589: SELECT object_name
2590: INTO v_object_name
2591: FROM fem_object_catalog_vl
2592: WHERE object_id = p_object_id;
2593: EXCEPTION
2594: WHEN others THEN
2595: v_object_name := to_char(p_object_id);
3447: v_tab_name FEM_PL_TABLES.table_name%TYPE;
3448: v_tab_class FEM_TABLE_CLASS_ASSIGNMT.table_classification_code%TYPE;
3449: v_stmt_type FEM_PL_TABLES.statement_type%TYPE;
3450: v_col_name FEM_PL_TAB_UPDATED_COLS.column_name%TYPE;
3451: v_object_name FEM_OBJECT_CATALOG_VL.object_name%TYPE;
3452:
3453: -- Returns a distinct list of tables and undo actions
3454: CURSOR c1 IS
3455: SELECT distinct p.statement_type, p.table_name,
3526: -- Get rule name
3527: BEGIN
3528: SELECT object_name
3529: INTO v_object_name
3530: FROM fem_object_catalog_vl
3531: WHERE object_id = p_object_id;
3532: EXCEPTION
3533: WHEN others THEN
3534: v_object_name := to_char(p_object_id);
5392: BEGIN
5393:
5394: SELECT o.object_id, d.object_definition_id, o.object_name
5395: INTO v_undo_list_obj_id, v_undo_list_obj_def_id, pv_undo_object_name
5396: FROM fem_object_catalog_vl o, fem_object_definition_b d
5397: WHERE o.object_type_code = 'UNDO'
5398: AND o.object_id = d.object_id
5399: AND o.object_name = 'UNDO - REQUEST_ID: '||p_request_id||' OBJECT_ID: '||p_object_id;
5400: v_undo_list_exists := 'T';
5813: BEGIN
5814:
5815: SELECT o.object_id, d.object_definition_id, o.object_name
5816: INTO v_undo_list_obj_id, v_undo_list_obj_def_id, pv_undo_object_name
5817: FROM fem_object_catalog_vl o, fem_object_definition_b d
5818: WHERE o.object_type_code = 'UNDO'
5819: AND o.object_id = d.object_id
5820: AND o.object_name = 'UNDO - REQUEST_ID: '||p_request_id;
5821: v_undo_list_exists := 'T';
6222: BEGIN
6223:
6224: SELECT o.object_id, d.object_definition_id
6225: INTO v_undo_list_obj_id, v_undo_list_obj_def_id
6226: FROM fem_object_catalog_vl o, fem_object_definition_b d
6227: WHERE o.object_type_code = 'UNDO'
6228: AND o.object_id = d.object_id
6229: AND o.object_name = p_undo_list_name;
6230: v_undo_list_exists := 'T';
6681: AND R.output_dataset_code = p_dataset_code;
6682:
6683: CURSOR c_object_name (p_object_id NUMBER) IS
6684: SELECT object_name
6685: FROM fem_object_catalog_vl
6686: WHERE object_id = p_object_id;
6687: --
6688: BEGIN
6689: --
6988: v_count NUMBER;
6989: --
6990: CURSOR c_object_name (p_object_id NUMBER) IS
6991: SELECT object_name
6992: FROM fem_object_catalog_vl
6993: WHERE object_id = p_object_id;
6994: --
6995: BEGIN
6996: --
7258: dataset_code) bal,
7259: fem_pl_object_executions exe,
7260: fem_pl_requests requests,
7261: fem_pl_tables tab,
7262: fem_object_catalog_vl obj
7263: where bal.created_by_object_id = obj.object_id
7264: and obj.object_type_code = 'MAPPING_RULE'
7265: and exe.object_id(+) = bal.created_by_object_id
7266: and exe.request_id(+) = bal.created_by_request_id