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_OBJECT_PURGE_PARAM_TMP

Line 73: update JTF_OBJECT_PURGE_PARAM_TMP

69:
70: /* Step 1 : Mark SRs (for the given p_processing_set_id) as NOT a delete candidate
71: IF the SR is linked to a CMRO object
72: */
73: update JTF_OBJECT_PURGE_PARAM_TMP
74: set
75: purge_status = 'E'
76: , purge_error_message = 'CSF:CSF_DEBRIEF_PURGE_FAILED'
77: where

Line 85: , JTF_OBJECT_PURGE_PARAM_TMP tmp

81: select
82: lnk.subject_id
83: from
84: cs_incident_links lnk
85: , JTF_OBJECT_PURGE_PARAM_TMP tmp
86: where
87: tmp.object_id = lnk.subject_id and
88: lnk.object_type = 'AHL_UMP_EFF' and
89: lnk.link_type_id = 6 and

Line 103: mark the JTF_OBJECT_PURGE_PARAM_TMP table with a status 'E' for all those SRs which have

99: IF the SR is linked to mobile FS tasks that CANNOT be deleted
100: */
101: /*
102: This is the place where we call the mobile field service task validation API to further
103: mark the JTF_OBJECT_PURGE_PARAM_TMP table with a status 'E' for all those SRs which have
104: mobile field service tasks that CANNOT be deleted
105: */
106: csm_sr_purge_pkg.Validate_MobileFSObjects(
107: P_API_VERSION => P_API_VERSION,

Line 133: update JTF_OBJECT_PURGE_PARAM_TMP

129:
130: /* Step 3: Mark SRs (for the given p_processing_set_id) as NOT a delete candidate
131: IF the SR is linked to FS tasks that are in Closed/Completed/Cancelled status
132: */
133: update JTF_OBJECT_PURGE_PARAM_TMP
134: set
135: purge_status = 'E'
136: , purge_error_message = 'CSF:CSF_DEBRIEF_PURGE_FAILED'
137: where

Line 147: , JTF_OBJECT_PURGE_PARAM_TMP tmp

143: from
144: jtf_tasks_b jtftk
145: , jtf_task_statuses_b jtfts
146: , jtf_task_types_b jttp
147: , JTF_OBJECT_PURGE_PARAM_TMP tmp
148: where
149: tmp.object_id = jtftk.source_object_id and
150: tmp.object_type = jtftk.source_object_type_code and
151: jtftk.task_status_id = jtfts.task_status_id and

Line 265: , JTF_OBJECT_PURGE_PARAM_TMP tmp

261: , JTF_NOTES_B jtfnb
262: , CSF_DEBRIEF_HEADERS dbfh
263: , JTF_TASK_ASSIGNMENTS tska
264: , JTF_TASKS_B tskt
265: , JTF_OBJECT_PURGE_PARAM_TMP tmp
266: WHERE
267: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
268: nvl(tmp.purge_status, 'S') <> 'E' and
269: tmp.object_id = tskt.source_object_id and

Line 291: , JTF_OBJECT_PURGE_PARAM_TMP tmp

287: JTF_NOTES_B jtfnb
288: , CSF_DEBRIEF_HEADERS dbfh
289: , JTF_TASK_ASSIGNMENTS tska
290: , JTF_TASKS_B tskt
291: , JTF_OBJECT_PURGE_PARAM_TMP tmp
292: WHERE
293: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
294: nvl(tmp.purge_status, 'S') <> 'E' and
295: tmp.object_id = tskt.source_object_id and

Line 315: , JTF_OBJECT_PURGE_PARAM_TMP tmp

311: JTF_NOTES_B jtfnb
312: , CSF_DEBRIEF_HEADERS dbfh
313: , JTF_TASK_ASSIGNMENTS tska
314: , JTF_TASKS_B tskt
315: , JTF_OBJECT_PURGE_PARAM_TMP tmp
316: WHERE
317: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
318: nvl(tmp.purge_status, 'S') <> 'E' and
319: tmp.object_id = tskt.source_object_id and

Line 346: , JTF_OBJECT_PURGE_PARAM_TMP tmp

342: CSF_DEBRIEF_LINES dbfl
343: , CSF_DEBRIEF_HEADERS dbfh
344: , JTF_TASK_ASSIGNMENTS tska
345: , JTF_TASKS_B tskt
346: , JTF_OBJECT_PURGE_PARAM_TMP tmp
347: WHERE
348: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
349: nvl(tmp.purge_status, 'S') <> 'E' and
350: tmp.object_id = tskt.source_object_id and

Line 373: , JTF_OBJECT_PURGE_PARAM_TMP tmp

369: FROM
370: CSF_DEBRIEF_HEADERS dbfh
371: , JTF_TASK_ASSIGNMENTS tska
372: , JTF_TASKS_B tskt
373: , JTF_OBJECT_PURGE_PARAM_TMP tmp
374: WHERE
375: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
376: nvl(tmp.purge_status, 'S') <> 'E' and
377: tmp.object_id = tskt.source_object_id and

Line 399: , JTF_OBJECT_PURGE_PARAM_TMP tmp

395: CSP_REQ_LINE_DETAILS csprdt
396: , CSP_REQUIREMENT_LINES csprl
397: , CSP_REQUIREMENT_HEADERS csprh
398: , JTF_TASKS_B tskt
399: , JTF_OBJECT_PURGE_PARAM_TMP tmp
400: WHERE
401: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
402: nvl(tmp.purge_status, 'S') <> 'E' and
403: tmp.object_id = tskt.source_object_id and

Line 422: , JTF_OBJECT_PURGE_PARAM_TMP tmp

418: FROM
419: CSP_REQUIREMENT_LINES csprl
420: , CSP_REQUIREMENT_HEADERS csprh
421: , JTF_TASKS_B tskt
422: , JTF_OBJECT_PURGE_PARAM_TMP tmp
423: WHERE
424: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
425: nvl(tmp.purge_status, 'S') <> 'E' and
426: tmp.object_id = tskt.source_object_id and

Line 444: , JTF_OBJECT_PURGE_PARAM_TMP tmp

440: csprh.requirement_header_id
441: FROM
442: CSP_REQUIREMENT_HEADERS csprh
443: , JTF_TASKS_B tskt
444: , JTF_OBJECT_PURGE_PARAM_TMP tmp
445: WHERE
446: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
447: nvl(tmp.purge_status, 'S') <> 'E' and
448: tmp.object_id = tskt.source_object_id and

Line 468: , JTF_OBJECT_PURGE_PARAM_TMP tmp

464: csfsk.required_skill_id
465: FROM
466: CSF_REQUIRED_SKILLS_B csfsk
467: , JTF_TASKS_B tskt
468: , JTF_OBJECT_PURGE_PARAM_TMP tmp
469: WHERE
470: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
471: nvl(tmp.purge_status, 'S') <> 'E' and
472: tmp.object_id = tskt.source_object_id and

Line 492: , JTF_OBJECT_PURGE_PARAM_TMP tmp

488: csacc.task_id
489: FROM
490: CSF_ACCESS_HOURS_B csacc
491: , JTF_TASKS_B tskt
492: , JTF_OBJECT_PURGE_PARAM_TMP tmp
493: WHERE
494: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
495: nvl(tmp.purge_status, 'S') <> 'E' and
496: tmp.object_id = tskt.source_object_id and

Line 511: , JTF_OBJECT_PURGE_PARAM_TMP tmp

507: csacc.access_hour_id
508: FROM
509: CSF_ACCESS_HOURS_B csacc
510: , JTF_TASKS_B tskt
511: , JTF_OBJECT_PURGE_PARAM_TMP tmp
512: WHERE
513: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
514: nvl(tmp.purge_status, 'S') <> 'E' and
515: tmp.object_id = tskt.source_object_id and

Line 536: , JTF_OBJECT_PURGE_PARAM_TMP tmp

532: FROM
533: CSF_R_PLAN_OPTIONS csactl
534: , CSF_R_PLAN_OPTION_TASKS csacc
535: , JTF_TASKS_B tskt
536: , JTF_OBJECT_PURGE_PARAM_TMP tmp
537: WHERE
538: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
539: nvl(tmp.purge_status, 'S') <> 'E' and
540: tmp.object_id = tskt.source_object_id and

Line 556: , JTF_OBJECT_PURGE_PARAM_TMP tmp

552: csacc.task_id
553: FROM
554: CSF_R_PLAN_OPTION_TASKS csacc
555: , JTF_TASKS_B tskt
556: , JTF_OBJECT_PURGE_PARAM_TMP tmp
557: WHERE
558: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
559: nvl(tmp.purge_status, 'S') <> 'E' and
560: tmp.object_id = tskt.source_object_id and

Line 581: , JTF_OBJECT_PURGE_PARAM_TMP tmp

577: FROM
578: CSF_R_SCHED_REQUESTS csactl
579: , CSF_R_REQUEST_TASKS csacc
580: , JTF_TASKS_B tskt
581: , JTF_OBJECT_PURGE_PARAM_TMP tmp
582: WHERE
583: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
584: nvl(tmp.purge_status, 'S') <> 'E' and
585: tmp.object_id = tskt.source_object_id and

Line 601: , JTF_OBJECT_PURGE_PARAM_TMP tmp

597: csacc.REQUEST_TASK_ID
598: FROM
599: CSF_R_REQUEST_TASKS csacc
600: , JTF_TASKS_B tskt
601: , JTF_OBJECT_PURGE_PARAM_TMP tmp
602: WHERE
603: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
604: nvl(tmp.purge_status, 'S') <> 'E' and
605: tmp.object_id = tskt.source_object_id and

Line 625: , JTF_OBJECT_PURGE_PARAM_TMP tmp

621: FROM
622: CSF_R_SPARES_OPTIONS csactl
623: , CSF_R_RESOURCE_RESULTS csacc
624: , JTF_TASKS_B tskt
625: , JTF_OBJECT_PURGE_PARAM_TMP tmp
626: WHERE
627: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
628: nvl(tmp.purge_status, 'S') <> 'E' and
629: tmp.object_id = tskt.source_object_id and

Line 645: , JTF_OBJECT_PURGE_PARAM_TMP tmp

641: csacc.REQUEST_TASK_ID
642: FROM
643: CSF_R_RESOURCE_RESULTS csacc
644: , JTF_TASKS_B tskt
645: , JTF_OBJECT_PURGE_PARAM_TMP tmp
646: WHERE
647: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
648: nvl(tmp.purge_status, 'S') <> 'E' and
649: tmp.object_id = tskt.source_object_id and

Line 671: , JTF_OBJECT_PURGE_PARAM_TMP tmp

667: FROM
668: CSF_R_MESSAGE_TOKENS csactl
669: , CSF_R_MESSAGES csacc
670: , JTF_TASKS_B tskt
671: , JTF_OBJECT_PURGE_PARAM_TMP tmp
672: WHERE
673: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
674: nvl(tmp.purge_status, 'S') <> 'E' and
675: tmp.object_id = tskt.source_object_id and

Line 691: , JTF_OBJECT_PURGE_PARAM_TMP tmp

687: csacc.REQUEST_TASK_ID
688: FROM
689: CSF_R_MESSAGES csacc
690: , JTF_TASKS_B tskt
691: , JTF_OBJECT_PURGE_PARAM_TMP tmp
692: WHERE
693: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and
694: nvl(tmp.purge_status, 'S') <> 'E' and
695: tmp.object_id = tskt.source_object_id and

Line 712: , JTF_OBJECT_PURGE_PARAM_TMP tmp

708: (select cac.object_capacity_id
709: from
710: cac_sr_object_capacity cac
711: , JTF_TASKS_B tskt
712: , JTF_OBJECT_PURGE_PARAM_TMP tmp
713: , jtf_Task_assignments jtt
714: , jtf_task_statuses_b jtfts
715: WHERE
716: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and

Line 757: , JTF_OBJECT_PURGE_PARAM_TMP tmp

753: (select cac.object_capacity_id
754: from
755: cac_sr_object_capacity cac
756: , JTF_TASKS_B tskt
757: , JTF_OBJECT_PURGE_PARAM_TMP tmp
758: , jtf_Task_assignments jtt
759: , jtf_task_statuses_b jtfts
760: WHERE
761: tmp.PROCESSING_SET_ID = P_PROCESSING_SET_ID and