DBA Data[Home] [Help]

APPS.AMW_PROC_ORG_APPROVAL_PKG dependencies on AMW_RL_HIERARCHY_PKG

Line 236: amw_rl_hierarchy_pkg.update_org_count(p_process_id);

232: -- kosriniv.. Approve the Exceptions..
233: approve_exceptions(p_org_id, p_process_id);
234: IF p_update_count = FND_API.G_TRUE THEN
235: -- Now updat the Org Count......
236: amw_rl_hierarchy_pkg.update_org_count(p_process_id);
237: END IF;
238:
239: /**04.26.2007 npanandi: fix for bug 6017644, the below was not properly
240: commented out, leading to compilation errors

Line 271: amw_rl_hierarchy_pkg.update_org_count(c2_rec.parent_child_id);

267: approve_associations(c2_rec.parent_child_id, p_org_id);
268: write_approved_hierarchy(c2_rec.parent_child_id, 2, p_org_id);
269: IF p_update_count = FND_API.G_TRUE THEN
270: -- Update the Org Count
271: amw_rl_hierarchy_pkg.update_org_count(c2_rec.parent_child_id);
272: END IF;
273:
274: delete from amw_latest_hierarchies
275: where child_id = c2_rec.parent_child_id

Line 323: amw_rl_hierarchy_pkg.update_org_count(c1_rec.parent_child_id);

319: approve_associations(c1_rec.parent_child_id, p_org_id);
320: write_approved_hierarchy(c1_rec.parent_child_id, 2, p_org_id);
321: IF p_update_count = FND_API.G_TRUE THEN
322: -- Update the Org Count
323: amw_rl_hierarchy_pkg.update_org_count(c1_rec.parent_child_id);
324: END IF;
325:
326: end loop;
327:

Line 333: amw_rl_hierarchy_pkg.update_approved_denorm(p_org_id);

329:
330: write_approved_hierarchy(p_process_id, 1, p_org_id);
331: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
332: /*
333: amw_rl_hierarchy_pkg.update_approved_denorm(p_org_id);
334: */
335: IF p_update_count = FND_API.G_TRUE THEN
336: amw_org_hierarchy_pkg.upd_appr_control_count(p_org_id, null); --ko, commenting this.. -2);
337: amw_org_hierarchy_pkg.upd_appr_risk_count(p_org_id, null); --ko the count api is currently aggregating in the upward direction -2);