eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMW_LOAD_PROC_DATA dependencies on AMW_RL_HIERARCHY_PKG

Line 486: AMW_RL_HIERARCHY_PKG.REVISE_PROCESS_IF_NECESSARY(

482:
483: ---03.02.2005 npanandi: added check in the IF condition for v_error_found
484: IF(L_PROCESS_ID IS NOT NULL AND INSERT_REC.REVISE_PROCESS_FLAG='R' and not v_error_found) THEN
485: --THIS PROCESS EXISTS, SO REVISE, IF NECESSARY, AND THEN UPDATE ...
486: AMW_RL_HIERARCHY_PKG.REVISE_PROCESS_IF_NECESSARY(
487: P_PROCESS_ID => L_PROCESS_ID
488: );
489:
490: L_PROCESS_REC.PROCESS_ID := L_PROCESS_ID;

Line 552: AMW_RL_HIERARCHY_PKG.DELETE_CHILD(

548: --SET THESE VALUES APPROPRIATELY ....
549: lx_return_status := FND_API.G_RET_STS_SUCCESS;
550: LX_MSG_COUNT := NULL;
551: LX_MSG_DATA := NULL;
552: AMW_RL_HIERARCHY_PKG.DELETE_CHILD(
553: P_PARENT_PROCESS_ID => L_PARENT_PROCESS_ID
554: ,P_CHILD_PROCESS_ID => L_PROCESS_ID
555: ,X_RETURN_STATUS => LX_RETURN_STATUS
556: ,X_MSG_COUNT => LX_MSG_COUNT

Line 610: AMW_RL_HIERARCHY_PKG.add_WEBADI_HIERARCHY_LINKS(

606: --THE BELOW METHOD HAS BEEN ADDED BY NPANANDI
607: --IT IS THE SAME AS ADD_EXISTING_PROCESS_AS_CHILD ...
608: ---03.02.2005 npanandi: added check for v_error_found below
609: if(L_PARENT_PROCESS_ID is not null and L_PROCESS_ID is not null and INSERT_LINKS.revise_process_flag='R' and not v_error_found)then
610: AMW_RL_HIERARCHY_PKG.add_WEBADI_HIERARCHY_LINKS(
611: P_CHILD_ORDER_NUMBER => L_PROCESS_SEQUENCE_NUMBER
612: ,P_PARENT_PROCESS_ID => L_PARENT_PROCESS_ID
613: ,P_CHILD_PROCESS_ID => L_PROCESS_ID
614: ,X_RETURN_STATUS => LX_RETURN_STATUS

Line 626: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => -1);

622: ---call updateDenorm only if no errors encountered
623: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
624: if(not v_error_found)then
625: ---calling Nirman's procedure to update denorm tbl
626: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => -1);
627:
628: ---nirman's update latest ctrl, risk API called here ...
629: AMW_RL_HIERARCHY_PKG.update_all_latest_rc_counts(p_mode => 'RC');
630: end if;

Line 629: AMW_RL_HIERARCHY_PKG.update_all_latest_rc_counts(p_mode => 'RC');

625: ---calling Nirman's procedure to update denorm tbl
626: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => -1);
627:
628: ---nirman's update latest ctrl, risk API called here ...
629: AMW_RL_HIERARCHY_PKG.update_all_latest_rc_counts(p_mode => 'RC');
630: end if;
631: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update denorm, count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
632:
633: ---do the approval related stuff here ....

Line 722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);

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);
723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
726: amw_rl_hierarchy_pkg.update_appr_control_counts;

Line 726: amw_rl_hierarchy_pkg.update_appr_control_counts;

722: amw_rl_hierarchy_pkg.update_approved_denorm(-1);
723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
726: amw_rl_hierarchy_pkg.update_appr_control_counts;
727: amw_rl_hierarchy_pkg.update_appr_risk_counts;
728: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
729: ---05.11.2005 npanandi: ends above change
730: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: new procedures End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );

Line 727: amw_rl_hierarchy_pkg.update_appr_risk_counts;

723: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved denorm End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
724:
725: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count Start '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
726: amw_rl_hierarchy_pkg.update_appr_control_counts;
727: amw_rl_hierarchy_pkg.update_appr_risk_counts;
728: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: update approved Risk/Ctrl count End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
729: ---05.11.2005 npanandi: ends above change
730: fnd_file.put_line(fnd_file.LOG, 'TIMECHECK: new procedures End '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
731:

Line 981: L_PRC_CODE := NVL(AMW_RL_HIERARCHY_PKG.get_process_code(),'AUTO: ');

977: L_DISP_NAME := PROCESS_REC.PROCESS_DISPLAY_NAME;
978: L_INTF_ID := PROCESS_REC.PROCESS_INTERFACE_ID;
979: ---putting an NVL, just in case,
980: ---since we cannot afford a NULL Process_Code!!
981: L_PRC_CODE := NVL(AMW_RL_HIERARCHY_PKG.get_process_code(),'AUTO: ');
982: --SET THE PROCESS CODE FOR THE ROW WITH
983: --NEW PROCESS NAME AND NULL PROCESS CODE
984: BEGIN
985: UPDATE AMW_PROCESSES_INTERFACE