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.TASK_MGR dependencies on JTF_TASKS_PUB

Line 45: JTF_TASKS_PUB.CREATE_TASK

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,

Line 143: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;

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;

Line 151: l_sort_data JTF_TASKS_PUB.SORT_DATA;

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;

Line 153: recurs JTF_TASKS_PUB.TASK_RECUR_REC;

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:

Line 154: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;

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;

Line 155: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;

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;

Line 156: notes JTF_TASKS_PUB.TASK_NOTES_TBL;

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:

Line 196: JTF_TASKS_PUB.query_task(

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',

Line 307: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;

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;

Line 315: l_sort_data JTF_TASKS_PUB.SORT_DATA;

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;

Line 317: recurs JTF_TASKS_PUB.TASK_RECUR_REC;

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:

Line 318: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_TBL;

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;

Line 319: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;

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;

Line 320: notes JTF_TASKS_PUB.TASK_NOTES_TBL;

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:

Line 358: JTF_TASKS_PUB.query_task(

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',

Line 455: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;

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;

Line 467: l_sort_data JTF_TASKS_PUB.SORT_DATA;

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;

Line 507: JTF_TASKS_PUB.update_task(

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,

Line 582: l_task_table JTF_TASKS_PUB.TASK_TABLE_TYPE;

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;

Line 592: recurs JTF_TASKS_PUB.TASK_RECUR_REC;

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;

Line 593: rsc JTF_TASKS_PUB.TASK_RSRC_REQ_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:

Line 594: asn JTF_TASKS_PUB.TASK_ASSIGN_TBL;

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;

Line 595: ass JTF_TASKS_PUB.TASK_ASSIGN_TBL;

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:

Line 596: notes JTF_TASKS_PUB.TASK_NOTES_TBL;

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...

Line 598: l_sort_data JTF_TASKS_PUB.SORT_DATA;

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;

Line 641: JTF_TASKS_PUB.update_task(

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,