958: END LOOP;
959:
960:
961: CSM_UTIL_PKG.LOG('Recording CUG INCIDENT ATTRIBUTES Data','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
962: -- CUG_INCIDNT_ATTR_VALS_B
963: l_pk_name_list(1):= 'INCIDNT_ATTR_VAL_ID';
964: l_pk_type_list(1):= 'NUMBER';
965:
966: FOR rec IN (SELECT INCIDNT_ATTR_VAL_ID
963: l_pk_name_list(1):= 'INCIDNT_ATTR_VAL_ID';
964: l_pk_type_list(1):= 'NUMBER';
965:
966: FOR rec IN (SELECT INCIDNT_ATTR_VAL_ID
967: FROM CUG_INCIDNT_ATTR_VALS_B
968: WHERE CREATION_DATE >= G_HA_START_TIME)
969: LOOP
970: l_pk_value_list(1):=rec.INCIDNT_ATTR_VAL_ID;
971: TRACK_HA_RECORD('CUG_INCIDNT_ATTR_VALS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
967: FROM CUG_INCIDNT_ATTR_VALS_B
968: WHERE CREATION_DATE >= G_HA_START_TIME)
969: LOOP
970: l_pk_value_list(1):=rec.INCIDNT_ATTR_VAL_ID;
971: TRACK_HA_RECORD('CUG_INCIDNT_ATTR_VALS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
972: END LOOP;
973:
974: FOR rec IN (SELECT INCIDNT_ATTR_VAL_ID
975: FROM CUG_INCIDNT_ATTR_VALS_B
971: TRACK_HA_RECORD('CUG_INCIDNT_ATTR_VALS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
972: END LOOP;
973:
974: FOR rec IN (SELECT INCIDNT_ATTR_VAL_ID
975: FROM CUG_INCIDNT_ATTR_VALS_B
976: WHERE CREATION_DATE < G_HA_START_TIME
977: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
978: LOOP
979: l_pk_value_list(1):=rec.INCIDNT_ATTR_VAL_ID;
976: WHERE CREATION_DATE < G_HA_START_TIME
977: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
978: LOOP
979: l_pk_value_list(1):=rec.INCIDNT_ATTR_VAL_ID;
980: TRACK_HA_RECORD('CUG_INCIDNT_ATTR_VALS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');
981: END LOOP;
982:
983: CSM_UTIL_PKG.LOG('Recording Access Hours','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
984: --CSF_ACCESS_HOURS_B