DBA Data[Home] [Help]

APPS.PFT_BR_PROFIT_AGG_PVT dependencies on PFT_PPROF_AGG_RULES

Line 127: -- PFT_PPROF_AGG_RULES table.

123: -- CopyAggRuleRec
124: --
125: -- DESCRIPTION
126: -- Creates a new Profit Aggregation Rule Definition Formula by copying records in the
127: -- PFT_PPROF_AGG_RULES table.
128: --
129: -- IN
130: -- p_source_obj_def_id - Source Object Definition ID.
131: -- p_target_obj_def_id - Target Object Definition ID.

Line 146: INSERT INTO PFT_PPROF_AGG_RULES (

142: --------------------------------------------------------------------------------
143: IS
144: BEGIN
145:
146: INSERT INTO PFT_PPROF_AGG_RULES (
147: pprof_agg_obj_def_id
148: ,created_by
149: ,creation_date
150: ,last_updated_by

Line 172: FROM pft_pprof_agg_rules

168: ,condition_obj_id
169: ,hierarchy_obj_id
170: ,dimension_grp_id_from
171: ,dimension_grp_id_to
172: FROM pft_pprof_agg_rules
173: WHERE pprof_agg_obj_def_id = p_source_obj_def_id;
174:
175: END CopyAggRuleRec;
176:

Line 184: -- in the PFT_PPROF_AGG_RULES table.

180: -- DeletAggRuleRec
181: --
182: -- DESCRIPTION
183: -- Deletes a Profit Aggregation Rule Definition by performing deletes on records
184: -- in the PFT_PPROF_AGG_RULES table.
185: --
186: -- IN
187: -- p_obj_def_id - Object Definition ID.
188: --

Line 197: DELETE FROM PFT_PPROF_AGG_RULES

193: --------------------------------------------------------------------------------
194: IS
195: BEGIN
196:
197: DELETE FROM PFT_PPROF_AGG_RULES
198: WHERE PPROF_AGG_OBJ_DEF_ID = p_obj_def_id;
199:
200: END DeleteAggRuleRec;
201: