APPS.CSF_RESOURCE_PUB dependencies on FND_PROFILE

Line 9: g_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');

5: g_assign_doc_type CONSTANT VARCHAR2(2) := 'SR';
6: g_earth_radius CONSTANT NUMBER := 6378137;
7: g_pi CONSTANT NUMBER := 2 * ACOS(0);
8: g_res_add_prof VARCHAR2(200);
9: g_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
10:
11: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
12:
13:

Line 11: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);

7: g_pi CONSTANT NUMBER := 2 * ACOS(0);
8: g_res_add_prof VARCHAR2(200);
9: g_debug VARCHAR2(1):= NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
10:
11: g_debug_level NUMBER := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
12:
13:
14: TYPE qualifier_info_rec_type IS RECORD(
15: qual_usg_id jtf_seeded_qual_usgs_v.qual_usg_id%TYPE

Line 757: l_levelmatch CONSTANT NUMBER := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);

753: , p_resource_id IN NUMBER DEFAULT NULL
754: , p_resource_type IN VARCHAR2 DEFAULT NULL
755: , x_skilled_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
756: ) IS
757: l_levelmatch CONSTANT NUMBER := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);
758: j PLS_INTEGER;
759:
760: CURSOR c_resource_plan_window IS
761: SELECT rs.resource_id

Line 818: AND category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET'))

814: AND ts.skill_type_id = rs.skill_type_id
815: AND EXISTS (SELECT 1
816: FROM mtl_item_categories mic
817: WHERE mic.category_id = rs.skill_id
818: AND category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET'))
819: /* OR ts.skill_type_id = 2
820: AND rs.skill_type_id = 3
821: AND NOT EXISTS (SELECT 1
822: FROM csf_required_skills_b ts2

Line 830: AND mic.category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET')

826: AND ts2.has_skill_id = ts.has_skill_id
827: AND ts2.required_skill_id <> ts.required_skill_id
828: AND ts2.skill_type_id = 3
829: AND mic.inventory_item_id = ts.skill_id
830: AND mic.category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET')
831: AND mic.category_id = ts2.skill_id)
832: AND NOT EXISTS (SELECT 1
833: FROM csf_resource_skills_b rs2
834: WHERE TRUNC(rs2.start_date_active) < p_end

Line 842: AND mic.category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET')

838: AND rs2.skill_type_id = ts.skill_type_id)
839: AND EXISTS (SELECT category_id
840: FROM mtl_item_categories mic
841: WHERE mic.inventory_item_id = ts.skill_id
842: AND mic.category_set_id = fnd_profile.VALUE('CS_SR_DEFAULT_CATEGORY_SET')
843: AND mic.category_id = rs.skill_id) */
844: )
845: GROUP BY rs.resource_id, rs.resource_type) rs
846: , (

Line 2416: fnd_profile.get('SERVER_TIMEZONE_ID', l_dest_tz_id);

2412: -- Initialize API return status to success
2413: x_return_status := fnd_api.g_ret_sts_success;
2414:
2415: -- Start actual processing
2416: fnd_profile.get('SERVER_TIMEZONE_ID', l_dest_tz_id);
2417:
2418: OPEN c_resource;
2419: FETCH c_resource INTO l_source_tz_id;
2420: CLOSE c_resource;