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 CSF_MAINTAIN_GRP

Line 1: PACKAGE BODY CSF_MAINTAIN_GRP as

1: PACKAGE BODY CSF_MAINTAIN_GRP as
2: /* $Header: csfpurgb.pls 120.9 2006/05/10 10:13:38 hhaugeru noship $ */
3: --
4: -- To modify this template, edit file PKGBODY.TXT in TEMPLATE
5: -- directory of SQL Navigator

Line 14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_MAINTAIN_GRP';

10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter package declarations as shown below
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSF_MAINTAIN_GRP';
15:
16: PROCEDURE Validate_FieldServiceObjects(
17: P_API_VERSION IN NUMBER,
18: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,

Line 96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after first validation ');

92: )
93: and nvl(purge_status, 'S') <> 'E';
94:
95: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after first validation ');
97: END IF;
98: /* Step 2: Mark SRs (for the given p_processing_set_id) as NOT a delete candidate
99: IF the SR is linked to mobile FS tasks that CANNOT be deleted
100: */

Line 163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after third validation ');

159: )
160: and nvl(purge_status, 'S') <> 'E';
161:
162: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
163: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Validate_FieldServiceObjects() after third validation ');
164: END IF;
165:
166: -- Standard check of p_commit
167: -- IF fnd_api.to_boolean(p_commit) THEN

Line 328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');

324: jtfnb.source_object_code = 'DF'
325: );
326:
327: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
328: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');
329: END IF;
330:
331: /* Step 2 - Delete relevant debrief lines and debrief line related objects:
332: 1) CSF_DEBRIEF_LINES

Line 358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debriefed line details ');

354: dbfh.debrief_header_id = dbfl.debrief_header_id
355: );
356:
357: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
358: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debriefed line details ');
359: END IF;
360:
361:
362: /* Step 3 - Delete relevant debrief headers*/

Line 384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');

380: tska.task_assignment_id = dbfh.task_assignment_id
381: );
382:
383: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
384: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');
385: END IF;
386:
387: /* Step 4 - Delete relevant requirement line details */
388: DELETE /*+ index(crld) */ FROM CSP_REQ_LINE_DETAILS crld

Line 455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');

451: );
452:
453:
454: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
455: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');
456: END IF;
457:
458: /* Step 7 - Delete relevant required skills */
459: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B crsb

Line 479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');

475: csfsk.has_skill_type = 'TASK'
476: );
477:
478: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
479: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');
480: END IF;
481:
482: /* Step 8 - Delete Access Hours */
483: DELETE /*+ index(cahb) */ FROM CSF_ACCESS_HOURS_B cahb

Line 521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task access hours details ');

517: tskt.task_id = csacc.task_id
518: );
519:
520: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task access hours details ');
522: END IF;
523:
524:
525: /* Step 9 - Delete Plan Options */

Line 567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');

563: );
564:
565:
566: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
567: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');
568: END IF;
569:
570: /* Step 10 - Delete Schedule Requests */
571: DELETE /*+ index(crsr) */ FROM CSF_R_SCHED_REQUESTS crsr

Line 611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');

607: tskt.task_id = csacc.REQUEST_TASK_ID
608: );
609:
610: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
611: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests ');
612: END IF;
613:
614: /* Step 11 - Delete Resource Results */
615: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS crso

Line 656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task resource results ');

652: );
653:
654:
655: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
656: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task resource results ');
657: END IF;
658:
659:
660: /* Step 12 - Delete Messages and Message Tokens */

Line 701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task messages and message tokens ');

697: tskt.task_id = csacc.REQUEST_TASK_ID
698: );
699:
700: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task messages and message tokens ');
702: END IF;
703:
704:
705:

Line 773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS capacities ');

769: nvl(jtfts.completed_flag,'N') = 'Y' or
770: nvl(jtfts.cancelled_flag,'N') = 'Y'));
771:
772: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS capacities ');
774: END IF;
775:
776:
777: -- Standard check of p_commit

Line 807: End CSF_MAINTAIN_GRP;

803:
804: END;
805:
806: -- Enter further code below as specified in the Package spec.
807: End CSF_MAINTAIN_GRP;
808: