16601: FETCH c_invalid_tasks INTO l_inv_task_id,l_object_version_number;
16602: EXIT WHEN c_invalid_tasks%NOTFOUND;
16603: WriteLog(G_PKG_NAME || ' ' || l_api_name || 'Cancelling callback Task Id:'||l_inv_task_id);
16604: IF l_inv_task_id IS NOT NULL THEN
16605: JTF_TASKS_PUB.UPDATE_TASK(
16606: P_API_VERSION => p_api_version,
16607: P_INIT_MSG_LIST => p_init_msg_list,
16608: P_COMMIT => p_commit,
16609: P_OBJECT_VERSION_NUMBER => l_object_version_number,
16764: l_source_object_id number;
16765: --l_source_object_name varchar2(80);
16766: l_source_object_name varchar2(360); -- added for bug 14036760
16767: --
16768: l_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
16769: l_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16765: --l_source_object_name varchar2(80);
16766: l_source_object_name varchar2(360); -- added for bug 14036760
16767: --
16768: l_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
16769: l_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16766: l_source_object_name varchar2(360); -- added for bug 14036760
16767: --
16768: l_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
16769: l_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16767: --
16768: l_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
16769: l_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16775: l_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
16768: l_task_notes_tbl JTF_TASKS_PUB.TASK_NOTES_TBL;
16769: l_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16775: l_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
16776: l_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
16769: l_miss_task_assign_tbl JTF_TASKS_PUB.TASK_ASSIGN_TBL;
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16775: l_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
16776: l_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
16777: --
16770: l_miss_task_depends_tbl JTF_TASKS_PUB.TASK_DEPENDS_TBL;
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16775: l_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
16776: l_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
16777: --
16778: errmsg varchar2(30000);
16771: l_miss_task_rsrc_req_tbl JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16775: l_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
16776: l_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
16777: --
16778: errmsg varchar2(30000);
16779:
16772: l_task_refer_rec JTF_TASKS_PUB.TASK_REFER_REC;
16773: l_task_refer_tbl JTF_TASKS_PUB.TASK_REFER_TBL;
16774: l_miss_task_dates_tbl JTF_TASKS_PUB.TASK_DATES_TBL;
16775: l_miss_task_recur_rec JTF_TASKS_PUB.TASK_RECUR_REC;
16776: l_miss_task_contacts_tbl JTF_TASKS_PUB.TASK_CONTACTS_TBL;
16777: --
16778: errmsg varchar2(30000);
16779:
16780: --Added for bug#5229763 schekuri 27-Jul-2006
17129:
17130: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - refer_tbl_cnt='||l_task_refer_tbl.count);
17131: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' - Create Task');
17132:
17133: JTF_TASKS_PUB.CREATE_TASK(
17134: p_api_version => p_api_version,
17135: p_init_msg_list => p_init_msg_list,
17136: p_commit => p_commit,
17137: p_task_name => l_task_name,