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_PROC_ORG_APPROVAL_PKG

Line 568: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 0, p_org_id,sysdate);

564: if( l_log_stmt_level >= l_curr_log_level ) then
565: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
566: '-2;0;'||p_org_id ||':'||sysdate);
567: end if;
568: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 0, p_org_id,sysdate);
569: elsif p_action = 'DEL' then
570: if( l_log_stmt_level >= l_curr_log_level ) then
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
572: '-2;2;'||p_org_id ||':'||sysdate);

Line 574: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 2, p_org_id,sysdate);

570: if( l_log_stmt_level >= l_curr_log_level ) then
571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
572: '-2;2;'||p_org_id ||':'||sysdate);
573: end if;
574: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 2, p_org_id,sysdate);
575: end if;
576: if( l_log_stmt_level >= l_curr_log_level ) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
578: '-2;3;'||p_org_id ||':'||sysdate);

Line 580: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 3, p_org_id,sysdate);

576: if( l_log_stmt_level >= l_curr_log_level ) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
578: '-2;3;'||p_org_id ||':'||sysdate);
579: end if;
580: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 3, p_org_id,sysdate);
581:
582: if( l_log_stmt_level >= l_curr_log_level ) then
583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'amw.plsql.AMW_ORG_HIERARCHY_PKG.ADD_DELETE_EX_CHILD.write_approved_hierarchy',
584: 'WRITE_APPROVED_HIERARCHY_END');

Line 2467: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 2, p_org_id);

2463: -- koEnd.
2464: -- disassociate the hierarchy
2465: disassociate_process_org_hier(p_org_id, p_process_id);
2466: -- Now we need to delete the links of the process from the root process if there are any..
2467: AMW_PROC_ORG_APPROVAL_PKG.write_approved_hierarchy(-2, 2, p_org_id);
2468:
2469: -- Now we need to set the deletion date of this process...................
2470:
2471: delete_process(p_org_id, p_process_id);

Line 2988: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);

2984: -- modifying the approval option.
2985: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
2986: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
2987: BEGIN
2988: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
2989: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
2990: EXCEPTION
2991: WHEN OTHERS THEN
2992: show_warning := true;

Line 2989: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);

2985: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
2986: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
2987: BEGIN
2988: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
2989: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
2990: EXCEPTION
2991: WHEN OTHERS THEN
2992: show_warning := true;
2993: ROLLBACK;

Line 3556: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);

3552: -- modifying the approval option.
3553: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
3554: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
3555: BEGIN
3556: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
3557: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
3558: EXCEPTION
3559: WHEN OTHERS THEN
3560: show_warning := true;

Line 3557: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);

3553: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
3554: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
3555: BEGIN
3556: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
3557: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
3558: EXCEPTION
3559: WHEN OTHERS THEN
3560: show_warning := true;
3561: ROLLBACK;

Line 3836: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, orgid);

3832: -- may be some-subprocess down below is in pending approval status, and that should prevent
3833: -- modifying the approval option.
3834: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
3835: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then
3836: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, orgid);
3837: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, orgid,p_update_count);
3838: end if;
3839:
3840:

Line 3837: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, orgid,p_update_count);

3833: -- modifying the approval option.
3834: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
3835: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then
3836: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, orgid);
3837: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, orgid,p_update_count);
3838: end if;
3839:
3840:
3841: select LTRIM(str, 'x') into l_org_string from dual;

Line 8460: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, Org_Ids(indx));

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));
8461: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, Org_Ids(indx),FND_API.G_FALSE);
8462: EXCEPTION
8463: WHEN OTHERS THEN
8464: show_warning := true;

Line 8461: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, Org_Ids(indx),FND_API.G_FALSE);

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));
8461: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, Org_Ids(indx),FND_API.G_FALSE);
8462: EXCEPTION
8463: WHEN OTHERS THEN
8464: show_warning := true;
8465: ROLLBACK;

Line 8794: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);

8790: -- modifying the approval option.
8791: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
8792: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
8793: BEGIN
8794: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
8795: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
8796: EXCEPTION
8797: WHEN OTHERS THEN
8798: show_warning := true;

Line 8795: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);

8791: -- Also note that the "Approval Required" parameter for the org will be overridden, if set to yes.
8792: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN
8793: BEGIN
8794: AMW_PROC_ORG_APPROVAL_PKG.sub_for_approval(p_process_id, l_audit_units_tbl(orgid).organization_id);
8795: AMW_PROC_ORG_APPROVAL_PKG.approve(p_process_id, l_audit_units_tbl(orgid).organization_id,FND_API.G_FALSE);
8796: EXCEPTION
8797: WHEN OTHERS THEN
8798: show_warning := true;
8799: ROLLBACK;