DBA Data[Home] [Help]

APPS.CN_CALC_CLASSIFY_PVT dependencies on CN_FORMULA_COMMON_PKG

Line 221: cn_formula_common_pkg.revert_header_lines

217: WHERE commission_header_id = eachtrx.commission_header_id;
218:
219: IF (l_revenue_class_id <> eachtrx.revenue_class_id) THEN
220: -- new revenue_class_id, need to re-populate
221: cn_formula_common_pkg.revert_header_lines
222: (p_commission_header_id => eachtrx.commission_header_id,
223: p_revert_state => 'XCLS');
224: END IF;
225: ELSE

Line 235: cn_formula_common_pkg.revert_header_lines

231: last_updated_by = G_LAST_UPDATED_BY,
232: last_update_login = G_LAST_UPDATE_LOGIN
233: WHERE commission_header_id = eachtrx.commission_header_id;
234:
235: cn_formula_common_pkg.revert_header_lines
236: (p_commission_header_id => eachtrx.commission_header_id,
237: p_revert_state => 'XCLS');
238:
239: END IF;

Line 265: cn_formula_common_pkg.revert_header_lines

261: SET revenue_class_id = l_revenue_class_id
262: WHERE commission_header_id = eachtrx.commission_header_id;
263:
264: -- new revenue_class_id, need to re-populate
265: cn_formula_common_pkg.revert_header_lines
266: (p_commission_header_id => eachtrx.commission_header_id,
267: p_revert_state => 'ROLL');
268:
269: END IF;

Line 280: cn_formula_common_pkg.revert_header_lines

276: last_updated_by = G_LAST_UPDATED_BY,
277: last_update_login = G_LAST_UPDATE_LOGIN
278: WHERE commission_header_id = eachtrx.commission_header_id;
279:
280: cn_formula_common_pkg.revert_header_lines
281: (p_commission_header_id => eachtrx.commission_header_id,
282: p_revert_state => 'XCLS');
283:
284: END IF; -- End of l_revenue_class_id