DBA Data[Home] [Help]

APPS.PA_UTILS dependencies on FND_PROFILE

Line 1039: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)

1035: into l_job_id
1036: from per_jobs_v V
1037: where job_id = X_job_id
1038: and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
1039: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)
1040: OR
1041: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'
1042: )
1043: and date_from <= X_date

Line 1052: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)

1048: from per_jobs_v V
1049: where name = X_job_name
1050: AND V.BUSINESS_GROUP_ID = NVL(X_Business_Group_Id,V.BUSINESS_GROUP_ID)
1051: /* and ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N' AND
1052: fnd_profile.value('PER_BUSINESS_GROUP_ID') = V.BUSINESS_GROUP_ID)
1053: OR
1054: PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y'
1055: )*/
1056: and date_from <= X_date

Line 1214: if (fnd_profile.value('PA_PROJECT_COSTING_INSTALLED') = 'Y') then

1210: IS
1211: x_pa_costing_installed VARCHAR2(2);
1212: BEGIN
1213:
1214: if (fnd_profile.value('PA_PROJECT_COSTING_INSTALLED') = 'Y') then
1215: x_pa_costing_installed := 'Y';
1216: else
1217: x_pa_costing_installed := 'N';
1218: end if;

Line 1574: -- FND_PROFILE.GET ('ORG_ID', l_id);

1570: */
1571: ELSE
1572:
1573: -- start 12i MOAC changes
1574: -- FND_PROFILE.GET ('ORG_ID', l_id);
1575: l_id := Pa_Moac_Utils.Get_Current_Org_Id;
1576: -- end 12i MOAC changes
1577:
1578: /* Bug 2657833 - UTF8 change Impact, Using substr for organization name,

Line 1671: RETURN(FND_PROFILE.VALUE_WNPS('HR_CROSS_BUSINESS_GROUP'));

1667: IS
1668:
1669: BEGIN
1670:
1671: RETURN(FND_PROFILE.VALUE_WNPS('HR_CROSS_BUSINESS_GROUP'));
1672:
1673: EXCEPTION
1674: WHEN OTHERS THEN
1675: RAISE ;