APPS.CSM_SR_EVENT_PKG dependencies on CSM_CSI_ITEM_ATTR_ACC

Line 18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';

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:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';

Line 19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';

15: CSM_ACC_PKG.t_publication_item_list('CSM_INCIDENTS_ALL');
16:
17: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
18: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
19: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
20: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
21: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
22: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
23: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';

Line 746: AND EXISTS(SELECT 1 FROM CSM_CSI_ITEM_ATTR_ACC acc

742: FROM csi_iea_values attrval,
743: csi_i_extended_attribs attr
744: WHERE attrval.instance_id = p_instance_id
745: AND attrval.attribute_id = attr.attribute_id
746: AND EXISTS(SELECT 1 FROM CSM_CSI_ITEM_ATTR_ACC acc
747: WHERE acc.attribute_value_id = attrval.attribute_value_id
748: AND acc.USER_ID=p_user_id);
749:
750: l_htm5_user BOOLEAN:= CSM_UTIL_PKG.IS_HTML5_USER(p_user_id );