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.CSF_MAINTAIN_GRP dependencies on JTF_NUMBER_TABLE

Line 225: l_tab_sched_req_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

221: NVL(TMP.PURGE_STATUS, 'S') <> 'E' AND TMP.OBJECT_ID = TSKT.SOURCE_OBJECT_ID
222: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
223: CSACC.TASK_ID AND CSACC.SCHED_REQUEST_ID = CSACTL.SCHED_REQUEST_ID));
224:
225: l_tab_sched_req_id JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
226:
227:
228: BEGIN
229:

Line 557: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND

553: WHERE
554: MESSAGE_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
555: CSACTL.MESSAGE_ID FROM CSF_R_MESSAGE_TOKENS CSACTL ,
556: CSF_R_MESSAGES CSRM, CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR
557: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND
558: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
559: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND
560: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID AND
561: CSRM.MESSAGE_ID = CSACTL.MESSAGE_ID );

Line 569: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND

565: WHERE
566: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
567: CSACC.REQUEST_TASK_ID FROM CSF_R_MESSAGES CSRM ,
568: CSF_R_REQUEST_TASKS CSACC , CSF_R_SCHED_REQUESTS CSCHR
569: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT T.COLUMN_VALUE FROM TABLE(CAST(L_TAB_SCHED_REQ_ID AS JTF_NUMBER_TABLE)) T) AND
570: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
571: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND
572: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID);
573:

Line 585: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(l_tab_sched_req_id AS JTF_NUMBER_TABLE)) t) AND

581: WHERE
582: REQUEST_TASK_ID IN ( SELECT /*+ LEADING(TMP) cardinality(TMP, 10) */
583: CSACC.REQUEST_TASK_ID FROM CSF_R_REQUEST_TASKS
584: CSACC , CSF_R_SCHED_REQUESTS CSCHR
585: WHERE CSCHR.SCHED_REQUEST_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(l_tab_sched_req_id AS JTF_NUMBER_TABLE)) t) AND
586: --WHERE CSCHR.SCHED_REQUEST_ID = l_tab_sched_req_id(i) AND
587: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID);
588:
589:

Line 598: SCHED_REQUEST_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(l_tab_sched_req_id AS JTF_NUMBER_TABLE)) t);

594: /* Step 13 - Delete Schedule Requests */
595: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last
596: DELETE /*+ index(crsr) */ FROM CSF_R_SCHED_REQUESTS CRSR
597: WHERE
598: SCHED_REQUEST_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(l_tab_sched_req_id AS JTF_NUMBER_TABLE)) t);
599: --SCHED_REQUEST_ID = l_tab_sched_req_id(i);
600:
601: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');