eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_ASSIGNMENTS_PVT dependencies on JTF_TASK_ALL_ASSIGNMENTS

Line 4: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';

1: PACKAGE BODY jtf_task_assignments_pvt AS
2: /* $Header: jtfvtkab.pls 120.5 2011/03/31 11:50:40 abhishjj ship $ */
3:
4: g_free_busy_type CONSTANT jtf_task_all_assignments.free_busy_type%TYPE := 'FREE';
5:
6: -- Internal procedures used for implicit booking
7: -- It populates booking date by using task calendar date
8: --

Line 30: FROM JTF_TASK_ALL_ASSIGNMENTS

26: l_actual_start_date DATE := NVL(p_actual_start_date,to_date('01-01-1900','dd-MM-RRRR'));
27: l_actual_end_date DATE := NVL(p_actual_end_date,to_date(to_char(FND_API.G_MISS_DATE,'dd-MM-RRRR'),'dd-MM-RRRR'));
28: v_count NUMBER := 0;
29: CURSOR C_TASK_ASSIGNMENT IS SELECT COUNT(TASK_ASSIGNMENT_ID)
30: FROM JTF_TASK_ALL_ASSIGNMENTS
31: WHERE TASK_ID = p_task_id
32: AND RESOURCE_ID = p_resource_id
33: AND RESOURCE_TYPE_CODE = p_resource_type_code
34: AND ASSIGNEE_ROLE = P_ASSIGNEE_ROLE

Line 264: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

260: l_api_name CONSTANT VARCHAR(30)
261: := 'CREATE_TASK_ASSIGNMENTS';
262: l_return_status VARCHAR2(1)
263: := fnd_api.g_ret_sts_success;
264: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
265: l_task_id jtf_tasks_b.task_id%TYPE
266: := p_task_id;
267: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
268: := p_resource_type_code;

Line 267: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE

263: := fnd_api.g_ret_sts_success;
264: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
265: l_task_id jtf_tasks_b.task_id%TYPE
266: := p_task_id;
267: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
268: := p_resource_type_code;
269: l_resource_id NUMBER
270: := p_resource_id;
271: l_act_eff NUMBER

Line 277: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

273: l_act_eff_uom VARCHAR2(3)
274: := p_actual_effort_uom;
275: l_schedule_flag VARCHAR2(1)
276: := p_schedule_flag;
277: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
278: := p_alarm_type_code;
279: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
280: := p_alarm_contact;
281: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

Line 279: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

275: l_schedule_flag VARCHAR2(1)
276: := p_schedule_flag;
277: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
278: := p_alarm_type_code;
279: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
280: := p_alarm_contact;
281: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
282: := p_sched_travel_distance;
283: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

Line 281: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

277: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
278: := p_alarm_type_code;
279: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
280: := p_alarm_contact;
281: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
282: := p_sched_travel_distance;
283: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
284: := p_sched_travel_duration;
285: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

Line 283: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

279: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
280: := p_alarm_contact;
281: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
282: := p_sched_travel_distance;
283: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
284: := p_sched_travel_duration;
285: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
286: := p_sched_travel_duration_uom;
287: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

Line 285: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

281: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
282: := p_sched_travel_distance;
283: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
284: := p_sched_travel_duration;
285: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
286: := p_sched_travel_duration_uom;
287: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
288: := p_actual_travel_distance;
289: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

Line 287: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

283: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
284: := p_sched_travel_duration;
285: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
286: := p_sched_travel_duration_uom;
287: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
288: := p_actual_travel_distance;
289: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
290: := p_actual_travel_duration;
291: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

Line 289: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

285: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
286: := p_sched_travel_duration_uom;
287: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
288: := p_actual_travel_distance;
289: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
290: := p_actual_travel_duration;
291: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
292: := p_actual_travel_duration_uom;
293: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

Line 291: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

287: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
288: := p_actual_travel_distance;
289: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
290: := p_actual_travel_duration;
291: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
292: := p_actual_travel_duration_uom;
293: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
294: := p_actual_start_date;
295: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

Line 293: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

289: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
290: := p_actual_travel_duration;
291: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
292: := p_actual_travel_duration_uom;
293: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
294: := p_actual_start_date;
295: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
296: := p_actual_end_date;
297: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

Line 295: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

291: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
292: := p_actual_travel_duration_uom;
293: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
294: := p_actual_start_date;
295: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
296: := p_actual_end_date;
297: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
298: := p_palm_flag;
299: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

Line 297: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

293: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
294: := p_actual_start_date;
295: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
296: := p_actual_end_date;
297: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
298: := p_palm_flag;
299: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
300: := p_wince_flag;
301: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

Line 299: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

295: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
296: := p_actual_end_date;
297: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
298: := p_palm_flag;
299: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
300: := p_wince_flag;
301: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
302: := p_laptop_flag;
303: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

Line 301: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

297: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
298: := p_palm_flag;
299: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
300: := p_wince_flag;
301: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
302: := p_laptop_flag;
303: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
304: := p_device1_flag;
305: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

Line 303: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

299: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
300: := p_wince_flag;
301: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
302: := p_laptop_flag;
303: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
304: := p_device1_flag;
305: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
306: := p_device2_flag;
307: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

Line 305: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

301: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
302: := p_laptop_flag;
303: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
304: := p_device1_flag;
305: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
306: := p_device2_flag;
307: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
308: := p_device3_flag;
309: l_msg_data VARCHAR2(2000);

Line 307: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

303: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
304: := p_device1_flag;
305: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
306: := p_device2_flag;
307: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
308: := p_device3_flag;
309: l_msg_data VARCHAR2(2000);
310: l_msg_count NUMBER;
311: x CHAR;

Line 313: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE

309: l_msg_data VARCHAR2(2000);
310: l_msg_count NUMBER;
311: x CHAR;
312: l_rowid ROWID;
313: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
314: := p_resource_territory_id;
315: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
316: := p_assignment_status_id;
317: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

Line 315: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE

311: x CHAR;
312: l_rowid ROWID;
313: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
314: := p_resource_territory_id;
315: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
316: := p_assignment_status_id;
317: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
318: := p_shift_construct_id;
319: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

Line 317: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

313: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
314: := p_resource_territory_id;
315: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
316: := p_assignment_status_id;
317: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
318: := p_shift_construct_id;
319: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
320: := p_assignee_role;
321: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

Line 319: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

315: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
316: := p_assignment_status_id;
317: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
318: := p_shift_construct_id;
319: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
320: := p_assignee_role;
321: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
322: := p_show_on_calendar;
323: l_category_id jtf_task_all_assignments.category_id%TYPE

Line 321: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

317: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
318: := p_shift_construct_id;
319: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
320: := p_assignee_role;
321: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
322: := p_show_on_calendar;
323: l_category_id jtf_task_all_assignments.category_id%TYPE
324: := p_category_id;
325: l_enable_workflow VARCHAR2(1) := p_enable_workflow;

Line 323: l_category_id jtf_task_all_assignments.category_id%TYPE

319: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
320: := p_assignee_role;
321: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
322: := p_show_on_calendar;
323: l_category_id jtf_task_all_assignments.category_id%TYPE
324: := p_category_id;
325: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
326: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
327:

Line 329: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

325: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
326: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
327:
328: -- Simplex Changes ..
329: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
330: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
331: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
332: := p_free_busy_type;
333:

Line 330: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;

326: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
327:
328: -- Simplex Changes ..
329: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
330: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
331: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
332: := p_free_busy_type;
333:
334: CURSOR ra_cur1 (l_rowid IN ROWID)

Line 331: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE

327:
328: -- Simplex Changes ..
329: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
330: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
331: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
332: := p_free_busy_type;
333:
334: CURSOR ra_cur1 (l_rowid IN ROWID)
335: IS

Line 337: FROM jtf_task_all_assignments

333:
334: CURSOR ra_cur1 (l_rowid IN ROWID)
335: IS
336: SELECT 1
337: FROM jtf_task_all_assignments
338: WHERE ROWID = l_rowid;
339:
340: ------------------------------------------
341: -- For XP

Line 1379: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE

1375: l_api_name CONSTANT VARCHAR(30)
1376: := 'Update_Task_Assignment';
1377: l_return_status VARCHAR2(1)
1378: := fnd_api.g_ret_sts_success;
1379: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1380: := p_task_assignment_id;
1381: l_task_id jtf_task_all_assignments.task_id%TYPE;
1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1383: := p_resource_type_code;

Line 1381: l_task_id jtf_task_all_assignments.task_id%TYPE;

1377: l_return_status VARCHAR2(1)
1378: := fnd_api.g_ret_sts_success;
1379: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1380: := p_task_assignment_id;
1381: l_task_id jtf_task_all_assignments.task_id%TYPE;
1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1383: := p_resource_type_code;
1384: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1385: := p_resource_id;

Line 1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE

1378: := fnd_api.g_ret_sts_success;
1379: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1380: := p_task_assignment_id;
1381: l_task_id jtf_task_all_assignments.task_id%TYPE;
1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1383: := p_resource_type_code;
1384: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1385: := p_resource_id;
1386: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

Line 1384: l_resource_id jtf_task_all_assignments.resource_id%TYPE

1380: := p_task_assignment_id;
1381: l_task_id jtf_task_all_assignments.task_id%TYPE;
1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1383: := p_resource_type_code;
1384: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1385: := p_resource_id;
1386: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1387: := p_actual_effort;
1388: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

Line 1386: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

1382: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1383: := p_resource_type_code;
1384: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1385: := p_resource_id;
1386: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1387: := p_actual_effort;
1388: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1389: := p_actual_effort_uom;
1390: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

Line 1388: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

1384: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1385: := p_resource_id;
1386: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1387: := p_actual_effort;
1388: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1389: := p_actual_effort_uom;
1390: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1391: := p_schedule_flag;
1392: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

Line 1390: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

1386: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1387: := p_actual_effort;
1388: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1389: := p_actual_effort_uom;
1390: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1391: := p_schedule_flag;
1392: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1393: := p_alarm_type_code;
1394: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

Line 1392: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

1388: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1389: := p_actual_effort_uom;
1390: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1391: := p_schedule_flag;
1392: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1393: := p_alarm_type_code;
1394: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1395: := p_alarm_contact;
1396: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

Line 1394: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

1390: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1391: := p_schedule_flag;
1392: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1393: := p_alarm_type_code;
1394: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1395: := p_alarm_contact;
1396: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1397: := p_sched_travel_distance;
1398: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

Line 1396: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

1392: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1393: := p_alarm_type_code;
1394: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1395: := p_alarm_contact;
1396: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1397: := p_sched_travel_distance;
1398: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1399: := p_sched_travel_duration;
1400: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

Line 1398: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

1394: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1395: := p_alarm_contact;
1396: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1397: := p_sched_travel_distance;
1398: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1399: := p_sched_travel_duration;
1400: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1401: := p_sched_travel_duration_uom;
1402: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

Line 1400: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

1396: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1397: := p_sched_travel_distance;
1398: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1399: := p_sched_travel_duration;
1400: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1401: := p_sched_travel_duration_uom;
1402: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1403: := p_actual_travel_distance;
1404: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

Line 1402: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

1398: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1399: := p_sched_travel_duration;
1400: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1401: := p_sched_travel_duration_uom;
1402: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1403: := p_actual_travel_distance;
1404: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1405: := p_actual_travel_duration;
1406: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

Line 1404: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

1400: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1401: := p_sched_travel_duration_uom;
1402: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1403: := p_actual_travel_distance;
1404: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1405: := p_actual_travel_duration;
1406: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1407: := p_actual_travel_duration_uom;
1408: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

Line 1406: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

1402: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1403: := p_actual_travel_distance;
1404: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1405: := p_actual_travel_duration;
1406: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1407: := p_actual_travel_duration_uom;
1408: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1409: := p_actual_start_date;
1410: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

Line 1408: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

1404: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1405: := p_actual_travel_duration;
1406: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1407: := p_actual_travel_duration_uom;
1408: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1409: := p_actual_start_date;
1410: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1411: := p_actual_end_date;
1412: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

Line 1410: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

1406: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1407: := p_actual_travel_duration_uom;
1408: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1409: := p_actual_start_date;
1410: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1411: := p_actual_end_date;
1412: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1413: := p_palm_flag;
1414: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

Line 1412: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

1408: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1409: := p_actual_start_date;
1410: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1411: := p_actual_end_date;
1412: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1413: := p_palm_flag;
1414: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1415: := p_wince_flag;
1416: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

Line 1414: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

1410: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1411: := p_actual_end_date;
1412: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1413: := p_palm_flag;
1414: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1415: := p_wince_flag;
1416: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1417: := p_laptop_flag;
1418: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

Line 1416: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

1412: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1413: := p_palm_flag;
1414: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1415: := p_wince_flag;
1416: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1417: := p_laptop_flag;
1418: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1419: := p_device1_flag;
1420: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

Line 1418: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

1414: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1415: := p_wince_flag;
1416: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1417: := p_laptop_flag;
1418: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1419: := p_device1_flag;
1420: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1421: := p_device2_flag;
1422: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

Line 1420: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

1416: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1417: := p_laptop_flag;
1418: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1419: := p_device1_flag;
1420: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1421: := p_device2_flag;
1422: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
1423: := p_device3_flag;
1424: l_msg_data VARCHAR2(2000);

Line 1422: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

1418: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1419: := p_device1_flag;
1420: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1421: := p_device2_flag;
1422: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
1423: := p_device3_flag;
1424: l_msg_data VARCHAR2(2000);
1425: l_msg_count NUMBER;
1426: x CHAR;

Line 1428: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE

1424: l_msg_data VARCHAR2(2000);
1425: l_msg_count NUMBER;
1426: x CHAR;
1427: l_rowid ROWID;
1428: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1429: := p_assignment_status_id;
1430: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1431: := p_resource_territory_id;
1432: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

Line 1430: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE

1426: x CHAR;
1427: l_rowid ROWID;
1428: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1429: := p_assignment_status_id;
1430: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1431: := p_resource_territory_id;
1432: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1433: := p_shift_construct_id;
1434: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

Line 1432: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

1428: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1429: := p_assignment_status_id;
1430: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1431: := p_resource_territory_id;
1432: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1433: := p_shift_construct_id;
1434: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1435: := p_assignee_role;
1436: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

Line 1434: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

1430: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1431: := p_resource_territory_id;
1432: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1433: := p_shift_construct_id;
1434: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1435: := p_assignee_role;
1436: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1437: := p_show_on_calendar;
1438: l_category_id jtf_task_all_assignments.category_id%TYPE

Line 1436: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

1432: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1433: := p_shift_construct_id;
1434: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1435: := p_assignee_role;
1436: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1437: := p_show_on_calendar;
1438: l_category_id jtf_task_all_assignments.category_id%TYPE
1439: := p_category_id;
1440: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

Line 1438: l_category_id jtf_task_all_assignments.category_id%TYPE

1434: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1435: := p_assignee_role;
1436: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1437: := p_show_on_calendar;
1438: l_category_id jtf_task_all_assignments.category_id%TYPE
1439: := p_category_id;
1440: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
1441: l_session VARCHAR2(10) := 'UPDATE';
1442: l_enable_workflow VARCHAR2(1) := p_enable_workflow;

Line 1440: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

1436: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1437: := p_show_on_calendar;
1438: l_category_id jtf_task_all_assignments.category_id%TYPE
1439: := p_category_id;
1440: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
1441: l_session VARCHAR2(10) := 'UPDATE';
1442: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1443: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1444: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE

Line 1444: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE

1440: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
1441: l_session VARCHAR2(10) := 'UPDATE';
1442: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1443: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1444: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
1445: := p_free_busy_type;
1446: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1447: := p_object_capacity_id;
1448: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

Line 1446: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE

1442: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1443: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1444: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
1445: := p_free_busy_type;
1446: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1447: := p_object_capacity_id;
1448: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1449: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1450:

Line 1448: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

1444: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
1445: := p_free_busy_type;
1446: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1447: := p_object_capacity_id;
1448: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1449: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1450:
1451: -- Added for bug# 5514013 on 11/09/2006
1452: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

Line 1449: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;

1445: := p_free_busy_type;
1446: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1447: := p_object_capacity_id;
1448: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1449: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1450:
1451: -- Added for bug# 5514013 on 11/09/2006
1452: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
1453:

Line 1452: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

1448: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1449: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1450:
1451: -- Added for bug# 5514013 on 11/09/2006
1452: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
1453:
1454: CURSOR task_ass_u
1455: IS
1456: SELECT task_id,

Line 1683: FROM jtf_task_all_assignments

1679: p_object_capacity_id,
1680: fnd_api.g_miss_num, object_capacity_id,
1681: p_object_capacity_id
1682: ) object_capacity_id
1683: FROM jtf_task_all_assignments
1684: WHERE task_assignment_id = l_task_assignment_id;
1685:
1686: x CHAR;
1687: task_ass task_ass_u%ROWTYPE;

Line 1692: -- FROM jtf_task_all_assignments

1688:
1689: -- CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)
1690: -- IS
1691: -- SELECT resource_id, resource_type_code, free_busy_type,assignment_status_id, object_capacity_id
1692: -- FROM jtf_task_all_assignments
1693: -- WHERE task_assignment_id = b_task_assignment_id;
1694:
1695: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1696: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;

Line 1695: l_orig_res_id jtf_task_all_assignments.resource_id%type;

1691: -- SELECT resource_id, resource_type_code, free_busy_type,assignment_status_id, object_capacity_id
1692: -- FROM jtf_task_all_assignments
1693: -- WHERE task_assignment_id = b_task_assignment_id;
1694:
1695: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1696: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;
1697: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;
1698:
1699: -- Business Event System Enhancement # 2391065

Line 1696: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;

1692: -- FROM jtf_task_all_assignments
1693: -- WHERE task_assignment_id = b_task_assignment_id;
1694:
1695: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1696: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;
1697: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;
1698:
1699: -- Business Event System Enhancement # 2391065
1700: l_assignment_rec_old jtf_task_assignments_pvt.task_assignments_rec ;

Line 1697: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;

1693: -- WHERE task_assignment_id = b_task_assignment_id;
1694:
1695: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1696: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;
1697: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;
1698:
1699: -- Business Event System Enhancement # 2391065
1700: l_assignment_rec_old jtf_task_assignments_pvt.task_assignments_rec ;
1701: l_assignment_rec_new jtf_task_assignments_pvt.task_assignments_rec ;

Line 1889: UPDATE jtf_task_all_assignments

1885:
1886: --Bug 2467222 for assignee category update
1887: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)
1888: THEN
1889: UPDATE jtf_task_all_assignments
1890: SET category_id = p_category_id
1891: WHERE task_id = l_task_id
1892: AND resource_id = (SELECT resource_id
1893: FROM jtf_rs_resource_extns

Line 1925: from jtf_task_all_assignments

1921:
1922: -- Update the values based on ASSIGNEE_ROLE
1923: select assignee_role
1924: into l_assignee_role_db
1925: from jtf_task_all_assignments
1926: where task_assignment_id = l_task_assignment_id;
1927: IF l_assignee_role_db = 'OWNER'
1928: THEN
1929: UPDATE jtf_tasks_b

Line 2528: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE

2524: p_delete_option IN VARCHAR2
2525: )
2526: IS
2527: --Declare the variables
2528: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
2529: := p_task_assignment_id;
2530: x CHAR;
2531:
2532: CURSOR c_res_ass

Line 2535: FROM jtf_task_all_assignments

2531:
2532: CURSOR c_res_ass
2533: IS
2534: SELECT 1
2535: FROM jtf_task_all_assignments
2536: WHERE task_assignment_id = l_task_assignment_id;
2537:
2538: l_session VARCHAR2(10) := 'DELETE';
2539: l_task_id jtf_task_all_assignments.task_id%TYPE;

Line 2539: l_task_id jtf_task_all_assignments.task_id%TYPE;

2535: FROM jtf_task_all_assignments
2536: WHERE task_assignment_id = l_task_assignment_id;
2537:
2538: l_session VARCHAR2(10) := 'DELETE';
2539: l_task_id jtf_task_all_assignments.task_id%TYPE;
2540: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2541: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2542: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2543:

Line 2540: l_resource_id jtf_task_all_assignments.resource_id%TYPE;

2536: WHERE task_assignment_id = l_task_assignment_id;
2537:
2538: l_session VARCHAR2(10) := 'DELETE';
2539: l_task_id jtf_task_all_assignments.task_id%TYPE;
2540: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2541: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2542: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2543:
2544: -- Business Event System Enhancement # 2391065

Line 2541: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;

2537:
2538: l_session VARCHAR2(10) := 'DELETE';
2539: l_task_id jtf_task_all_assignments.task_id%TYPE;
2540: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2541: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2542: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2543:
2544: -- Business Event System Enhancement # 2391065
2545: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

Line 2542: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;

2538: l_session VARCHAR2(10) := 'DELETE';
2539: l_task_id jtf_task_all_assignments.task_id%TYPE;
2540: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2541: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2542: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2543:
2544: -- Business Event System Enhancement # 2391065
2545: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2546: CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)

Line 2545: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

2541: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2542: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2543:
2544: -- Business Event System Enhancement # 2391065
2545: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2546: CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)
2547: IS
2548: SELECT task_id, resource_id, resource_type_code, assignee_role, assignment_status_id
2549: FROM jtf_task_all_assignments

Line 2549: FROM jtf_task_all_assignments

2545: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2546: CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)
2547: IS
2548: SELECT task_id, resource_id, resource_type_code, assignee_role, assignment_status_id
2549: FROM jtf_task_all_assignments
2550: WHERE task_assignment_id = b_task_assignment_id;
2551:
2552: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
2553: l_abort_workflow VARCHAR2(1) := p_abort_workflow;

Line 2566: , jtf_task_all_assignments jtaa

2562: , jtb.task_id
2563: , jtaa.resource_id
2564: , jtb.entity
2565: FROM jtf_tasks_b jtb
2566: , jtf_task_all_assignments jtaa
2567: WHERE jtaa.task_assignment_id = b_task_assignment_id
2568: AND jtb.task_id = jtaa.task_id;
2569:
2570: rec_task c_task%ROWTYPE;