APPS.AMW_ORG_HIERARCHY_PKG dependencies on FND_PROFILE

Line 2986: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN

2982: -- approval option ad hoc for this association process. When user associates a process,
2983: -- may be some-subprocess down below is in pending approval status, and that should prevent
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

Line 3164: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then

3160: COMMIT;
3161:
3162: -- Update the latest risk and control counts
3163:
3164: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then
3165:
3166: if p_org_range_from is not null and p_org_range_to is not null then
3167:
3168: update amw_process_organization APO

Line 3554: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN

3550: -- approval option ad hoc for this association process. When user associates a process,
3551: -- may be some-subprocess down below is in pending approval status, and that should prevent
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

Line 3648: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then

3644: and organization_id = l_orgs_tbl(ctr)
3645: and process_id = l_procs_tbl(ctr);
3646:
3647:
3648: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then
3649:
3650:
3651: forall ctr in l_orgs_tbl.first .. l_orgs_tbl.last
3652: update amw_process_organization

Line 3835: if fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' then

3831: -- approval option ad hoc for this association process. When user associates a process,
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:

Line 8760: l_assoc_app_prof := fnd_profile.value('AMW_PROC_ORG_ASS_APPRV');

8756: fetch c2 bulk collect into l_audit_units_tbl;
8757: close c2;
8758: end if;
8759: if l_audit_units_tbl.exists(1) then
8760: l_assoc_app_prof := fnd_profile.value('AMW_PROC_ORG_ASS_APPRV');
8761: IF l_assoc_app_prof = 'Y' THEN
8762: AMW_UTILITY_PVT.cache_appr_options;
8763: END IF;
8764: FOR orgid IN l_audit_units_tbl.first .. l_audit_units_tbl.last loop

Line 8792: IF fnd_profile.value('AMW_PROC_ORG_ASS_APPRV') = 'Y' THEN

8788: -- approval option ad hoc for this association process. When user associates a process,
8789: -- may be some-subprocess down below is in pending approval status, and that should prevent
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