APPS.CSL_JTF_TASKS_ACC_PKG dependencies on CSL_CS_INCIDENTS_ALL_ACC_PKG

Line 212: ,p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

208: /*** Private procedure that replicates given task related data for resource ***/
209: PROCEDURE Insert_ACC_Record
210: ( p_task_id IN NUMBER
211: ,p_resource_id IN NUMBER
212: ,p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
213: IS
214: l_return BOOLEAN;
215:
216: CURSOR c_task( b_task_id NUMBER ) IS

Line 259: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

255: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
256: END IF;
257:
258: /*Do not replicate notes for history tasks*/
259: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
260: --NOTES
261: l_return := CSL_JTF_NOTES_ACC_PKG.PRE_INSERT_CHILDREN
262: ( P_SOURCE_OBJ_ID => p_task_id
263: , P_SOURCE_OBJ_CODE => 'TASK'

Line 385: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

381: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
382: END IF;
383:
384: /*Notes are not replicated for history so we do not need to delete them*/
385: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
386: --NOTES
387: CSL_JTF_NOTES_ACC_PKG.POST_DELETE_CHILDREN( P_SOURCE_OBJ_ID => p_task_id
388: , P_SOURCE_OBJ_CODE => 'TASK'
389: , P_RESOURCE_ID => p_resource_id );

Line 426: ,p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

422: ***/
423: FUNCTION Pre_Insert_Child
424: ( p_task_id IN NUMBER
425: ,p_resource_id IN NUMBER
426: ,p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
427: RETURN BOOLEAN
428: IS
429: l_acc_id NUMBER;
430: l_success BOOLEAN;

Line 447: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

443:
444: l_success := FALSE;
445:
446: /*** is this a history record? ***/
447: IF p_flow_type = CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
448: /*** yes -> replicate without further checking ***/
449: l_success := TRUE;
450: ELSE
451: /*** SR task? ***/

Line 460: IF CSL_CS_INCIDENTS_ALL_ACC_PKG.Pre_Insert_Child( l_incident_id, p_resource_id, p_flow_type) THEN

456: /*** no -> replicate personal task ***/
457: l_success := TRUE;
458: ELSE
459: /*** yes -> insert parent SR ***/
460: IF CSL_CS_INCIDENTS_ALL_ACC_PKG.Pre_Insert_Child( l_incident_id, p_resource_id, p_flow_type) THEN
461: /*** yes -> replicate task ***/
462: l_success := TRUE;
463: END IF;
464: END IF;

Line 494: ,p_flow_type IN NUMBER )--DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

490: ***/
491: PROCEDURE Post_Delete_Child
492: ( p_task_id IN NUMBER
493: ,p_resource_id IN NUMBER
494: ,p_flow_type IN NUMBER )--DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
495: IS
496: l_incident_id NUMBER;
497: BEGIN
498: /*** get debug level ***/

Line 520: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child'

516: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
517: jtm_message_log_pkg.Log_Msg
518: ( p_task_id
519: , g_table_name
520: , 'Calling CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child'
521: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
522: END IF;
523:
524: /*Do not delete sr when history, flow is sr -> task -> assignment */

Line 525: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

521: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
522: END IF;
523:
524: /*Do not delete sr when history, flow is sr -> task -> assignment */
525: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
526: /* delete the dependant SR */
527: l_incident_id := GetParentId( p_task_id);
528: IF l_incident_id <> -1 THEN
529: CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child( l_incident_id, p_resource_id );

Line 529: CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child( l_incident_id, p_resource_id );

525: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
526: /* delete the dependant SR */
527: l_incident_id := GetParentId( p_task_id);
528: IF l_incident_id <> -1 THEN
529: CSL_CS_INCIDENTS_ALL_ACC_PKG.Post_Delete_Child( l_incident_id, p_resource_id );
530: END IF;
531: END IF;
532:
533: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

Line 593: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

589: JTM_HOOK_UTIL_PKG.isMobileFSresource(r_task.RESOURCE_ID) = TRUE THEN
590: Insert_ACC_Record
591: ( l_task_id
592: , r_task.RESOURCE_ID
593: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
594: );
595: END IF;--Type = SR
596: END IF;--c_task%FOUND
597: CLOSE c_task;

Line 916: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

912: FOR r_task IN c_task( p_resource_id ) LOOP
913: Insert_ACC_Record
914: ( r_task.task_id
915: , p_resource_id
916: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
917: );
918: END LOOP;
919:
920: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN