DBA Data[Home] [Help]

APPS.FEM_DIM_SNAPSHOT_UTIL_PKG dependencies on FEM_DSNP_RULE_DIMS

Line 196: INSERT INTO fem_dsnp_rule_dims (

192: WHEN no_data_found THEN raise e_invalid_dim;
193: END;
194:
195: BEGIN
196: INSERT INTO fem_dsnp_rule_dims (
197: DIM_SNAPSHOT_OBJ_DEF_ID
198: ,DIMENSION_ID
199: ,CREATION_DATE
200: ,CREATED_BY

Line 402: DELETE FROM fem_dsnp_rule_dims

398: EXCEPTION
399: WHEN no_data_found THEN raise e_invalid_dim;
400: END;
401:
402: DELETE FROM fem_dsnp_rule_dims
403: WHERE dim_snapshot_obj_def_id = p_dim_snapshot_obj_def_id
404: AND dimension_id = v_dimension_id;
405:
406: IF FND_API.To_Boolean( p_commit ) THEN