APPS.CSM_HA_EVENT_PKG dependencies on CSF_ACCESS_HOURS_B

Line 984: --CSF_ACCESS_HOURS_B

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
985:
986: l_pk_name_list(1):= 'ACCESS_HOUR_ID';
987: l_pk_type_list(1):= 'NUMBER';
988:

Line 990: FROM CSF_ACCESS_HOURS_B

986: l_pk_name_list(1):= 'ACCESS_HOUR_ID';
987: l_pk_type_list(1):= 'NUMBER';
988:
989: FOR rec IN (SELECT ACCESS_HOUR_ID
990: FROM CSF_ACCESS_HOURS_B
991: WHERE CREATION_DATE >= G_HA_START_TIME)
992: LOOP
993: l_pk_value_list(1):=rec.ACCESS_HOUR_ID;
994: TRACK_HA_RECORD('CSF_ACCESS_HOURS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

Line 994: TRACK_HA_RECORD('CSF_ACCESS_HOURS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

990: FROM CSF_ACCESS_HOURS_B
991: WHERE CREATION_DATE >= G_HA_START_TIME)
992: LOOP
993: l_pk_value_list(1):=rec.ACCESS_HOUR_ID;
994: TRACK_HA_RECORD('CSF_ACCESS_HOURS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
995: END LOOP;
996:
997: FOR rec IN (SELECT ACCESS_HOUR_ID
998: FROM CSF_ACCESS_HOURS_B

Line 998: FROM CSF_ACCESS_HOURS_B

994: TRACK_HA_RECORD('CSF_ACCESS_HOURS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
995: END LOOP;
996:
997: FOR rec IN (SELECT ACCESS_HOUR_ID
998: FROM CSF_ACCESS_HOURS_B
999: WHERE CREATION_DATE < G_HA_START_TIME
1000: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
1001: LOOP
1002: l_pk_value_list(1):=rec.ACCESS_HOUR_ID;

Line 1003: TRACK_HA_RECORD('CSF_ACCESS_HOURS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');

999: WHERE CREATION_DATE < G_HA_START_TIME
1000: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
1001: LOOP
1002: l_pk_value_list(1):=rec.ACCESS_HOUR_ID;
1003: TRACK_HA_RECORD('CSF_ACCESS_HOURS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');
1004: END LOOP;
1005:
1006: CSM_UTIL_PKG.LOG('Recording Required Skills','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
1007: --CSF_REQUIRED_SKILLS_B