APPS.JTF_TASKS_PVT dependencies on JTF_TASK_RSC_REQS

Line 1118: l_res_type jtf_task_rsc_reqs.resource_type_code%TYPE;

1114: l_entity jtf_tasks_b.entity%TYPE := p_entity;
1115: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE := p_free_busy_type;
1116: l_open_flag VARCHAR2(1);
1117: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE := p_task_confirmation_status;
1118: l_res_type jtf_task_rsc_reqs.resource_type_code%TYPE;
1119: l_req_units jtf_task_rsc_reqs.required_units%TYPE;
1120: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE;
1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
1122:

Line 1119: l_req_units jtf_task_rsc_reqs.required_units%TYPE;

1115: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE := p_free_busy_type;
1116: l_open_flag VARCHAR2(1);
1117: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE := p_task_confirmation_status;
1118: l_res_type jtf_task_rsc_reqs.resource_type_code%TYPE;
1119: l_req_units jtf_task_rsc_reqs.required_units%TYPE;
1120: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE;
1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
1122:
1123: CURSOR c_type_reqs IS

Line 1120: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE;

1116: l_open_flag VARCHAR2(1);
1117: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE := p_task_confirmation_status;
1118: l_res_type jtf_task_rsc_reqs.resource_type_code%TYPE;
1119: l_req_units jtf_task_rsc_reqs.required_units%TYPE;
1120: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE;
1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
1122:
1123: CURSOR c_type_reqs IS
1124: SELECT resource_type_code, required_units, enabled_flag

Line 1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;

1117: l_task_confirmation_status jtf_tasks_b.task_confirmation_status%TYPE := p_task_confirmation_status;
1118: l_res_type jtf_task_rsc_reqs.resource_type_code%TYPE;
1119: l_req_units jtf_task_rsc_reqs.required_units%TYPE;
1120: l_enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE;
1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
1122:
1123: CURSOR c_type_reqs IS
1124: SELECT resource_type_code, required_units, enabled_flag
1125: FROM jtf_task_rsc_reqs

Line 1125: FROM jtf_task_rsc_reqs

1121: l_resource_req_id jtf_task_rsc_reqs.resource_req_id%TYPE;
1122:
1123: CURSOR c_type_reqs IS
1124: SELECT resource_type_code, required_units, enabled_flag
1125: FROM jtf_task_rsc_reqs
1126: WHERE task_type_id = l_task_type_id;
1127:
1128: CURSOR c_jtf_tasks IS
1129: SELECT 'Y'

Line 4432: FROM jtf_task_rsc_reqs

4428:
4429: CURSOR c_rsc_reqs IS
4430: SELECT resource_req_id
4431: , object_version_number
4432: FROM jtf_task_rsc_reqs
4433: WHERE task_id = l_task_id;
4434:
4435: CURSOR c_assignments IS
4436: SELECT task_assignment_id