APPS.CSM_HA_EVENT_PKG dependencies on CSF_REQUIRED_SKILLS_B

Line 1007: --CSF_REQUIRED_SKILLS_B

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
1008:
1009: l_pk_name_list(1):= 'REQUIRED_SKILL_ID';
1010: l_pk_type_list(1):= 'NUMBER';
1011:

Line 1013: FROM CSF_REQUIRED_SKILLS_B

1009: l_pk_name_list(1):= 'REQUIRED_SKILL_ID';
1010: l_pk_type_list(1):= 'NUMBER';
1011:
1012: FOR rec IN (SELECT REQUIRED_SKILL_ID
1013: FROM CSF_REQUIRED_SKILLS_B
1014: WHERE CREATION_DATE >= G_HA_START_TIME)
1015: LOOP
1016: l_pk_value_list(1):=rec.REQUIRED_SKILL_ID;
1017: TRACK_HA_RECORD('CSF_REQUIRED_SKILLS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

Line 1017: TRACK_HA_RECORD('CSF_REQUIRED_SKILLS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

1013: FROM CSF_REQUIRED_SKILLS_B
1014: WHERE CREATION_DATE >= G_HA_START_TIME)
1015: LOOP
1016: l_pk_value_list(1):=rec.REQUIRED_SKILL_ID;
1017: TRACK_HA_RECORD('CSF_REQUIRED_SKILLS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
1018: END LOOP;
1019:
1020: FOR rec IN (SELECT REQUIRED_SKILL_ID
1021: FROM CSF_REQUIRED_SKILLS_B

Line 1021: FROM CSF_REQUIRED_SKILLS_B

1017: TRACK_HA_RECORD('CSF_REQUIRED_SKILLS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
1018: END LOOP;
1019:
1020: FOR rec IN (SELECT REQUIRED_SKILL_ID
1021: FROM CSF_REQUIRED_SKILLS_B
1022: WHERE CREATION_DATE < G_HA_START_TIME
1023: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
1024: LOOP
1025: l_pk_value_list(1):=rec.REQUIRED_SKILL_ID;

Line 1026: TRACK_HA_RECORD('CSF_REQUIRED_SKILLS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');

1022: WHERE CREATION_DATE < G_HA_START_TIME
1023: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
1024: LOOP
1025: l_pk_value_list(1):=rec.REQUIRED_SKILL_ID;
1026: TRACK_HA_RECORD('CSF_REQUIRED_SKILLS_B',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');
1027: END LOOP;
1028:
1029: CSM_UTIL_PKG.LOG('Recording MFS Data','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
1030: