DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on FND_PROFILE

Line 40: g_plan_scope CONSTANT NUMBER := fnd_profile.VALUE ('PLANSCOPE');

36: g_cancelled_bitcode CONSTANT NUMBER := 448; -- 111000000
37: g_start_bitcode CONSTANT NUMBER := 511; -- 111111111
38:
39: -- Default Values from the Profiles
40: g_plan_scope CONSTANT NUMBER := fnd_profile.VALUE ('PLANSCOPE');
41:
42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');
43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');

Line 42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');

38:
39: -- Default Values from the Profiles
40: g_plan_scope CONSTANT NUMBER := fnd_profile.VALUE ('PLANSCOPE');
41:
42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');
43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');
45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');

Line 43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');

39: -- Default Values from the Profiles
40: g_plan_scope CONSTANT NUMBER := fnd_profile.VALUE ('PLANSCOPE');
41:
42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');
43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');
45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');
47:

Line 44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');

40: g_plan_scope CONSTANT NUMBER := fnd_profile.VALUE ('PLANSCOPE');
41:
42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');
43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');
45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');
47:
48: g_default_uom CONSTANT VARCHAR2(3) := fnd_profile.value('CSF_DEFAULT_EFFORT_UOM');

Line 45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');

41:
42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');
43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');
45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');
47:
48: g_default_uom CONSTANT VARCHAR2(3) := fnd_profile.value('CSF_DEFAULT_EFFORT_UOM');
49: g_overtime CONSTANT NUMBER := NVL(fnd_profile.value('MAXOVERTIME'), 0) / (24 * 60);

Line 46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');

42: g_inplanning CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_INPLANNING_STATUS');
43: g_assigned CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');
45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');
47:
48: g_default_uom CONSTANT VARCHAR2(3) := fnd_profile.value('CSF_DEFAULT_EFFORT_UOM');
49: g_overtime CONSTANT NUMBER := NVL(fnd_profile.value('MAXOVERTIME'), 0) / (24 * 60);
50:

Line 48: g_default_uom CONSTANT VARCHAR2(3) := fnd_profile.value('CSF_DEFAULT_EFFORT_UOM');

44: g_working CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS');
45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');
47:
48: g_default_uom CONSTANT VARCHAR2(3) := fnd_profile.value('CSF_DEFAULT_EFFORT_UOM');
49: g_overtime CONSTANT NUMBER := NVL(fnd_profile.value('MAXOVERTIME'), 0) / (24 * 60);
50:
51: TYPE number_tbl_type IS TABLE OF NUMBER
52: INDEX BY BINARY_INTEGER;

Line 49: g_overtime CONSTANT NUMBER := NVL(fnd_profile.value('MAXOVERTIME'), 0) / (24 * 60);

45: g_cancelled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS');
46: g_unscheduled CONSTANT NUMBER := fnd_profile.value('CSF_DEFAULT_TASK_UNSCHEDULED_STATUS');
47:
48: g_default_uom CONSTANT VARCHAR2(3) := fnd_profile.value('CSF_DEFAULT_EFFORT_UOM');
49: g_overtime CONSTANT NUMBER := NVL(fnd_profile.value('MAXOVERTIME'), 0) / (24 * 60);
50:
51: TYPE number_tbl_type IS TABLE OF NUMBER
52: INDEX BY BINARY_INTEGER;
53:

Line 378: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');

374:
375: -- Before a Task can be closed, there are some checks that needs to be done
376:
377: -- Check whether the State Transition is valid.
378: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
379: IF validate_state_transition ('TASK_STATUS', l_old_status_id, l_close_status_id) = fnd_api.g_false THEN
380: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_old_status_id);
381: IF l_valid_statuses IS NULL THEN
382: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');

Line 393: l_update_schedulable_task := NVL(fnd_profile.value('CSFW_UPD_SCHEDULABLE'), 'NO');

389: RAISE fnd_api.g_exc_error;
390: END IF;
391:
392: -- Check whether the Assignments and the associated Debriefs have been closed
393: l_update_schedulable_task := NVL(fnd_profile.value('CSFW_UPD_SCHEDULABLE'), 'NO');
394: FOR v_task_assignment IN c_task_assignments LOOP
395:
396: -- Check whether the Task Assignment is still Open.
397: IF v_task_assignment.closed_flag = 'N'

Line 672: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');

668:
669: -- Initialize API return status to success
670: x_return_status := fnd_api.g_ret_sts_success;
671:
672: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
673: update_task_status (
674: p_api_version => 1.0
675: , x_return_status => x_return_status
676: , x_msg_count => x_msg_count

Line 1650: OR l_planned_effort_minutes > fnd_profile.value('CSR_DEFAULT_SHIFT_DURATION')

1646:
1647: l_task_number := l_task_info.task_number;
1648:
1649: IF l_task_info.task_split_flag IS NOT NULL
1650: OR l_planned_effort_minutes > fnd_profile.value('CSR_DEFAULT_SHIFT_DURATION')
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');
1653: fnd_message.set_token('TASK_NUMBER',l_task_number);
1654: fnd_msg_pub.add;

Line 4220: l_contact_source CONSTANT VARCHAR2(10) := fnd_profile.value('CSF_DFLT_SOURCE_FOR_CONTACT');

4216: , x_phone OUT NOCOPY VARCHAR2
4217: , x_phone_ext OUT NOCOPY VARCHAR2
4218: , x_email_address OUT NOCOPY VARCHAR2
4219: ) IS
4220: l_contact_source CONSTANT VARCHAR2(10) := fnd_profile.value('CSF_DFLT_SOURCE_FOR_CONTACT');
4221:
4222: l_contact_type cs_sr_contact_points_v.contact_type%TYPE;
4223: l_contact_point_id cs_sr_contact_points_v.contact_point_id%TYPE;
4224: l_party_id cs_sr_contact_points_v.party_id%TYPE;