DBA Data[Home] [Help]

APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSL_CS_INCIDENTS_ALL_ACC_PKG

Line 450: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

446: , 'Calling Non-critical dependent hooks'
447: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
448: END IF;
449: -- NOTES/COUNTERS ( do not replicate notes/counters for history instances )
450: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
451: l_return := CSL_JTF_NOTES_ACC_PKG.PRE_INSERT_CHILDREN
452: ( P_SOURCE_OBJ_ID => p_instance_id
453: , P_SOURCE_OBJ_CODE => 'CP'
454: , P_RESOURCE_ID => p_resource_id );

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

544: acc table ***/
545: PROCEDURE Delete_ACC_Record
546: ( p_instance_id IN NUMBER
547: ,p_resource_id IN NUMBER
548: ,p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
549: IS
550: CURSOR c_ii( b_instance_id NUMBER ) IS
551: SELECT inventory_item_id
552: , inv_organization_id

Line 589: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

585: );
586:
587:
588: -- NOTES/COUNTERS ( notes/counters for history instances are not replicated so don't delete )
589: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
590: -- NOTES
591: CSL_JTF_NOTES_ACC_PKG.POST_DELETE_CHILDREN
592: ( P_SOURCE_OBJ_ID => p_instance_id
593: , P_SOURCE_OBJ_CODE => 'CP'

Line 676: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

672: -- Insert IB (child_instance_id)
673: Insert_ACC_Record
674: ( r_child_instance.subject_id
675: , p_resource_id
676: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
677: );
678:
679: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
680: jtm_message_log_pkg.Log_Msg

Line 736: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

732: -- Insert IB (parent_instance_id)
733: Insert_ACC_Record
734: ( r_parent_instance.object_id
735: , p_resource_id
736: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
737: );
738:
739: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
740: jtm_message_log_pkg.Log_Msg

Line 768: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

764: BEGIN
765: IF Replicate_Record ( p_instance_id , p_resource_id) THEN
766:
767: /*Do not replicate parent for history*/
768: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
769: Insert_Parents ( p_instance_id ,p_resource_id );
770: END IF; -- p_flow_type
771:
772: Insert_ACC_Record ( p_instance_id ,p_resource_id ,p_flow_type);

Line 775: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN

771:
772: Insert_ACC_Record ( p_instance_id ,p_resource_id ,p_flow_type);
773:
774: /*Do not replicate parent/childs for history*/
775: IF p_flow_type <> CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_HISTORY THEN
776: Insert_Childs ( p_instance_id ,p_resource_id);
777: END IF; --p_flow_type
778: END IF;
779: END insert_ib_parent_child;

Line 786: p_flow_type - DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

782: /***
783: Public function that gets called when an item instance needs to be inserted
784: into ACC table.
785: Returns TRUE when record already was or has been inserted into ACC table.
786: p_flow_type - DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
787: ***/
788:
789: FUNCTION Pre_Insert_Child
790: ( p_instance_id IN NUMBER

Line 988: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

984: -- Delete IB (child_instance_id)
985: Delete_ACC_Record
986: ( r_child_instance.subject_id
987: , p_resource_id
988: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
989: );
990:
991: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
992: jtm_message_log_pkg.Log_Msg

Line 1046: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

1042: -- Delete IB (child_instance_id)
1043: Delete_ACC_Record
1044: ( r_parent_instance.object_id
1045: , p_resource_id
1046: , CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1047: );
1048:
1049: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
1050: jtm_message_log_pkg.Log_Msg

Line 1073: p_flow_type - DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

1069:
1070: /***
1071: Public procedure that gets called when an item instance needs to be
1072: deleted from ACC table.
1073: p_flow_type - DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1074: ***/
1075: PROCEDURE Post_Delete_Child
1076: ( p_instance_id IN NUMBER
1077: ,p_resource_id IN NUMBER

Line 1351: , p_flow_type => CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

1347: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
1348: END IF;
1349: Insert_ACC_Record( p_instance_id => p_instance_id
1350: , p_resource_id => r_is_parent.resource_id
1351: , p_flow_type => CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1352: );
1353: END LOOP;
1354:
1355: /*Is this a child ?*/

Line 1367: , p_flow_type => CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL

1363: END IF;
1364:
1365: Insert_ACC_Record( p_instance_id => p_instance_id
1366: , p_resource_id => r_is_child.resource_id
1367: , p_flow_type => CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL
1368: );
1369: END LOOP;
1370:
1371: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN