DBA Data[Home] [Help]

APPS.AMW_LOAD_PROC_DATA dependencies on AMW_PROC_APPROVAL_PKG

Line 691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');

687: ---fnd_file.put_line(fnd_file.log, 'display_name: '||l_db_process_display_name||', l_db_proc_appr_status: '||l_db_proc_appr_status );
688: if(not v_error_found and l_db_proc_appr_status = 'D')then
689: BEGIN
690: /*fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');
692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
693:
694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);

Line 695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);

691: AMW_PROC_APPROVAL_PKG.SUB_FOR_APPROVAL(p_process_id => L_PROCESS_ID,p_webadi_call => 'Y');
692: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: sub_for_approval End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
693:
694: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);
696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
697: */
698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
699: amw_proc_approval_pkg.WEBADI_APPROVE(

Line 699: amw_proc_approval_pkg.WEBADI_APPROVE(

695: AMW_PROC_APPROVAL_PKG.APPROVE(P_PROCESS_ID => L_PROCESS_ID);
696: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
697: */
698: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
699: amw_proc_approval_pkg.WEBADI_APPROVE(
700: p_process_id => l_process_id
701: ,p_approv_choice => l_get_param);
702: ---fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: webadi_approve End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
703: EXCEPTION

Line 718: amw_proc_approval_pkg.write_approved_hierarchy(p_step => 4);

714: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: insert Approvals End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
715:
716: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
717: ---05.11.2005 npanandi: added below as a one time call, instead of per-row
718: amw_proc_approval_pkg.write_approved_hierarchy(p_step => 4);
719: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: write approved hierarchy End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
720:
721: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);