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

Line 547: AMW_RL_HIERARCHY_PKG.update_appr_ch_ord_num_if_reqd

543: VALUES
544: (p_org_id,p_parent_process_id,p_child_process_id,AMW_ORG_CHILD_ORDER_S.nextval, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1)
545: returning CHILD_ORDER_NUMBER
546: into l_child_order_num;
547: AMW_RL_HIERARCHY_PKG.update_appr_ch_ord_num_if_reqd
548: (p_org_id => p_org_id,
549: p_parent_id => p_parent_process_id,
550: p_child_id => p_child_process_id,
551: p_instance_id => l_child_order_num);

Line 3848: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);

3844: IF (p_update_count = FND_API.G_TRUE) THEN
3845: -- update the org counts of the child process and its hierarchy....
3846: for descendents_rec in c1(p_process_id) loop
3847: exit when c1%notfound;
3848: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);
3849: end loop;
3850: END IF;
3851:
3852: IF (p_commit = FND_API.G_TRUE) then

Line 3947: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_org_id);

3943: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3944: 'amw.plsql.AMW_ORG_HIERARCHY_PKG.PUSH_PROC_PER_ORG.update_denorm',
3945: 'Begin update denrom; OrgId:' ||p_org_id );
3946: end if;
3947: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_org_id);
3948: */
3949: IF p_update_count = FND_API.G_TRUE THEN
3950: -- ko update the risk1 counts of the child process..
3951: if( l_log_stmt_level >= l_curr_log_level ) then

Line 4100: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);

4096: /*
4097: -- Update the Proc_org_hierarchy_denorm tables..
4098:
4099:
4100: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);
4101: */
4102: -- update the risk 1 counts of the parent process ..
4103: upd_ltst_risk_count(p_org_id => p_organization_id, p_process_id => p_parent_id);
4104:

Line 4131: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);

4127: p_apply_rcm => p_apply_rcm);
4128: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
4129: /*
4130: -- Update the Proc_org_hierarchy_denorm tables..
4131: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);
4132: */
4133: -- update the risk1 counts of the child process..
4134: upd_ltst_risk_count(p_org_id => p_organization_id, p_process_id => null);
4135:

Line 4141: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);

4137:
4138: -- update the org counts of the child process and its hierarchy....
4139: for descendents_rec in c1(p_child_id) loop
4140: exit when c1%notfound;
4141: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);
4142: end loop;
4143: END;
4144:
4145: END IF;

Line 4241: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);

4237: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
4238: /*
4239: -- Update the Proc_org_hierarchy_denorm tables..
4240:
4241: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);
4242: */
4243: -- update the risk 1 counts of the parent process ..
4244: upd_ltst_risk_count(p_org_id => p_organization_id, p_process_id => p_parent_id);
4245:

Line 4312: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);

4308: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
4309: /*
4310: -- Update the Proc_org_hierarchy_denorm tables..
4311:
4312: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);
4313: */
4314:
4315: upd_ltst_risk_count(p_org_id => p_organization_id, p_process_id => NULL);
4316:

Line 4401: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_org_id);

4397: p_sync_people => p_sync_people );
4398: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
4399: /*
4400: -- Synchronized the hierarchy...So update the hierarchy denorm tables.
4401: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_org_id);
4402: */
4403: upd_ltst_risk_count(p_org_id => p_org_id, p_process_id => NULL);
4404:
4405: upd_ltst_control_count(p_org_id => p_org_id, p_process_id => NULL);

Line 4410: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);

4406:
4407: -- update the org counts of the child process and its hierarchy....
4408: for descendents_rec in c1(p_process_id) loop
4409: exit when c1%notfound;
4410: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);
4411: end loop;
4412:
4413:
4414:

Line 5001: amw_rl_hierarchy_pkg.update_org_count(p_process_id);

4997: X_pk1_value => previd);
4998:
4999: -- cancel existing change requests
5000: -- update org count..
5001: amw_rl_hierarchy_pkg.update_org_count(p_process_id);
5002: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
5003: /*
5004: -- update latest hierarchy denorm
5005: amw_rl_hierarchy_pkg.update_denorm (p_organization_id, sysdate);

Line 5005: amw_rl_hierarchy_pkg.update_denorm (p_organization_id, sysdate);

5001: amw_rl_hierarchy_pkg.update_org_count(p_process_id);
5002: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
5003: /*
5004: -- update latest hierarchy denorm
5005: amw_rl_hierarchy_pkg.update_denorm (p_organization_id, sysdate);
5006: */
5007: if appexst = 'Y' AND l_risk_exists then
5008:
5009: -- Update the latest risk control counts..

Line 7872: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => orgid);

7868: p_sync_people => p_sync_people );
7869: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
7870: /*
7871: --Ko Update the Proc_org_hierarchy_denorm tables..
7872: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => orgid);
7873: */
7874: -- ko update the risk1 counts of the child process..
7875: upd_ltst_risk_count(p_org_id => orgid, p_process_id => null);
7876:

Line 7888: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);

7884:
7885: -- update the org counts of the child process and its hierarchy....
7886: for descendents_rec in c1(p_process_id) loop
7887: exit when c1%notfound;
7888: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);
7889: end loop;
7890:
7891: exception
7892:

Line 7937: amw_rl_hierarchy_pkg.update_denorm (org_cursor.organization_id, sysdate);

7933: exit when all_orgs%notfound;
7934: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
7935: /*
7936: --updates latest hier denorm
7937: amw_rl_hierarchy_pkg.update_denorm (org_cursor.organization_id, sysdate);
7938: --updates approved hier denorm
7939: amw_rl_hierarchy_pkg.update_approved_denorm (org_cursor.organization_id, sysdate);
7940: */
7941: update amw_process_organization

Line 7939: amw_rl_hierarchy_pkg.update_approved_denorm (org_cursor.organization_id, sysdate);

7935: /*
7936: --updates latest hier denorm
7937: amw_rl_hierarchy_pkg.update_denorm (org_cursor.organization_id, sysdate);
7938: --updates approved hier denorm
7939: amw_rl_hierarchy_pkg.update_approved_denorm (org_cursor.organization_id, sysdate);
7940: */
7941: update amw_process_organization
7942: set risk_count = null,
7943: control_count = null,

Line 7965: amw_rl_hierarchy_pkg.update_denorm (p_org_id, sysdate);

7961: else
7962: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
7963: /*
7964: --updates latest hier denorm
7965: amw_rl_hierarchy_pkg.update_denorm (p_org_id, sysdate);
7966: --updates approved hier denorm
7967: amw_rl_hierarchy_pkg.update_approved_denorm (p_org_id, sysdate);
7968: */
7969: update amw_process_organization

Line 7967: amw_rl_hierarchy_pkg.update_approved_denorm (p_org_id, sysdate);

7963: /*
7964: --updates latest hier denorm
7965: amw_rl_hierarchy_pkg.update_denorm (p_org_id, sysdate);
7966: --updates approved hier denorm
7967: amw_rl_hierarchy_pkg.update_approved_denorm (p_org_id, sysdate);
7968: */
7969: update amw_process_organization
7970: set risk_count = null,
7971: control_count = null,

Line 8121: AMW_RL_HIERARCHY_PKG.update_appr_ch_ord_num_if_reqd

8117: (p_organization_id,p_parent_process_id,l_child_id,AMW_ORG_CHILD_ORDER_S.nextval, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1)
8118: returning CHILD_ORDER_NUMBER
8119: into l_child_order_num;
8120:
8121: AMW_RL_HIERARCHY_PKG.update_appr_ch_ord_num_if_reqd
8122: (p_org_id => p_organization_id,
8123: p_parent_id => p_parent_process_id,
8124: p_child_id => l_child_id,
8125: p_instance_id => l_child_order_num);

Line 8231: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);

8227:
8228: -- update the org counts of the child process and its hierarchy....
8229: for descendents_rec in c1(l_child_id) loop
8230: exit when c1%notfound;
8231: amw_rl_hierarchy_pkg.update_org_count(descendents_rec.process_to_count);
8232: end loop;
8233: END;
8234: end loop;
8235: exception

Line 8286: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);

8282: RAISE FND_API.G_EXC_ERROR;
8283: END IF;
8284:
8285: -- update the latest denorm hierarchy..
8286: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id => p_organization_id);
8287: -- Update the Risk Counts..
8288: upd_ltst_risk_count(p_org_id => p_organization_id, p_process_id => p_process_id);
8289: -- Update the Control Counts..
8290: upd_ltst_control_count(p_org_id => p_organization_id, p_process_id => p_process_id);

Line 8456: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id =>Org_Ids(indx));

8452: LOOP
8453: --ko replacing the below clause for removing amw_org_hierarchy_denorm usage...
8454: /*
8455: --Ko Update the Proc_org_hierarchy_denorm tables..
8456: AMW_RL_HIERARCHY_PKG.update_denorm(p_org_id =>Org_Ids(indx));
8457: */
8458: IF p_sync_approve = 'AUTO' THEN
8459: BEGIN
8460: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, Org_Ids(indx));