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.3.12000000.2 2007/07/19 08:45:38 lokumar 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 223: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;

219: l_api_name CONSTANT VARCHAR(30)
220: := 'CREATE_TASK_ASSIGNMENTS';
221: l_return_status VARCHAR2(1)
222: := fnd_api.g_ret_sts_success;
223: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
224: l_task_id jtf_tasks_b.task_id%TYPE
225: := p_task_id;
226: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
227: := p_resource_type_code;

Line 226: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE

222: := fnd_api.g_ret_sts_success;
223: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE;
224: l_task_id jtf_tasks_b.task_id%TYPE
225: := p_task_id;
226: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
227: := p_resource_type_code;
228: l_resource_id NUMBER
229: := p_resource_id;
230: l_act_eff NUMBER

Line 236: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

232: l_act_eff_uom VARCHAR2(3)
233: := p_actual_effort_uom;
234: l_schedule_flag VARCHAR2(1)
235: := p_schedule_flag;
236: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
237: := p_alarm_type_code;
238: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
239: := p_alarm_contact;
240: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

Line 238: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

234: l_schedule_flag VARCHAR2(1)
235: := p_schedule_flag;
236: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
237: := p_alarm_type_code;
238: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
239: := p_alarm_contact;
240: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
241: := p_sched_travel_distance;
242: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

Line 240: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

236: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
237: := p_alarm_type_code;
238: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
239: := p_alarm_contact;
240: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
241: := p_sched_travel_distance;
242: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
243: := p_sched_travel_duration;
244: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

Line 242: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

238: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
239: := p_alarm_contact;
240: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
241: := p_sched_travel_distance;
242: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
243: := p_sched_travel_duration;
244: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
245: := p_sched_travel_duration_uom;
246: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

Line 244: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

240: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
241: := p_sched_travel_distance;
242: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
243: := p_sched_travel_duration;
244: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
245: := p_sched_travel_duration_uom;
246: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
247: := p_actual_travel_distance;
248: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

Line 246: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

242: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
243: := p_sched_travel_duration;
244: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
245: := p_sched_travel_duration_uom;
246: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
247: := p_actual_travel_distance;
248: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
249: := p_actual_travel_duration;
250: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

Line 248: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

244: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
245: := p_sched_travel_duration_uom;
246: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
247: := p_actual_travel_distance;
248: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
249: := p_actual_travel_duration;
250: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
251: := p_actual_travel_duration_uom;
252: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

Line 250: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

246: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
247: := p_actual_travel_distance;
248: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
249: := p_actual_travel_duration;
250: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
251: := p_actual_travel_duration_uom;
252: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
253: := p_actual_start_date;
254: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

Line 252: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

248: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
249: := p_actual_travel_duration;
250: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
251: := p_actual_travel_duration_uom;
252: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
253: := p_actual_start_date;
254: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
255: := p_actual_end_date;
256: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

Line 254: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

250: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
251: := p_actual_travel_duration_uom;
252: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
253: := p_actual_start_date;
254: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
255: := p_actual_end_date;
256: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
257: := p_palm_flag;
258: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

Line 256: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

252: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
253: := p_actual_start_date;
254: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
255: := p_actual_end_date;
256: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
257: := p_palm_flag;
258: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
259: := p_wince_flag;
260: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

Line 258: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

254: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
255: := p_actual_end_date;
256: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
257: := p_palm_flag;
258: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
259: := p_wince_flag;
260: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
261: := p_laptop_flag;
262: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

Line 260: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

256: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
257: := p_palm_flag;
258: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
259: := p_wince_flag;
260: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
261: := p_laptop_flag;
262: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
263: := p_device1_flag;
264: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

Line 262: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

258: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
259: := p_wince_flag;
260: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
261: := p_laptop_flag;
262: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
263: := p_device1_flag;
264: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
265: := p_device2_flag;
266: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

Line 264: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

260: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
261: := p_laptop_flag;
262: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
263: := p_device1_flag;
264: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
265: := p_device2_flag;
266: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
267: := p_device3_flag;
268: l_msg_data VARCHAR2(2000);

Line 266: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

262: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
263: := p_device1_flag;
264: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
265: := p_device2_flag;
266: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
267: := p_device3_flag;
268: l_msg_data VARCHAR2(2000);
269: l_msg_count NUMBER;
270: x CHAR;

Line 272: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE

268: l_msg_data VARCHAR2(2000);
269: l_msg_count NUMBER;
270: x CHAR;
271: l_rowid ROWID;
272: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
273: := p_resource_territory_id;
274: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
275: := p_assignment_status_id;
276: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

Line 274: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE

270: x CHAR;
271: l_rowid ROWID;
272: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
273: := p_resource_territory_id;
274: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
275: := p_assignment_status_id;
276: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
277: := p_shift_construct_id;
278: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

Line 276: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

272: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
273: := p_resource_territory_id;
274: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
275: := p_assignment_status_id;
276: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
277: := p_shift_construct_id;
278: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
279: := p_assignee_role;
280: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

Line 278: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

274: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
275: := p_assignment_status_id;
276: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
277: := p_shift_construct_id;
278: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
279: := p_assignee_role;
280: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
281: := p_show_on_calendar;
282: l_category_id jtf_task_all_assignments.category_id%TYPE

Line 280: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

276: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
277: := p_shift_construct_id;
278: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
279: := p_assignee_role;
280: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
281: := p_show_on_calendar;
282: l_category_id jtf_task_all_assignments.category_id%TYPE
283: := p_category_id;
284: l_enable_workflow VARCHAR2(1) := p_enable_workflow;

Line 282: l_category_id jtf_task_all_assignments.category_id%TYPE

278: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
279: := p_assignee_role;
280: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
281: := p_show_on_calendar;
282: l_category_id jtf_task_all_assignments.category_id%TYPE
283: := p_category_id;
284: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
285: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
286:

Line 288: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

284: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
285: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
286:
287: -- Simplex Changes ..
288: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
289: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
290: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
291: := p_free_busy_type;
292:

Line 289: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;

285: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
286:
287: -- Simplex Changes ..
288: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
289: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
290: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
291: := p_free_busy_type;
292:
293: CURSOR ra_cur1 (l_rowid IN ROWID)

Line 290: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE

286:
287: -- Simplex Changes ..
288: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
289: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
290: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
291: := p_free_busy_type;
292:
293: CURSOR ra_cur1 (l_rowid IN ROWID)
294: IS

Line 296: FROM jtf_task_all_assignments

292:
293: CURSOR ra_cur1 (l_rowid IN ROWID)
294: IS
295: SELECT 1
296: FROM jtf_task_all_assignments
297: WHERE ROWID = l_rowid;
298:
299: ------------------------------------------
300: -- For XP

Line 1320: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE

1316: l_api_name CONSTANT VARCHAR(30)
1317: := 'Update_Task_Assignment';
1318: l_return_status VARCHAR2(1)
1319: := fnd_api.g_ret_sts_success;
1320: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1321: := p_task_assignment_id;
1322: l_task_id jtf_task_all_assignments.task_id%TYPE;
1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1324: := p_resource_type_code;

Line 1322: l_task_id jtf_task_all_assignments.task_id%TYPE;

1318: l_return_status VARCHAR2(1)
1319: := fnd_api.g_ret_sts_success;
1320: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1321: := p_task_assignment_id;
1322: l_task_id jtf_task_all_assignments.task_id%TYPE;
1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1324: := p_resource_type_code;
1325: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1326: := p_resource_id;

Line 1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE

1319: := fnd_api.g_ret_sts_success;
1320: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
1321: := p_task_assignment_id;
1322: l_task_id jtf_task_all_assignments.task_id%TYPE;
1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1324: := p_resource_type_code;
1325: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1326: := p_resource_id;
1327: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

Line 1325: l_resource_id jtf_task_all_assignments.resource_id%TYPE

1321: := p_task_assignment_id;
1322: l_task_id jtf_task_all_assignments.task_id%TYPE;
1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1324: := p_resource_type_code;
1325: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1326: := p_resource_id;
1327: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1328: := p_actual_effort;
1329: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

Line 1327: l_act_eff jtf_task_all_assignments.actual_effort%TYPE

1323: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE
1324: := p_resource_type_code;
1325: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1326: := p_resource_id;
1327: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1328: := p_actual_effort;
1329: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1330: := p_actual_effort_uom;
1331: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

Line 1329: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE

1325: l_resource_id jtf_task_all_assignments.resource_id%TYPE
1326: := p_resource_id;
1327: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1328: := p_actual_effort;
1329: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1330: := p_actual_effort_uom;
1331: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1332: := p_schedule_flag;
1333: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

Line 1331: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE

1327: l_act_eff jtf_task_all_assignments.actual_effort%TYPE
1328: := p_actual_effort;
1329: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1330: := p_actual_effort_uom;
1331: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1332: := p_schedule_flag;
1333: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1334: := p_alarm_type_code;
1335: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

Line 1333: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE

1329: l_act_eff_uom jtf_task_all_assignments.actual_effort_uom%TYPE
1330: := p_actual_effort_uom;
1331: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1332: := p_schedule_flag;
1333: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1334: := p_alarm_type_code;
1335: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1336: := p_alarm_contact;
1337: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

Line 1335: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE

1331: l_schedule_flag jtf_task_all_assignments.schedule_flag%TYPE
1332: := p_schedule_flag;
1333: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1334: := p_alarm_type_code;
1335: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1336: := p_alarm_contact;
1337: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1338: := p_sched_travel_distance;
1339: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

Line 1337: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE

1333: l_alarm_type_code jtf_task_all_assignments.alarm_type_code%TYPE
1334: := p_alarm_type_code;
1335: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1336: := p_alarm_contact;
1337: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1338: := p_sched_travel_distance;
1339: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1340: := p_sched_travel_duration;
1341: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

Line 1339: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE

1335: l_alarm_contact jtf_task_all_assignments.alarm_contact%TYPE
1336: := p_alarm_contact;
1337: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1338: := p_sched_travel_distance;
1339: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1340: := p_sched_travel_duration;
1341: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1342: := p_sched_travel_duration_uom;
1343: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

Line 1341: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE

1337: l_sched_travel_distance jtf_task_all_assignments.sched_travel_distance%TYPE
1338: := p_sched_travel_distance;
1339: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1340: := p_sched_travel_duration;
1341: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1342: := p_sched_travel_duration_uom;
1343: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1344: := p_actual_travel_distance;
1345: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

Line 1343: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE

1339: l_sched_travel_duration jtf_task_all_assignments.sched_travel_duration%TYPE
1340: := p_sched_travel_duration;
1341: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1342: := p_sched_travel_duration_uom;
1343: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1344: := p_actual_travel_distance;
1345: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1346: := p_actual_travel_duration;
1347: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

Line 1345: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE

1341: l_sched_travel_dur_uom jtf_task_all_assignments.sched_travel_duration_uom%TYPE
1342: := p_sched_travel_duration_uom;
1343: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1344: := p_actual_travel_distance;
1345: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1346: := p_actual_travel_duration;
1347: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1348: := p_actual_travel_duration_uom;
1349: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

Line 1347: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE

1343: l_actual_travel_distance jtf_task_all_assignments.actual_travel_distance%TYPE
1344: := p_actual_travel_distance;
1345: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1346: := p_actual_travel_duration;
1347: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1348: := p_actual_travel_duration_uom;
1349: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1350: := p_actual_start_date;
1351: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

Line 1349: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE

1345: l_actual_travel_duration jtf_task_all_assignments.actual_travel_duration%TYPE
1346: := p_actual_travel_duration;
1347: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1348: := p_actual_travel_duration_uom;
1349: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1350: := p_actual_start_date;
1351: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1352: := p_actual_end_date;
1353: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

Line 1351: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE

1347: l_actual_travel_dur_uom jtf_task_all_assignments.actual_travel_duration_uom%TYPE
1348: := p_actual_travel_duration_uom;
1349: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1350: := p_actual_start_date;
1351: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1352: := p_actual_end_date;
1353: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1354: := p_palm_flag;
1355: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

Line 1353: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE

1349: l_actual_start_date jtf_task_all_assignments.actual_start_date%TYPE
1350: := p_actual_start_date;
1351: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1352: := p_actual_end_date;
1353: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1354: := p_palm_flag;
1355: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1356: := p_wince_flag;
1357: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

Line 1355: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE

1351: l_actual_end_date jtf_task_all_assignments.actual_end_date%TYPE
1352: := p_actual_end_date;
1353: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1354: := p_palm_flag;
1355: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1356: := p_wince_flag;
1357: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1358: := p_laptop_flag;
1359: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

Line 1357: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE

1353: l_palm_flag jtf_task_all_assignments.palm_flag%TYPE
1354: := p_palm_flag;
1355: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1356: := p_wince_flag;
1357: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1358: := p_laptop_flag;
1359: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1360: := p_device1_flag;
1361: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

Line 1359: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE

1355: l_wince_flag jtf_task_all_assignments.wince_flag%TYPE
1356: := p_wince_flag;
1357: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1358: := p_laptop_flag;
1359: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1360: := p_device1_flag;
1361: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1362: := p_device2_flag;
1363: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

Line 1361: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE

1357: l_laptop_flag jtf_task_all_assignments.laptop_flag%TYPE
1358: := p_laptop_flag;
1359: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1360: := p_device1_flag;
1361: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1362: := p_device2_flag;
1363: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
1364: := p_device3_flag;
1365: l_msg_data VARCHAR2(2000);

Line 1363: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE

1359: l_device1_flag jtf_task_all_assignments.device1_flag%TYPE
1360: := p_device1_flag;
1361: l_device2_flag jtf_task_all_assignments.device2_flag%TYPE
1362: := p_device2_flag;
1363: l_device3_flag jtf_task_all_assignments.device3_flag%TYPE
1364: := p_device3_flag;
1365: l_msg_data VARCHAR2(2000);
1366: l_msg_count NUMBER;
1367: x CHAR;

Line 1369: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE

1365: l_msg_data VARCHAR2(2000);
1366: l_msg_count NUMBER;
1367: x CHAR;
1368: l_rowid ROWID;
1369: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1370: := p_assignment_status_id;
1371: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1372: := p_resource_territory_id;
1373: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

Line 1371: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE

1367: x CHAR;
1368: l_rowid ROWID;
1369: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1370: := p_assignment_status_id;
1371: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1372: := p_resource_territory_id;
1373: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1374: := p_shift_construct_id;
1375: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

Line 1373: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE

1369: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE
1370: := p_assignment_status_id;
1371: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1372: := p_resource_territory_id;
1373: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1374: := p_shift_construct_id;
1375: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1376: := p_assignee_role;
1377: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

Line 1375: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE

1371: l_resource_territory_id jtf_task_all_assignments.resource_territory_id%TYPE
1372: := p_resource_territory_id;
1373: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1374: := p_shift_construct_id;
1375: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1376: := p_assignee_role;
1377: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1378: := p_show_on_calendar;
1379: l_category_id jtf_task_all_assignments.category_id%TYPE

Line 1377: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE

1373: l_shift_construct_id jtf_task_all_assignments.shift_construct_id%TYPE
1374: := p_shift_construct_id;
1375: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1376: := p_assignee_role;
1377: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1378: := p_show_on_calendar;
1379: l_category_id jtf_task_all_assignments.category_id%TYPE
1380: := p_category_id;
1381: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

Line 1379: l_category_id jtf_task_all_assignments.category_id%TYPE

1375: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
1376: := p_assignee_role;
1377: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1378: := p_show_on_calendar;
1379: l_category_id jtf_task_all_assignments.category_id%TYPE
1380: := p_category_id;
1381: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
1382: l_session VARCHAR2(10) := 'UPDATE';
1383: l_enable_workflow VARCHAR2(1) := p_enable_workflow;

Line 1381: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;

1377: l_show_on_calendar jtf_task_all_assignments.show_on_calendar%TYPE
1378: := p_show_on_calendar;
1379: l_category_id jtf_task_all_assignments.category_id%TYPE
1380: := p_category_id;
1381: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
1382: l_session VARCHAR2(10) := 'UPDATE';
1383: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1384: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1385: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE

Line 1385: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE

1381: l_assignee_role_db jtf_task_all_assignments.assignee_role%TYPE;
1382: l_session VARCHAR2(10) := 'UPDATE';
1383: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1384: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1385: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
1386: := p_free_busy_type;
1387: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1388: := p_object_capacity_id;
1389: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

Line 1387: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE

1383: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
1384: l_abort_workflow VARCHAR2(1) := p_abort_workflow;
1385: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
1386: := p_free_busy_type;
1387: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1388: := p_object_capacity_id;
1389: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1390: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1391:

Line 1389: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;

1385: l_free_busy_type jtf_task_all_assignments.free_busy_type%TYPE
1386: := p_free_busy_type;
1387: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1388: := p_object_capacity_id;
1389: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1390: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1391:
1392: -- Added for bug# 5514013 on 11/09/2006
1393: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

Line 1390: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;

1386: := p_free_busy_type;
1387: l_object_capacity_id jtf_task_all_assignments.object_capacity_id%TYPE
1388: := p_object_capacity_id;
1389: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1390: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1391:
1392: -- Added for bug# 5514013 on 11/09/2006
1393: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
1394:

Line 1393: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

1389: l_booking_start_date jtf_task_all_assignments.booking_start_date%TYPE;
1390: l_booking_end_date jtf_task_all_assignments.booking_end_date%TYPE;
1391:
1392: -- Added for bug# 5514013 on 11/09/2006
1393: l_old_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
1394:
1395: CURSOR task_ass_u
1396: IS
1397: SELECT task_id,

Line 1624: FROM jtf_task_all_assignments

1620: p_object_capacity_id,
1621: fnd_api.g_miss_num, object_capacity_id,
1622: p_object_capacity_id
1623: ) object_capacity_id
1624: FROM jtf_task_all_assignments
1625: WHERE task_assignment_id = l_task_assignment_id;
1626:
1627: x CHAR;
1628: task_ass task_ass_u%ROWTYPE;

Line 1633: -- FROM jtf_task_all_assignments

1629:
1630: -- CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)
1631: -- IS
1632: -- SELECT resource_id, resource_type_code, free_busy_type,assignment_status_id, object_capacity_id
1633: -- FROM jtf_task_all_assignments
1634: -- WHERE task_assignment_id = b_task_assignment_id;
1635:
1636: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1637: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;

Line 1636: l_orig_res_id jtf_task_all_assignments.resource_id%type;

1632: -- SELECT resource_id, resource_type_code, free_busy_type,assignment_status_id, object_capacity_id
1633: -- FROM jtf_task_all_assignments
1634: -- WHERE task_assignment_id = b_task_assignment_id;
1635:
1636: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1637: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;
1638: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;
1639:
1640: -- Business Event System Enhancement # 2391065

Line 1637: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;

1633: -- FROM jtf_task_all_assignments
1634: -- WHERE task_assignment_id = b_task_assignment_id;
1635:
1636: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1637: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;
1638: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;
1639:
1640: -- Business Event System Enhancement # 2391065
1641: l_assignment_rec_old jtf_task_assignments_pvt.task_assignments_rec ;

Line 1638: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;

1634: -- WHERE task_assignment_id = b_task_assignment_id;
1635:
1636: l_orig_res_id jtf_task_all_assignments.resource_id%type;
1637: l_orig_res_type_code jtf_task_all_assignments.resource_type_code%type;
1638: l_orig_object_capacity_id jtf_task_all_assignments.object_capacity_id%type;
1639:
1640: -- Business Event System Enhancement # 2391065
1641: l_assignment_rec_old jtf_task_assignments_pvt.task_assignments_rec ;
1642: l_assignment_rec_new jtf_task_assignments_pvt.task_assignments_rec ;

Line 1830: UPDATE jtf_task_all_assignments

1826:
1827: --Bug 2467222 for assignee category update
1828: IF (p_category_id <> jtf_task_utl.g_miss_number) OR (p_category_id IS NULL)
1829: THEN
1830: UPDATE jtf_task_all_assignments
1831: SET category_id = p_category_id
1832: WHERE task_id = l_task_id
1833: AND resource_id = (SELECT resource_id
1834: FROM jtf_rs_resource_extns

Line 1866: from jtf_task_all_assignments

1862:
1863: -- Update the values based on ASSIGNEE_ROLE
1864: select assignee_role
1865: into l_assignee_role_db
1866: from jtf_task_all_assignments
1867: where task_assignment_id = l_task_assignment_id;
1868: IF l_assignee_role_db = 'OWNER'
1869: THEN
1870: UPDATE jtf_tasks_b

Line 2451: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE

2447: p_delete_option IN VARCHAR2
2448: )
2449: IS
2450: --Declare the variables
2451: l_task_assignment_id jtf_task_all_assignments.task_assignment_id%TYPE
2452: := p_task_assignment_id;
2453: x CHAR;
2454:
2455: CURSOR c_res_ass

Line 2458: FROM jtf_task_all_assignments

2454:
2455: CURSOR c_res_ass
2456: IS
2457: SELECT 1
2458: FROM jtf_task_all_assignments
2459: WHERE task_assignment_id = l_task_assignment_id;
2460:
2461: l_session VARCHAR2(10) := 'DELETE';
2462: l_task_id jtf_task_all_assignments.task_id%TYPE;

Line 2462: l_task_id jtf_task_all_assignments.task_id%TYPE;

2458: FROM jtf_task_all_assignments
2459: WHERE task_assignment_id = l_task_assignment_id;
2460:
2461: l_session VARCHAR2(10) := 'DELETE';
2462: l_task_id jtf_task_all_assignments.task_id%TYPE;
2463: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2464: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2465: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2466:

Line 2463: l_resource_id jtf_task_all_assignments.resource_id%TYPE;

2459: WHERE task_assignment_id = l_task_assignment_id;
2460:
2461: l_session VARCHAR2(10) := 'DELETE';
2462: l_task_id jtf_task_all_assignments.task_id%TYPE;
2463: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2464: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2465: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2466:
2467: -- Business Event System Enhancement # 2391065

Line 2464: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;

2460:
2461: l_session VARCHAR2(10) := 'DELETE';
2462: l_task_id jtf_task_all_assignments.task_id%TYPE;
2463: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2464: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2465: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2466:
2467: -- Business Event System Enhancement # 2391065
2468: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

Line 2465: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;

2461: l_session VARCHAR2(10) := 'DELETE';
2462: l_task_id jtf_task_all_assignments.task_id%TYPE;
2463: l_resource_id jtf_task_all_assignments.resource_id%TYPE;
2464: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2465: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2466:
2467: -- Business Event System Enhancement # 2391065
2468: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2469: CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)

Line 2468: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;

2464: l_resource_type_code jtf_task_all_assignments.resource_type_code%TYPE;
2465: l_assignee_role jtf_task_all_assignments.assignee_role%TYPE;
2466:
2467: -- Business Event System Enhancement # 2391065
2468: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2469: CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)
2470: IS
2471: SELECT task_id, resource_id, resource_type_code, assignee_role, assignment_status_id
2472: FROM jtf_task_all_assignments

Line 2472: FROM jtf_task_all_assignments

2468: l_assignment_status_id jtf_task_all_assignments.assignment_status_id%TYPE;
2469: CURSOR ass_res_orig (b_task_assignment_id IN NUMBER)
2470: IS
2471: SELECT task_id, resource_id, resource_type_code, assignee_role, assignment_status_id
2472: FROM jtf_task_all_assignments
2473: WHERE task_assignment_id = b_task_assignment_id;
2474:
2475: l_enable_workflow VARCHAR2(1) := p_enable_workflow;
2476: l_abort_workflow VARCHAR2(1) := p_abort_workflow;

Line 2489: , jtf_task_all_assignments jtaa

2485: , jtb.task_id
2486: , jtaa.resource_id
2487: , jtb.entity
2488: FROM jtf_tasks_b jtb
2489: , jtf_task_all_assignments jtaa
2490: WHERE jtaa.task_assignment_id = b_task_assignment_id
2491: AND jtb.task_id = jtaa.task_id;
2492:
2493: rec_task c_task%ROWTYPE;