APPS.OZF_SD_REQUEST_PUB dependencies on FND_PROFILE

Line 921: p_SDR_hdr_rec.request_currency_code :=FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY');

917: RETURN;
918: END IF;
919: ELSE
920: --//Get currency code from profile :JTF_PROFILE_DEFAULT_CURRENCY
921: p_SDR_hdr_rec.request_currency_code :=FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY');
922:
923: IF p_SDR_hdr_rec.request_currency_code IS NULL THEN
924:
925: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 2164: l_SDR_hdr_rec.request_basis := FND_PROFILE.value('OZF_SD_REQUEST_BASED');

2160: OZF_UTILITY_PVT.debug_message('Inside INSERT HEADER RECORD Procedure ');
2161: END IF;
2162:
2163: IF l_SDR_hdr_rec.request_basis IS NULL THEN
2164: l_SDR_hdr_rec.request_basis := FND_PROFILE.value('OZF_SD_REQUEST_BASED');
2165: END IF;
2166:
2167: OPEN c_reqest_header_seq;
2168: FETCH c_reqest_header_seq INTO l_req_hdr_seq;

Line 3384: fnd_profile_options fpo,

3380:
3381: CURSOR c_admin_check(p_resource_id IN NUMBER)IS
3382: SELECT jrgm.group_member_id
3383: FROM jtf_rs_group_members jrgm,
3384: fnd_profile_options fpo,
3385: fnd_profile_option_values fpov
3386: WHERE jrgm.resource_id = p_resource_id
3387: AND fpo. profile_option_name = 'AMS_ADMIN_GROUP'
3388: AND fpo.profile_option_id = fpov.profile_option_id

Line 3385: fnd_profile_option_values fpov

3381: CURSOR c_admin_check(p_resource_id IN NUMBER)IS
3382: SELECT jrgm.group_member_id
3383: FROM jtf_rs_group_members jrgm,
3384: fnd_profile_options fpo,
3385: fnd_profile_option_values fpov
3386: WHERE jrgm.resource_id = p_resource_id
3387: AND fpo. profile_option_name = 'AMS_ADMIN_GROUP'
3388: AND fpo.profile_option_id = fpov.profile_option_id
3389: AND jrgm.group_id = fpov.profile_option_value;