APPS.CSM_CSI_ITEM_ATTR_EVENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

l_updates_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

Line: 27

l_inserts_cur CSM_UTIL_PKG.Changed_Records_Cur_Type;

Line: 30

l_prog_update_date jtm_con_request_data.last_run_date%TYPE;

Line: 44

SELECT nvl(last_run_date, (sysdate - 365*50))
FROM jtm_con_request_data
WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'
AND procedure_name = 'REFRESH_ACC';

Line: 52

SELECT attrval.attribute_value_id,
      ii_acc.instance_id,
      ii_acc.user_id
FROM csm_item_instances_acc ii_acc,
     csi_item_instances cii,
     csi_iea_values attrval,
     csi_i_extended_attribs attr
WHERE ii_acc.instance_id = cii.instance_id
AND cii.location_type_code <> 'INVENTORY'
AND attrval.instance_id = cii.instance_id
AND attrval.attribute_id = attr.attribute_id
AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
AND NOT EXISTS
(SELECT 1
 FROM CSM_CSI_ITEM_ATTR_ACC acc
 WHERE acc.user_id = ii_acc.user_id
 AND acc.attribute_value_id = attrval.attribute_value_id
 );

Line: 75

SELECT acc.access_id,
       acc.user_id
FROM csm_csi_item_attr_acc acc,
     csi_iea_values attrval,
     csi_i_extended_attribs attr
WHERE acc.attribute_value_id = attrval.attribute_value_id
AND attrval.attribute_id = attr.attribute_id
AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
AND attrval.last_update_date > p_last_upd_date;

Line: 89

SELECT acc.access_id,
       acc.attribute_value_id,
       acc.user_id
FROM csm_csi_item_attr_acc acc
WHERE NOT EXISTS
(SELECT 1
 FROM csm_item_instances_acc ii_acc,
     csi_item_instances cii,
     csi_iea_values attrval,
     csi_i_extended_attribs attr
WHERE ii_acc.instance_id = cii.instance_id
AND cii.location_type_code <> 'INVENTORY'
AND attrval.instance_id = cii.instance_id
AND attrval.attribute_id = attr.attribute_id
AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)
AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
);

Line: 113

 FETCH l_last_run_date_csr INTO l_prog_update_date;

Line: 118

   CSM_ACC_PKG.Delete_acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_PK1_NAME               => g_pk1_name1
      ,P_PK1_NUM_VALUE          => r_csi_iea_values_del_rec.attribute_value_id
      ,P_USER_ID                => r_csi_iea_values_del_rec.user_id
      );

Line: 128

 FOR r_csi_iea_values_upd_rec IN l_csi_iea_values_upd_csr(l_prog_update_date) LOOP
   CSM_ACC_PKG.Update_acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_ACCESS_ID              => r_csi_iea_values_upd_rec.access_id
      ,P_USER_ID                => r_csi_iea_values_upd_rec.user_id
      );

Line: 139

     CSM_ACC_PKG.Insert_Acc
     ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
      ,P_ACC_TABLE_NAME         => g_acc_table_name1
      ,P_SEQ_NAME               => g_acc_sequence_name1
      ,P_PK1_NAME               => g_pk1_name1
      ,P_PK1_NUM_VALUE          => r_csi_iea_values_ins_rec.attribute_value_id
      ,P_USER_ID                => r_csi_iea_values_ins_rec.user_id
     );

Line: 150

  UPDATE jtm_con_request_data
  SET last_run_date = l_run_date
  WHERE package_name = 'CSM_CSI_ITEM_ATTR_EVENT_PKG'
    AND procedure_name = 'REFRESH_ACC';