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.

[Home] [Help]

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.14 2011/12/15 18:55:42 hhaugeru ship $ */
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 313: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');

309: DBFH.DEBRIEF_HEADER_ID = JTFNB.SOURCE_OBJECT_ID AND
310: JTFNB.SOURCE_OBJECT_CODE = 'SD' );
311:
312: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
313: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task notes and note related objs ');
314: END IF;
315:
316: /* Step 2 - Delete relevant debrief lines and debrief line related objects:
317: 1) CSF_DEBRIEF_LINES

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

335: AND TSKA.TASK_ASSIGNMENT_ID = DBFH.TASK_ASSIGNMENT_ID
336: AND DBFH.DEBRIEF_HEADER_ID = DBFL.DEBRIEF_HEADER_ID );
337:
338: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
339: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debriefed line details ');
340: END IF;
341:
342:
343: /* Step 3 - Delete relevant debrief headers*/

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

351: AND TMP.OBJECT_TYPE = TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID =
352: TSKA.TASK_ID AND TSKA.TASK_ASSIGNMENT_ID = DBFH.TASK_ASSIGNMENT_ID );
353:
354: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
355: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task debrief header details ');
356: END IF;
357:
358: /* Step 4 - Delete relevant requirement line details */
359: DELETE /*+ index(crld) */ FROM CSP_REQ_LINE_DETAILS crld

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

422: );
423:
424:
425: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task requirement headers and lines ');
427: END IF;
428:
429: /* Step 7 - Delete relevant required skills */
430: DELETE /*+ index(crsb) */ FROM CSF_REQUIRED_SKILLS_B CRSB

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

437: TSKT.SOURCE_OBJECT_TYPE_CODE AND TSKT.TASK_ID = CSFSK.HAS_SKILL_ID AND
438: CSFSK.HAS_SKILL_TYPE = 'TASK' );
439:
440: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
441: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task required skills ');
442: END IF;
443:
444: /* Step 8 - Delete Access Hours */
445: DELETE /*+ index(caht) */ FROM CSF_ACCESS_HOURS_TL caht

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

480: );
481:
482:
483: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task access hours details ');
485: END IF;
486:
487:
488: /* Step 9 - Delete Plan Options */

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

507: CSACC.TASK_ID );
508:
509:
510: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
511: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task plan options ');
512: END IF;
513:
514: /* Step 10 - Delete Resource Results */
515: DELETE /*+ index(crso) */ FROM CSF_R_SPARES_OPTIONS CRSO

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

536: CSACC.REQUEST_TASK_ID=CSRR.REQUEST_TASK_ID);
537:
538:
539: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
540: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task resource results ');
541: END IF;
542:
543: --Fetching all the available schedule request id including parent.
544: OPEN c_fetch_sched_req_id;

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

571: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID AND
572: CSACC.REQUEST_TASK_ID=CSRM.REQUEST_TASK_ID);
573:
574: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
575: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task messages and message tokens ');
576: END IF;
577:
578: /* Step 12 - Delete Request Task */
579: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last

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

587: CSCHR.SCHED_REQUEST_ID = CSACC.SCHED_REQUEST_ID);
588:
589:
590: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
591: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS task scheduled requests tasks');
592: END IF;
593:
594: /* Step 13 - Delete Schedule Requests */
595: --FORALL i in l_tab_sched_req_id.first..l_tab_sched_req_id.last

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

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 ');
603: END IF;
604:
605: delete cac_sr_object_capacity
606: where object_capacity_id in

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

668: nvl(jtfts.completed_flag,'N') = 'Y' or
669: nvl(jtfts.cancelled_flag,'N') = 'Y'));
670:
671: if((FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
672: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'CSF', 'In CSF_MAINTAIN_GRP.Purge_FieldServiceObjects() deleted FS capacities ');
673: END IF;
674:
675:
676: -- Standard check of p_commit

Line 706: End CSF_MAINTAIN_GRP;

702:
703: END;
704:
705: -- Enter further code below as specified in the Package spec.
706: End CSF_MAINTAIN_GRP;
707: