APPS.CSM_SR_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC

Line 10: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';

6: -- --------- ------ ------------------------------------------
7: -- Melvin P 05/02/02 Base creation
8: -- Enter procedure, function bodies as shown below
9: /*** Globals ***/
10: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';
11: g_incidents_table_name CONSTANT VARCHAR2(30) := 'CS_INCIDENTS_ALL';
12: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;
13: g_incidents_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
14: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 12: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;

8: -- Enter procedure, function bodies as shown below
9: /*** Globals ***/
10: g_incidents_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC';
11: g_incidents_table_name CONSTANT VARCHAR2(30) := 'CS_INCIDENTS_ALL';
12: g_incidents_seq_name CONSTANT VARCHAR2(30) := 'CSM_INCIDENTS_ALL_ACC_S' ;
13: g_incidents_pk1_name CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
14: g_incidents_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_INCIDENTS_ALL');
16:

Line 49: FROM csm_incidents_all_acc acc,

45: IS
46: SELECT acc.incident_id,
47: acc.user_id,
48: acc.counter
49: FROM csm_incidents_all_acc acc,
50: cs_incidents_all_b inc,
51: cs_incident_statuses_b ists
52: WHERE inc.incident_id = acc.incident_id
53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),

Line 888: FROM csm_incidents_all_acc acc

884: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION');
885: --not required as counter is important
886: /*AND NOT EXISTS
887: (SELECT 1
888: FROM csm_incidents_all_acc acc
889: WHERE acc.incident_id = csi.incident_id
890: AND acc.user_id = CSM_UTIL_PKG.get_group_owner(csi.owner_group_id));*/
891:
892:

Line 1128: FROM csm_incidents_all_acc acc

1124: WHERE csi.incident_id = p_incident_id
1125: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION')
1126: AND EXISTS
1127: (SELECT 1
1128: FROM csm_incidents_all_acc acc
1129: WHERE acc.incident_id = csi.incident_id
1130: AND acc.user_id = NVL(b_user_id,decode(CSM_UTIL_PKG.get_group_owner(csi.owner_group_id),-1,csi.created_by,CSM_UTIL_PKG.get_group_owner(csi.owner_group_id)) ));
1131:
1132: l_sr_rec l_sr_csr%ROWTYPE;

Line 1374: FROM csm_incidents_all_acc acc

1370:
1371: CURSOR l_csm_task_assg_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
1372: IS
1373: SELECT acc.access_id, acc.user_id
1374: FROM csm_incidents_all_acc acc
1375: WHERE acc.incident_id = p_incident_id;
1376:
1377:
1378: BEGIN