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 904: FROM csm_incidents_all_acc acc

900: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION');
901: --not required as counter is important
902: /*AND NOT EXISTS
903: (SELECT 1
904: FROM csm_incidents_all_acc acc
905: WHERE acc.incident_id = csi.incident_id
906: AND acc.user_id = CSM_UTIL_PKG.get_group_owner(csi.owner_group_id));*/
907:
908:

Line 1151: FROM csm_incidents_all_acc acc

1147: WHERE csi.incident_id = p_incident_id
1148: AND nvl(csi.incident_location_type,'HZ_PARTY_SITE') IN ('HZ_PARTY_SITE','HZ_LOCATION')
1149: AND EXISTS
1150: (SELECT 1
1151: FROM csm_incidents_all_acc acc
1152: WHERE acc.incident_id = csi.incident_id
1153: 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)) ));
1154:
1155: l_sr_rec l_sr_csr%ROWTYPE;

Line 1396: FROM csm_incidents_all_acc acc

1392:
1393: CURSOR l_csm_task_assg_csr (p_incident_id cs_incidents_all_b.incident_id%TYPE)
1394: IS
1395: SELECT acc.access_id, acc.user_id
1396: FROM csm_incidents_all_acc acc
1397: WHERE acc.incident_id = p_incident_id;
1398:
1399:
1400: BEGIN