APPS.FEM_UD_PKG dependencies on FEM_PL_TAB_UPDATED_COLS

Line 720: DELETE fem_pl_tab_updated_cols

716: DELETE fem_pl_obj_exec_steps
717: WHERE request_id = p_request_id
718: AND object_id = p_object_id;
719:
720: DELETE fem_pl_tab_updated_cols
721: WHERE request_id = p_request_id
722: AND object_id = p_object_id;
723:
724: DELETE fem_pl_tables

Line 1942: FROM fem_pl_tab_updated_cols c

1938: -- Retrieve initial list of updated account table columns. The query
1939: -- retrieves all account table columns updated by the candidate.
1940: INSERT INTO fem_ud_upd_cols_t (upd_dep_calc_id, table_name, column_name, checked_flag)
1941: SELECT DISTINCT x_upd_dep_calc_id, c.table_name, c.column_name, 'N'
1942: FROM fem_pl_tab_updated_cols c
1943: WHERE request_id = p_request_id
1944: AND object_id = p_object_id
1945: AND c.table_name IN (
1946: SELECT t.table_name

Line 1973: FROM fem_pl_tab_updated_cols c

1969: -- In this query, we only want to find update dependencies for columns
1970: -- that have not been checked yet.
1971: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)
1972: SELECT DISTINCT x_upd_dep_calc_id, c.request_id, c.object_id
1973: FROM fem_pl_tab_updated_cols c
1974: WHERE c.request_id IN (
1975: SELECT r.request_id
1976: FROM fem_pl_requests r
1977: WHERE r.ledger_id = v_ledger_id

Line 2036: FROM fem_pl_tab_updated_cols c

2032: -- already been captured by fem_ud_upd_cols_t).
2033: IF v_new_dependents THEN
2034: INSERT INTO fem_ud_upd_cols_t (upd_dep_calc_id, table_name, column_name, checked_flag)
2035: SELECT DISTINCT x_upd_dep_calc_id, c.table_name, c.column_name, 'N'
2036: FROM fem_pl_tab_updated_cols c
2037: WHERE (c.request_id, c.object_id) IN (
2038: SELECT d.dependent_request_id, d.dependent_object_id
2039: FROM fem_ud_upd_dep_t d
2040: WHERE d.upd_dep_calc_id = x_upd_dep_calc_id)

Line 3450: v_col_name FEM_PL_TAB_UPDATED_COLS.column_name%TYPE;

3446: v_msg_data VARCHAR2(32000);
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

Line 3477: FROM fem_pl_tab_updated_cols

3473: ORDER BY table_name, statement_type;
3474:
3475: CURSOR c2 (v_table_name IN VARCHAR2, v_statement_type IN VARCHAR2) IS
3476: SELECT column_name AS colname
3477: FROM fem_pl_tab_updated_cols
3478: WHERE request_id = p_request_id
3479: AND object_id = p_object_id
3480: AND table_name = v_table_name
3481: AND statement_type = v_statement_type