DBA Data[Home] [Help]

APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_DL_DIMENSIONS

Line 2065: -- Insert into fem_dl_dimensions.

2061: ELSE
2062: v_avg_balances := NULL;
2063: END IF;
2064:
2065: -- Insert into fem_dl_dimensions.
2066: -- If duplicate, update load status and avg_balances
2067: BEGIN
2068: INSERT INTO fem_dl_dimensions
2069: (request_id,

Line 2068: INSERT INTO fem_dl_dimensions

2064:
2065: -- Insert into fem_dl_dimensions.
2066: -- If duplicate, update load status and avg_balances
2067: BEGIN
2068: INSERT INTO fem_dl_dimensions
2069: (request_id,
2070: object_id,
2071: ledger_id,
2072: cal_period_id,

Line 2106: UPDATE fem_dl_dimensions

2102: 'N',
2103: 1);
2104: EXCEPTION
2105: WHEN dup_val_on_index THEN
2106: UPDATE fem_dl_dimensions
2107: SET load_status = p_load_status,
2108: avg_balances = v_avg_balances,
2109: last_updated_by = c_user_id,
2110: last_update_date = sysdate

Line 2195: DELETE FROM fem_dl_dimensions

2191:
2192: -- If p_table_name is not passed, then unregister the whole object execution.
2193: -- Otherwise, just unregister the data locations for the table.
2194: IF p_table_name IS NULL THEN
2195: DELETE FROM fem_dl_dimensions
2196: WHERE request_id = p_request_id
2197: AND object_id = p_object_id;
2198:
2199: DELETE FROM fem_dl_trans_curr

Line 2203: DELETE FROM fem_dl_dimensions

2199: DELETE FROM fem_dl_trans_curr
2200: WHERE request_id = p_request_id
2201: AND object_id = p_object_id;
2202: ELSE
2203: DELETE FROM fem_dl_dimensions
2204: WHERE request_id = p_request_id
2205: AND object_id = p_object_id
2206: AND table_name = p_table_name;
2207: