APPS.AMW_PROCESS_CERT_SUMMARY dependencies on FND_PROFILE

Line 588: l_global_org_id := fnd_profile.value('AMW_GLOBAL_ORG_ID');

584: FETCH get_total_controls into l_total_controls;
585: CLOSE get_total_controls;
586:
587: /*
588: l_global_org_id := fnd_profile.value('AMW_GLOBAL_ORG_ID');
589:
590: IF (l_global_org_id IS NOT NULL) AND (l_global_org_id = p_org_id)
591: THEN
592: l_global_process := 'Y';

Line 634: l_global_org_id := fnd_profile.value('AMW_GLOBAL_ORG_ID');

630:
631: ---04.28.2005 npanandi: commenting below uniform setting to 'Y'
632: ---and setting to 'Y' only if p_org is the profile option Global Org
633: ---l_global_process := 'Y';
634: l_global_org_id := fnd_profile.value('AMW_GLOBAL_ORG_ID');
635: IF (l_global_org_id IS NOT NULL) AND (l_global_org_id = p_org_id) then
636: l_global_process := 'Y';
637: end if;
638:

Line 996: AND aes.organization_id = fnd_profile.value('AMW_GLOBAL_ORG_ID')

992: FROM AMW_EXECUTION_SCOPE aes
993: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
994: AND aes.entity_id = p_certification_id
995: AND aes.level_id > 3
996: AND aes.organization_id = fnd_profile.value('AMW_GLOBAL_ORG_ID')
997: AND not exists (SELECT 'Y'
998: FROM AMW_OPINIONS_V aov
999: WHERE aov.object_name = 'AMW_ORG_PROCESS'
1000: AND aov.opinion_type_code = 'CERTIFICATION'

Line 1013: AND aes.organization_id = fnd_profile.value('AMW_GLOBAL_ORG_ID')

1009: FROM (SELECT distinct aes.organization_id, aes.process_id
1010: FROM AMW_EXECUTION_SCOPE aes, AMW_OPINIONS_V aov
1011: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1012: AND aes.entity_id = p_certification_id
1013: AND aes.organization_id = fnd_profile.value('AMW_GLOBAL_ORG_ID')
1014: AND aes.level_id > 3
1015: AND aov.object_name = 'AMW_ORG_PROCESS'
1016: AND aov.opinion_type_code = 'CERTIFICATION'
1017: AND aov.pk3_value = aes.organization_id

Line 1029: AND aes.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)

1025: FROM AMW_EXECUTION_SCOPE aes
1026: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1027: AND aes.entity_id = p_certification_id
1028: AND aes.level_id > 3
1029: AND aes.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
1030: AND not exists (SELECT 'Y'
1031: FROM AMW_OPINIONS_V aov
1032: WHERE aov.object_name = 'AMW_ORG_PROCESS'
1033: AND aov.opinion_type_code = 'CERTIFICATION'

Line 1044: AND aes.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)

1040: FROM (SELECT aes.organization_id, aes.process_id
1041: FROM AMW_EXECUTION_SCOPE aes, AMW_OPINIONS_V aov
1042: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1043: AND aes.entity_id = p_certification_id
1044: AND aes.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
1045: AND aes.level_id > 3
1046: AND aov.object_name = 'AMW_ORG_PROCESS'
1047: AND aov.opinion_type_code = 'CERTIFICATION'
1048: AND aov.pk3_value = aes.organization_id

Line 1059: AND aes.organization_id = fnd_profile.value('AMW_GLOBAL_ORG_ID')

1055: FROM amw_execution_scope aes,amw_opinions_v aov
1056: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1057: AND aes.entity_id = p_certification_id
1058: AND aes.level_id > 3
1059: AND aes.organization_id = fnd_profile.value('AMW_GLOBAL_ORG_ID')
1060: AND aov.object_name = 'AMW_ORG_PROCESS'
1061: AND aov.opinion_type_code = 'EVALUATION'
1062: AND aov.pk3_value = aes.organization_id
1063: AND aov.pk1_value = aes.process_id

Line 1078: AND aes.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)

1074: FROM amw_execution_scope aes,amw_opinions_v aov
1075: WHERE aes.entity_type = 'BUSIPROC_CERTIFICATION'
1076: AND aes.entity_id = p_certification_id
1077: AND aes.level_id > 3
1078: AND aes.organization_id <> NVL(fnd_profile.value('AMW_GLOBAL_ORG_ID'),-999)
1079: AND aov.object_name = 'AMW_ORG_PROCESS'
1080: AND aov.opinion_type_code = 'EVALUATION'
1081: AND aov.pk3_value = aes.organization_id
1082: AND aov.pk1_value = aes.process_id