DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on FND_PROFILE

Line 787: NVL(p_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID')), -- MOAC Changes - get from HR profile

783: VALUES
784: (l_resource_list_id ,
785: --p_resource_list_name,
786: l_resource_list_name, --Bug 3501039
787: NVL(p_business_group_id,fnd_profile.value('PER_BUSINESS_GROUP_ID')), -- MOAC Changes - get from HR profile
788: --NVL(p_description,p_resource_list_name),
789: NVL(p_description,l_resource_list_name), --Bug 3501039
790: NVL(p_public_flag,'Y'),
791: l_resource_type_id,

Line 3393: , NVL(X_business_group_id, fnd_profile.value('PER_BUSINESS_GROUP_ID'))

3389: , record_version_number )
3390: SELECT
3391: X_resource_list_id
3392: , eachRL.name
3393: , NVL(X_business_group_id, fnd_profile.value('PER_BUSINESS_GROUP_ID'))
3394: , eachRL.description
3395: , eachRL.public_flag
3396: , eachRL.group_resource_type_id
3397: , eachRL.start_date_active

Line 3416: fnd_profile.value('PER_BUSINESS_GROUP_ID'))

3412: SELECT NULL
3413: FROM pa_resource_lists rl
3414: WHERE business_group_id =
3415: NVL(X_business_group_id,
3416: fnd_profile.value('PER_BUSINESS_GROUP_ID'))
3417: AND rl.name = eachRL.name );
3418:
3419: --Adding to TL
3420: INSERT into pa_resource_lists_tl (