APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG dependencies on CSM_CSI_ITEM_ATTR_ACC

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

11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';

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

12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_CSI_ITEM_ATTR');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'ATTRIBUTE_VALUE_ID';
20: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_CSI_ITEM_ATTR';

Line 67: FROM CSM_CSI_ITEM_ATTR_ACC acc

63: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
64: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
65: AND NOT EXISTS
66: (SELECT 1
67: FROM CSM_CSI_ITEM_ATTR_ACC acc
68: WHERE acc.user_id = ii_acc.user_id
69: AND acc.attribute_value_id = attrval.attribute_value_id
70: );
71:

Line 77: FROM csm_csi_item_attr_acc acc,

73: CURSOR l_csi_iea_values_upd_csr(p_last_upd_date DATE)
74: IS
75: SELECT acc.access_id,
76: acc.user_id
77: FROM csm_csi_item_attr_acc acc,
78: csi_iea_values attrval,
79: csi_i_extended_attribs attr
80: WHERE acc.attribute_value_id = attrval.attribute_value_id
81: AND attrval.attribute_id = attr.attribute_id

Line 92: FROM csm_csi_item_attr_acc acc

88: IS
89: SELECT acc.access_id,
90: acc.attribute_value_id,
91: acc.user_id
92: FROM csm_csi_item_attr_acc acc
93: WHERE NOT EXISTS
94: (SELECT 1
95: FROM csm_item_instances_acc ii_acc,
96: csi_item_instances cii,