DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on FND_PROFILE

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 := CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spPlanScope');
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 := CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spPlanScope');
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 := CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spPlanScope');
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(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 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(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 0) / (24 * 60);
50: g_uom_hours VARCHAR2(60):= fnd_profile.value('CSF_UOM_HOURS');

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(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 0) / (24 * 60);
50: g_uom_hours VARCHAR2(60):= fnd_profile.value('CSF_UOM_HOURS');
51:
52: TYPE number_tbl_type IS TABLE OF NUMBER

Line 50: g_uom_hours VARCHAR2(60):= fnd_profile.value('CSF_UOM_HOURS');

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(CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spMaxOvertime'), 0) / (24 * 60);
50: g_uom_hours VARCHAR2(60):= fnd_profile.value('CSF_UOM_HOURS');
51:
52: TYPE number_tbl_type IS TABLE OF NUMBER
53: INDEX BY BINARY_INTEGER;
54:

Line 414: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);

410: l_close_status_id NUMBER;
411: l_valid_statuses VARCHAR2 (2000);
412: l_valid_status BOOLEAN := FALSE;
413: l_update_schedulable_task VARCHAR2(3);
414: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);
415: BEGIN
416: -- Initialize API return status to success
417: x_return_status := fnd_api.g_ret_sts_success;
418:

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

426:
427: -- Before a Task can be closed, there are some checks that needs to be done
428:
429: -- Check whether the State Transition is valid.
430: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
431: IF validate_state_transition ('TASK_STATUS', l_old_status_id, l_close_status_id) = fnd_api.g_false THEN
432: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_old_status_id);
433: IF l_valid_statuses IS NULL THEN
434: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');

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

441: RAISE fnd_api.g_exc_error;
442: END IF;
443:
444: -- Check whether the Assignments and the associated Debriefs have been closed
445: l_update_schedulable_task := NVL(fnd_profile.value('CSFW_UPD_SCHEDULABLE'), 'NO');
446: -- added an if codetion for task closure for the bug 8282570
447: if nvl(l_task_closure,'N') ='Y'
448: then
449: if nvl(l_update_schedulable_task,'NO') = 'NO'

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

751:
752: -- Initialize API return status to success
753: x_return_status := fnd_api.g_ret_sts_success;
754:
755: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
756: update_task_status (
757: p_api_version => 1.0
758: , x_return_status => x_return_status
759: , x_msg_count => x_msg_count

Line 1303: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);

1299: AND ts.task_status_id = ta.assignment_status_id;
1300:
1301: l_task_status_id NUMBER;
1302: l_task_ovn NUMBER;
1303: l_task_closure Varchar2(3) := fnd_profile.value_specific('CSF: Enforce_Task_Closure', fnd_global.user_id);
1304: BEGIN
1305: x_return_status := fnd_api.g_ret_sts_success;
1306:
1307: IF p_new_sts_cancelled_flag = 'Y' THEN

Line 2100: l_auto_acc_hrs := fnd_profile.value('CSF_AUTO_POPULATE_ACCESS_HRS');

2096: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2097: RAISE fnd_api.g_exc_unexpected_error;
2098: END IF;
2099: END IF;
2100: l_auto_acc_hrs := fnd_profile.value('CSF_AUTO_POPULATE_ACCESS_HRS');
2101: /*
2102: 1) Check if access hours setups are done for the location
2103: 2) Else, check if access hours setups are done for the ct + ct site combination
2104: 3) Else, check if access hours setups are done for the ct

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

4864: , x_phone OUT NOCOPY VARCHAR2
4865: , x_phone_ext OUT NOCOPY VARCHAR2
4866: , x_email_address OUT NOCOPY VARCHAR2
4867: ) IS
4868: l_contact_source CONSTANT VARCHAR2(10) := fnd_profile.value('CSF_DFLT_SOURCE_FOR_CONTACT');
4869:
4870: l_contact_type cs_sr_contact_points_v.contact_type%TYPE;
4871: l_contact_point_id cs_sr_contact_points_v.contact_point_id%TYPE;
4872: l_party_id cs_sr_contact_points_v.party_id%TYPE;

Line 5732: l_auto_acc_hrs := fnd_profile.value('CSF_AUTO_POPULATE_ACCESS_HRS');

5728: --end of cursor added access hours validation
5729:
5730: BEGIN
5731: x_return_status := fnd_api.g_ret_sts_success;
5732: l_auto_acc_hrs := fnd_profile.value('CSF_AUTO_POPULATE_ACCESS_HRS');
5733: /*
5734: 1) Check if access hours setups are done for the location
5735: 2) Else, check if access hours setups are done for the ct + ct site combination
5736: 3) Else, check if access hours setups are done for the ct