DBA Data[Home] [Help]

APPS.AMW_PROC_APPROVAL_PKG dependencies on AMW_RL_HIERARCHY_PKG

Line 203: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => p_process_id);

199: end if;
200:
201:
202: --kosriniv ..Need to update the org count...
203: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => p_process_id);
204: approve_associations(p_process_id);
205: write_approved_hierarchy(p_process_id, 2);
206:
207:

Line 226: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => c1_rec.parent_child_id );

222: where process_id = c1_rec.parent_child_id
223: and revision_number = (rev_num-1);
224: end if;
225: --kosriniv ..Need to update the org count...
226: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => c1_rec.parent_child_id );
227: approve_associations(c1_rec.parent_child_id);
228: write_approved_hierarchy(p_process_id, 2);
229: end loop;
230:

Line 234: amw_rl_hierarchy_pkg.update_approved_denorm(-1);

230:
231: end if;
232:
233: write_approved_hierarchy(p_process_id, 1);
234: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
235: amw_rl_hierarchy_pkg.update_appr_control_counts;
236: amw_rl_hierarchy_pkg.update_appr_risk_counts;
237:
238: end approve;

Line 235: amw_rl_hierarchy_pkg.update_appr_control_counts;

231: end if;
232:
233: write_approved_hierarchy(p_process_id, 1);
234: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
235: amw_rl_hierarchy_pkg.update_appr_control_counts;
236: amw_rl_hierarchy_pkg.update_appr_risk_counts;
237:
238: end approve;
239:

Line 236: amw_rl_hierarchy_pkg.update_appr_risk_counts;

232:
233: write_approved_hierarchy(p_process_id, 1);
234: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
235: amw_rl_hierarchy_pkg.update_appr_control_counts;
236: amw_rl_hierarchy_pkg.update_appr_risk_counts;
237:
238: end approve;
239:
240:

Line 1222: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => p_process_id);

1218: and revision_number = (rev_num-1);
1219: end if;
1220:
1221: --kosriniv ..Need to update the org count...
1222: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => p_process_id);
1223:
1224: approve_associations(p_process_id);
1225: ---05.11.2005 npanandi: per Amit, not needed here, since we will be calling
1226: ---write_approved_hierarchy with step # = 4

Line 1248: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => c1_rec.parent_child_id);

1244: and revision_number = (rev_num-1);
1245: end if;
1246:
1247: --kosriniv ..Need to update the org count...
1248: AMW_RL_HIERARCHY_PKG.update_org_count(p_process_id => c1_rec.parent_child_id);
1249:
1250: approve_associations(c1_rec.parent_child_id);
1251: ---05.11.2005 npanandi: per Amit, not needed here, since we will be calling
1252: ---write_approved_hierarchy with step # = 4

Line 1262: amw_rl_hierarchy_pkg.update_approved_denorm(-1);

1258: ---05.11.2005 npanandi: calling this once from the main API, hence
1259: ---commenting out here
1260: /**
1261: write_approved_hierarchy(p_process_id, 1);
1262: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
1263: amw_rl_hierarchy_pkg.update_appr_control_counts;
1264: amw_rl_hierarchy_pkg.update_appr_risk_counts;
1265: **/
1266: end webadi_approve;

Line 1263: amw_rl_hierarchy_pkg.update_appr_control_counts;

1259: ---commenting out here
1260: /**
1261: write_approved_hierarchy(p_process_id, 1);
1262: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
1263: amw_rl_hierarchy_pkg.update_appr_control_counts;
1264: amw_rl_hierarchy_pkg.update_appr_risk_counts;
1265: **/
1266: end webadi_approve;
1267:

Line 1264: amw_rl_hierarchy_pkg.update_appr_risk_counts;

1260: /**
1261: write_approved_hierarchy(p_process_id, 1);
1262: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
1263: amw_rl_hierarchy_pkg.update_appr_control_counts;
1264: amw_rl_hierarchy_pkg.update_appr_risk_counts;
1265: **/
1266: end webadi_approve;
1267:
1268: