eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FEM_UD_PKG dependencies on FEM_UD_UPD_DEP_T

Line 1910: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)

1906: FROM fem_pl_requests
1907: WHERE request_id = p_request_id;
1908:
1909: -- Retrieve initial list of type 2 dependents of the candidate.
1910: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)
1911: SELECT DISTINCT x_upd_dep_calc_id, t1.request_id, t1.object_id
1912: FROM fem_pl_tables t1
1913: WHERE t1.request_id IN (
1914: SELECT r.request_id

Line 1961: -- to fem_ud_upd_dep_t.

1957:
1958: LOOP
1959: -- Keep looping until no more columns are being added to
1960: -- fem_ud_upd_cols_t AND no more dependents are being added
1961: -- to fem_ud_upd_dep_t.
1962: IF (NOT v_new_columns) AND (NOT v_new_dependents) THEN
1963: EXIT;
1964: END IF;
1965:

Line 1971: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)

1967: -- Technical note: Columns that have previously been checked for
1968: -- dependencies will have fem_ud_upd_cols_t.checked_flag set to 'Y'.
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

Line 1987: FROM fem_ud_upd_dep_t

1983: WHERE upd_dep_calc_id = x_upd_dep_calc_id
1984: AND checked_flag = 'N')
1985: AND (c.request_id, c.object_id) NOT IN (
1986: SELECT dependent_request_id, dependent_object_id
1987: FROM fem_ud_upd_dep_t
1988: WHERE upd_dep_calc_id = x_upd_dep_calc_id);
1989:
1990: v_new_type1 := (SQL%ROWCOUNT > 0);
1991: v_num_dep_rows := v_num_dep_rows + SQL%ROWCOUNT;

Line 1999: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)

1995: WHERE upd_dep_calc_id = x_upd_dep_calc_id
1996: AND checked_flag = 'N';
1997:
1998: -- Find type 2 dependents.
1999: INSERT INTO fem_ud_upd_dep_t (upd_dep_calc_id, dependent_request_id, dependent_object_id)
2000: SELECT DISTINCT x_upd_dep_calc_id, t1.request_id, t1.object_id
2001: FROM fem_pl_tables t1
2002: WHERE t1.request_id IN (
2003: SELECT r.request_id

Line 2018: FROM fem_ud_upd_dep_t

2014: 'FTP_NON_CASH_FLOW','FTP_OPTION_COST')
2015: AND t2.statement_type = 'INSERT'
2016: AND (t2.request_id, t2.object_id) IN (
2017: SELECT dependent_request_id, dependent_object_id
2018: FROM fem_ud_upd_dep_t
2019: WHERE upd_dep_calc_id = x_upd_dep_calc_id))
2020: AND t1.statement_type = 'UPDATE'
2021: AND (t1.request_id, t1.object_id) NOT IN (
2022: SELECT dependent_request_id, dependent_object_id

Line 2023: FROM fem_ud_upd_dep_t

2019: WHERE upd_dep_calc_id = x_upd_dep_calc_id))
2020: AND t1.statement_type = 'UPDATE'
2021: AND (t1.request_id, t1.object_id) NOT IN (
2022: SELECT dependent_request_id, dependent_object_id
2023: FROM fem_ud_upd_dep_t
2024: WHERE upd_dep_calc_id = x_upd_dep_calc_id);
2025:
2026: v_new_type2 := (SQL%ROWCOUNT > 0);
2027: v_new_dependents := (v_new_type1 OR v_new_type2);

Line 2039: FROM fem_ud_upd_dep_t d

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)
2041: AND c.table_name IN (
2042: SELECT t.table_name
2043: FROM fem_table_class_assignmt_v t

Line 2142: FROM fem_ud_upd_dep_t c

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
2141: SELECT c.upd_dep_calc_id, c.dependent_request_id, c.dependent_object_id
2142: FROM fem_ud_upd_dep_t c
2143: WHERE c.upd_dep_calc_id = v_upd_dep_calc_id
2144: AND NOT (c.dependent_request_id = p_request_id
2145: AND c.dependent_object_id = p_object_id);
2146:

Line 2221: DELETE fem_ud_upd_dep_t WHERE upd_dep_calc_id = v_upd_dep_calc_id;

2217: p_msg_name => 'FEM_UD_NO_UPDATE_DEP_FOUND_TXT');
2218: END IF;
2219:
2220: -- Delete update dependent list from temporary tables as no longer needed.
2221: DELETE fem_ud_upd_dep_t WHERE upd_dep_calc_id = v_upd_dep_calc_id;
2222: DELETE fem_ud_upd_cols_t WHERE upd_dep_calc_id = v_upd_dep_calc_id;
2223: COMMIT;
2224:
2225: EXCEPTION

Line 2356: FROM fem_ud_upd_dep_t c

2352: -- Cursor to retrieve an object execution's UPDATE dependents
2353: -- Note that this only applies to ACCOUNT tables.
2354: CURSOR c1 IS
2355: SELECT c.upd_dep_calc_id, c.dependent_request_id, c.dependent_object_id
2356: FROM fem_ud_upd_dep_t c
2357: WHERE c.upd_dep_calc_id = v_upd_dep_calc_id
2358: AND NOT (c.dependent_request_id = p_request_id
2359: AND c.dependent_object_id = p_object_id);
2360:

Line 2581: DELETE fem_ud_upd_dep_t WHERE upd_dep_calc_id = v_upd_dep_calc_id;

2577: p_msg_name => 'FEM_UD_NO_UPDATE_DEP_FOUND_TXT');
2578: END IF;
2579:
2580: -- Delete update dependent list from temporary tables as no longer needed.
2581: DELETE fem_ud_upd_dep_t WHERE upd_dep_calc_id = v_upd_dep_calc_id;
2582: DELETE fem_ud_upd_cols_t WHERE upd_dep_calc_id = v_upd_dep_calc_id;
2583:
2584: EXCEPTION
2585: WHEN e_cannot_gen_cand_upd_dep THEN