DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on FND_PROFILE

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

623: , p_resource_id IN NUMBER DEFAULT NULL
624: , p_resource_type IN VARCHAR2 DEFAULT NULL
625: , x_skilled_res_tbl OUT NOCOPY jtf_assign_pub.assignresources_tbl_type
626: ) IS
627: l_levelmatch CONSTANT NUMBER := NVL(fnd_profile.VALUE('CSF_SKILL_LEVEL_MATCH'), 2);
628: j PLS_INTEGER;
629:
630: CURSOR c_resource_plan_window IS
631: SELECT rs.resource_id

Line 867: l_max_resources := fnd_profile.VALUE('MAXNRSELECTEDRES');

863: j PLS_INTEGER;
864: cnt PLS_INTEGER;
865: BEGIN
866: -- Get the maximum number of allowed Resources
867: l_max_resources := fnd_profile.VALUE('MAXNRSELECTEDRES');
868:
869: -- Validate retrieved maximum value
870: IF NVL(l_max_resources, 0) <= 0 THEN
871: l_max_resources := p_res_tbl.COUNT;

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

1868: -- Initialize API return status to success
1869: x_return_status := fnd_api.g_ret_sts_success;
1870:
1871: -- Start actual processing
1872: fnd_profile.get('SERVER_TIMEZONE_ID', l_dest_tz_id);
1873:
1874: OPEN c_resource;
1875: FETCH c_resource INTO l_source_tz_id;
1876: CLOSE c_resource;