APPS.OZF_SD_REQUEST_PUB dependencies on FND_PROFILE

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

1115: RETURN;
1116: END IF;
1117: ELSE
1118: --//Get currency code from profile :JTF_PROFILE_DEFAULT_CURRENCY
1119: p_SDR_hdr_rec.request_currency_code :=FND_PROFILE.value('JTF_PROFILE_DEFAULT_CURRENCY');
1120:
1121: IF p_SDR_hdr_rec.request_currency_code IS NULL THEN
1122:
1123: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

2691: OZF_UTILITY_PVT.debug_message('Inside INSERT HEADER RECORD Procedure ');
2692: END IF;
2693:
2694: IF l_SDR_hdr_rec.request_basis IS NULL THEN
2695: l_SDR_hdr_rec.request_basis := FND_PROFILE.value('OZF_SD_REQUEST_BASED');
2696: END IF;
2697:
2698: OPEN c_reqest_header_seq;
2699: FETCH c_reqest_header_seq INTO l_req_hdr_seq;

Line 3959: AND jrgm.group_id = to_number(fnd_profile.value('AMS_ADMIN_GROUP'));

3955: SELECT jrgm.group_member_id
3956: FROM jtf_rs_group_members jrgm
3957: WHERE jrgm.resource_id = p_resource_id
3958: AND jrgm.delete_flag = 'N'
3959: AND jrgm.group_id = to_number(fnd_profile.value('AMS_ADMIN_GROUP'));
3960:
3961: CURSOR c_sd_access(p_request_header_id IN NUMBER,p_user_id IN NUMBER)IS
3962: SELECT owner_flag,
3963: approver_flag