APPS.FEM_DIMENSION_UTIL_PKG dependencies on FEM_DL_TRANS_CURR

Line 2120: -- If p_trans_curr is not null, insert into fem_dl_trans_curr

2116: AND source_system_code = p_source_cd
2117: AND table_name = p_table_name;
2118: END;
2119:
2120: -- If p_trans_curr is not null, insert into fem_dl_trans_curr
2121: -- Do nothing if inserting duplicate row.
2122: IF p_trans_curr IS NOT NULL THEN
2123: BEGIN
2124: INSERT INTO fem_dl_trans_curr

Line 2124: INSERT INTO fem_dl_trans_curr

2120: -- If p_trans_curr is not null, insert into fem_dl_trans_curr
2121: -- Do nothing if inserting duplicate row.
2122: IF p_trans_curr IS NOT NULL THEN
2123: BEGIN
2124: INSERT INTO fem_dl_trans_curr
2125: (request_id,
2126: object_id,
2127: ledger_id,
2128: cal_period_id,

Line 2199: DELETE FROM fem_dl_trans_curr

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
2200: WHERE request_id = p_request_id
2201: AND object_id = p_object_id;
2202: ELSE
2203: DELETE FROM fem_dl_dimensions

Line 2208: DELETE FROM fem_dl_trans_curr

2204: WHERE request_id = p_request_id
2205: AND object_id = p_object_id
2206: AND table_name = p_table_name;
2207:
2208: DELETE FROM fem_dl_trans_curr
2209: WHERE request_id = p_request_id
2210: AND object_id = p_object_id
2211: AND table_name = p_table_name;
2212: END IF;