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_RL_HIERARCHY_PKG dependencies on AMW_RL_HIERARCHY_PKG

Line 1: PACKAGE BODY AMW_RL_HIERARCHY_PKG AS

1: PACKAGE BODY AMW_RL_HIERARCHY_PKG AS
2: /*$Header: amwrlhrb.pls 120.6 2006/03/20 02:52:55 appldev noship $*/
3:
4: function encode (n1 in number, n2 in number) return varchar2 is
5: begin

Line 3567: amw_rl_hierarchy_pkg.update_denorm (-1, sysdate);

3563: retcode :=0;
3564: errbuf :='';
3565:
3566: --updates latest hier denorm
3567: amw_rl_hierarchy_pkg.update_denorm (-1, sysdate);
3568: --updates approved hier denorm
3569: amw_rl_hierarchy_pkg.update_approved_denorm (-1, sysdate);
3570:
3571: update amw_process

Line 3569: amw_rl_hierarchy_pkg.update_approved_denorm (-1, sysdate);

3565:
3566: --updates latest hier denorm
3567: amw_rl_hierarchy_pkg.update_denorm (-1, sysdate);
3568: --updates approved hier denorm
3569: amw_rl_hierarchy_pkg.update_approved_denorm (-1, sysdate);
3570:
3571: update amw_process
3572: set risk_count = null,
3573: control_count = null,

Line 3578: amw_rl_hierarchy_pkg.update_all_latest_rc_counts('RC');

3574: risk_count_latest = null,
3575: control_count_latest = null;
3576:
3577: --updates latest risk/control counts
3578: amw_rl_hierarchy_pkg.update_all_latest_rc_counts('RC');
3579: --updates approved risk counts
3580: amw_rl_hierarchy_pkg.update_appr_risk_counts;
3581: --updates approved control counts
3582: amw_rl_hierarchy_pkg.update_appr_control_counts;

Line 3580: amw_rl_hierarchy_pkg.update_appr_risk_counts;

3576:
3577: --updates latest risk/control counts
3578: amw_rl_hierarchy_pkg.update_all_latest_rc_counts('RC');
3579: --updates approved risk counts
3580: amw_rl_hierarchy_pkg.update_appr_risk_counts;
3581: --updates approved control counts
3582: amw_rl_hierarchy_pkg.update_appr_control_counts;
3583: -- update approved org counts
3584: amw_rl_hierarchy_pkg.update_all_org_counts;

Line 3582: amw_rl_hierarchy_pkg.update_appr_control_counts;

3578: amw_rl_hierarchy_pkg.update_all_latest_rc_counts('RC');
3579: --updates approved risk counts
3580: amw_rl_hierarchy_pkg.update_appr_risk_counts;
3581: --updates approved control counts
3582: amw_rl_hierarchy_pkg.update_appr_control_counts;
3583: -- update approved org counts
3584: amw_rl_hierarchy_pkg.update_all_org_counts;
3585:
3586: commit;

Line 3584: amw_rl_hierarchy_pkg.update_all_org_counts;

3580: amw_rl_hierarchy_pkg.update_appr_risk_counts;
3581: --updates approved control counts
3582: amw_rl_hierarchy_pkg.update_appr_control_counts;
3583: -- update approved org counts
3584: amw_rl_hierarchy_pkg.update_all_org_counts;
3585:
3586: commit;
3587:
3588: EXCEPTION

Line 3826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',

3822:
3823: if ret_val <> 'Y' then
3824: fnd_message.set_name('AMW','AMW_CANT_UNDO_DRAFT');
3825: err_msg := fnd_message.get;
3826: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',
3827: p_procedure_name => 'delete_draft',
3828: p_error_text => err_msg);
3829: raise FND_API.G_EXC_ERROR;
3830: end if;

Line 3865: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',

3861: and end_date is null);
3862:
3863: fnd_message.set_name('AMW','AMW_CANT_DEL_DRAFT_NS');
3864: err_msg := fnd_message.get;
3865: fnd_msg_pub.add_exc_msg(p_pkg_name => 'amw_rl_hierarchy_pkg',
3866: p_procedure_name => 'delete_draft',
3867: p_error_text => err_msg);
3868: raise FND_API.G_EXC_ERROR;
3869:

Line 3981: amw_rl_hierarchy_pkg.update_denorm (-1, sysdate);

3977:
3978: -- cancel existing change requests
3979:
3980: -- update latest hierarchy denorm
3981: amw_rl_hierarchy_pkg.update_denorm (-1, sysdate);
3982:
3983: --ko update the risk control counts..
3984:
3985: if appexst = 'Y' AND l_risk_exists then

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

4369: RAISE FND_API.G_EXC_ERROR;
4370: END IF;
4371:
4372: -- update the latest denorm hierarchy..
4373: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => -1);
4374: -- Update the Risk Counts..
4375: update_latest_risk_counts(p_process_id => p_process_id);
4376: -- Update the Control Counts..
4377: update_latest_control_counts( p_process_id => p_process_id);

Line 4401: end AMW_RL_HIERARCHY_PKG;

4397: END IF;
4398: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
4399: END update_latest_denorm_counts;
4400:
4401: end AMW_RL_HIERARCHY_PKG;