41: AND ROWNUM = 1;
42:
43: -- DBMS_OUTPUT.PUT_LINE('OWNER_ID = '|| l_owner_id);
44:
45: JTF_TASKS_PUB.CREATE_TASK
46: (
47: P_API_VERSION => 1.0,
48: P_INIT_MSG_LIST => FND_API.G_TRUE,
49: P_COMMIT => FND_API.G_FALSE,
139: SHOW_ALL IN VARCHAR2 DEFAULT 'YES',
140: SORT_ORDER IN VARCHAR2 DEFAULT 'sortByAscendingDate')
141: RETURN CLOB IS
142:
143: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;
144: l_total_retrieved NUMBER;
145: l_total_returned NUMBER;
146: l_rs VARCHAR2(1);
147: l_msg_count NUMBER;
147: l_msg_count NUMBER;
148: l_msg_data VARCHAR2(2000);
149: l_version_num NUMBER;
150:
151: l_sort_data JTF_TASKS_PUB.SORT_DATA;
152:
153: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
154: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
155: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
149: l_version_num NUMBER;
150:
151: l_sort_data JTF_TASKS_PUB.SORT_DATA;
152:
153: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
154: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
155: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
156: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
157:
150:
151: l_sort_data JTF_TASKS_PUB.SORT_DATA;
152:
153: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
154: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
155: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
156: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
157:
158: v_first INTEGER;
151: l_sort_data JTF_TASKS_PUB.SORT_DATA;
152:
153: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
154: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
155: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
156: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
157:
158: v_first INTEGER;
159: v_index INTEGER;
152:
153: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
154: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
155: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
156: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
157:
158: v_first INTEGER;
159: v_index INTEGER;
160:
192: l_sort_data(2).asc_dsc_flag := 'D';
193: END IF;
194:
195:
196: JTF_TASKS_PUB.query_task(
197: P_API_VERSION => 1.0,
198: P_START_POINTER => 1,
199: P_REC_WANTED => 10,
200: P_SHOW_ALL => 'Y',
303: REC_WANTED IN NUMBER DEFAULT 1,
304: SHOW_ALL IN VARCHAR2 DEFAULT 'YES',
305: SORT_ORDER IN VARCHAR2 DEFAULT 'sortByAscendingDate')
306: IS
307: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;
308: l_total_retrieved NUMBER;
309: l_total_returned NUMBER;
310: l_rs VARCHAR2(1);
311: l_msg_count NUMBER;
311: l_msg_count NUMBER;
312: l_msg_data VARCHAR2(2000);
313: l_version_num NUMBER;
314:
315: l_sort_data JTF_TASKS_PUB.SORT_DATA;
316:
317: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
318: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
319: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
313: l_version_num NUMBER;
314:
315: l_sort_data JTF_TASKS_PUB.SORT_DATA;
316:
317: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
318: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
319: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
320: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
321:
314:
315: l_sort_data JTF_TASKS_PUB.SORT_DATA;
316:
317: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
318: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
319: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
320: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
321:
322: v_first integer;
315: l_sort_data JTF_TASKS_PUB.SORT_DATA;
316:
317: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
318: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
319: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
320: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
321:
322: v_first integer;
323: v_index integer;
316:
317: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
318: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
319: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
320: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
321:
322: v_first integer;
323: v_index integer;
324:
354: l_sort_data(2).asc_dsc_flag := 'A';
355: END IF;
356:
357:
358: JTF_TASKS_PUB.query_task(
359: P_API_VERSION => 1.0,
360: P_START_POINTER => 1,
361: P_REC_WANTED => 10,
362: P_SHOW_ALL => 'Y',
451: X_MSG_DATA OUT NOCOPY VARCHAR2,
452: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
453: X_MSG_COUNT OUT NOCOPY NUMBER)
454: IS
455: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;
456: l_total_retrieved NUMBER;
457: l_total_returned NUMBER;
458: -- l_rs VARCHAR2(1);
459: l_msg_count NUMBER;
463: x NUMBER;
464:
465: l_status_fail EXCEPTION;
466: l_msg_index number;
467: l_sort_data JTF_TASKS_PUB.SORT_DATA;
468:
469: -- note-related variables...
470:
471: l_object_version_number NUMBER := 0;
503: -- ' with completion_status = '||completion_status );
504: -- DBMS_OUTPUT.PUT_LINE('l_note_id=' || l_note_id);
505:
506:
507: JTF_TASKS_PUB.update_task(
508: P_API_VERSION => 1.0,
509: P_OBJECT_VERSION_NUMBER => l_object_version_number,
510: P_TASK_STATUS_ID => l_status_id,
511: P_TASK_ID => P_TASK_ID,
578: P_TASK_ID IN NUMBER,
579: COMMENTS IN VARCHAR2 DEFAULT NULL,
580: COMPLETION_STATUS IN VARCHAR2 DEFAULT 'COMPLETED') IS
581:
582: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;
583: l_total_retrieved NUMBER;
584: l_total_returned NUMBER;
585: l_rs VARCHAR2(1);
586: l_msg_count NUMBER;
588: l_version_num NUMBER;
589: l_status_id NUMBER := 9;
590: x NUMBER;
591:
592: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
593: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;
596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
589: l_status_id NUMBER := 9;
590: x NUMBER;
591:
592: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
593: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;
596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
597:
590: x NUMBER;
591:
592: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
593: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;
596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
597:
598: l_sort_data JTF_TASKS_PUB.SORT_DATA;
591:
592: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
593: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;
596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
597:
598: l_sort_data JTF_TASKS_PUB.SORT_DATA;
599:
592: recurs JTF_TASKS_PUB.TASK_RECUR_REC;
593: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;
594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;
596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
597:
598: l_sort_data JTF_TASKS_PUB.SORT_DATA;
599:
600: -- note-related variables...
594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;
595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;
596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;
597:
598: l_sort_data JTF_TASKS_PUB.SORT_DATA;
599:
600: -- note-related variables...
601: x_return_status VARCHAR2(2000);
602: x_msg_count NUMBER;
637:
638: --DBMS_OUTPUT.PUT_LINE('Task '||task_id||' status = '||l_status_id||
639: -- ' with completion_status = '||completion_status );
640:
641: JTF_TASKS_PUB.update_task(
642: P_API_VERSION => 1.0,
643: P_OBJECT_VERSION_NUMBER => l_object_version_number,
644: P_TASK_STATUS_ID => l_status_id,
645: P_TASK_ID => P_TASK_ID,