DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on CUG_INCIDNT_ATTR_VALS_B

Line 962: -- CUG_INCIDNT_ATTR_VALS_B

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

Line 967: FROM 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
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');

Line 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

Line 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;

Line 980: TRACK_HA_RECORD('CUG_INCIDNT_ATTR_VALS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');

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