DBA Data[Home] [Help]

APPS.PFT_BR_PROFIT_CALC_PVT dependencies on PFT_PPROF_CALC_RULES

Line 126: -- PFT_PPROF_CALC_RULES table.

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

Line 145: INSERT INTO PFT_PPROF_CALC_RULES (

141: --------------------------------------------------------------------------------
142: IS
143: BEGIN
144:
145: INSERT INTO PFT_PPROF_CALC_RULES (
146: PPROF_CALC_OBJ_DEF_ID
147: ,VALUE_INDEX_FORMULA_ID
148: ,CONDITION_OBJ_ID
149: ,REGION_COUNTING_FLAG

Line 180: FROM PFT_PPROF_CALC_RULES

176: ,FND_GLOBAL.user_id
177: ,SYSDATE
178: ,FND_GLOBAL.login_id
179: ,object_version_number
180: FROM PFT_PPROF_CALC_RULES
181: WHERE PPROF_CALC_OBJ_DEF_ID = p_source_obj_def_id;
182:
183: END CopyCalRuleRec;
184:

Line 192: -- in the PFT_PPROF_CALC_RULES table.

188: -- DeletCalRuleRec
189: --
190: -- DESCRIPTION
191: -- Deletes a Profit Calculation Rule Definition by performing deletes on records
192: -- in the PFT_PPROF_CALC_RULES table.
193: --
194: -- IN
195: -- p_obj_def_id - Object Definition ID.
196: --

Line 205: DELETE FROM PFT_PPROF_CALC_RULES

201: --------------------------------------------------------------------------------
202: IS
203: BEGIN
204:
205: DELETE FROM PFT_PPROF_CALC_RULES
206: WHERE PPROF_CALC_OBJ_DEF_ID = p_obj_def_id;
207:
208: END DeleteCalRuleRec;
209: