APPS.PA_PLANNING_RESOURCE_UTILS dependencies on FND_PROFILE

Line 4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY PA_PLANNING_RESOURCE_UTILS AS
2: /* $Header: PARPRLUB.pls 120.29 2012/02/01 13:05:24 djambhek ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: g_module_name VARCHAR2(100) := 'pa.plsql.PA_PLANNING_RESOURCE_UTILS';
6: g_job_group_id NUMBER;
7: /********************************************************
8: * Check whether any planning resources or class defaults for the spread

Line 793: fnd_profile.value('PER_BUSINESS_GROUP_ID') =

789: --sysdate BETWEEN effective_start_date AND effective_end_date
790: (current_employee_flag = 'Y' or CURRENT_NPW_FLAG = 'Y')
791: AND ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'Y') OR
792: ((PA_CROSS_BUSINESS_GRP.IsCrossBGProfile = 'N') AND
793: fnd_profile.value('PER_BUSINESS_GROUP_ID') =
794: BUSINESS_GROUP_ID))
795: AND person_id = l_person_id
796: and rownum = 1;
797: EXCEPTION

Line 2975: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)

2971: Per_People_X
2972: Where
2973: Person_Id = P_Person_Id
2974: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2975: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
2976: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2977:
2978: Cursor c_Job (P_Job_Id In Number) Is
2979: Select

Line 2986: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )

2982: Per_Jobs
2983: Where
2984: Job_Id = P_Job_Id
2985: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
2986: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Per_Jobs.Business_Group_Id )
2987: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
2988:
2989: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
2990: Select

Line 4273: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)

4269: Per_People_X
4270: Where
4271: Person_Id = P_Person_Id
4272: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4273: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id)
4274: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4275:
4276: Cursor c_Job (P_Job_Id In Number) Is
4277: Select

Line 4284: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id )

4280: Per_Jobs
4281: Where
4282: Job_Id = P_Job_Id
4283: And ( (Pa_Cross_Business_Grp.IsCrossBGProfile = 'N' AND
4284: Fnd_Profile.Value('PER_BUSINESS_GROUP_ID') = Business_Group_Id )
4285: OR Pa_Cross_Business_Grp.IsCrossBGProfile = 'Y');
4286:
4287: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
4288: Select