154: l_planned_start_date DATE;
155: l_planned_end_date DATE;
156: l_actual_start_date DATE;
157: l_actual_end_date DATE;
158: v_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
159: v_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
155: l_planned_end_date DATE;
156: l_actual_start_date DATE;
157: l_actual_end_date DATE;
158: v_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
159: v_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
156: l_actual_start_date DATE;
157: l_actual_end_date DATE;
158: v_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
159: v_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
157: l_actual_end_date DATE;
158: v_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
159: v_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
165: v_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
158: v_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
159: v_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
165: v_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
166: v_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
159: v_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
165: v_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
166: v_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
167:
160: v_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
165: v_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
166: v_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
167:
168: --These variables are used for debugging. To be removed
161: v_miss_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
165: v_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
166: v_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
167:
168: --These variables are used for debugging. To be removed
169: l_count NUMBER;
162: v_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
163: v_miss_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
164: v_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
165: v_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
166: v_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
167:
168: --These variables are used for debugging. To be removed
169: l_count NUMBER;
170: l_index NUMBER;
317: CLOSE c_phone_id;
318: END IF;
319: end if;
320:
321: JTF_TASKS_PUB.CREATE_TASK(
322: P_API_VERSION => l_api_version,
323: P_INIT_MSG_LIST => l_init_msg_list,
324: P_COMMIT => l_commit,
325: P_TASK_ID => null,