eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.HRDPV_CREATE_COMPETENCE_ELEMEN

Source

View Text - Preformatted


select batch_id            batch_id
,      batch_line_id       batch_line_id
,      api_module_id       api_module_id
,      line_status         line_status
,      user_sequence       user_sequence
,      link_value          link_value
,      business_group_name business_group_name,
       pval001 P_COMPETENCE_ELEMENT_ID,
       pval002 P_OBJECT_VERSION_NUMBER,
       pval003 P_TYPE,
       pval004 P_MANDATORY,
       pval005 P_EFFECTIVE_DATE_FROM,
       pval006 P_EFFECTIVE_DATE_TO,
       pval007 P_GROUP_COMPETENCE_TYPE,
       pval008 P_COMPETENCE_TYPE,
       pval009 P_NORMAL_ELAPSE_DURATION,
       pval010 P_NORMAL_ELAPSE_DURATION_UNIT,
       pval011 P_SEQUENCE_NUMBER,
       pval012 P_SOURCE_OF_PROFICIENCY_LEVEL,
       pval013 P_LINE_SCORE,
       pval014 P_CERTIFICATION_DATE,
       pval015 P_CERTIFICATION_METHOD,
       pval016 P_NEXT_CERTIFICATION_DATE,
       pval017 P_COMMENTS,
       pval018 P_ATTRIBUTE_CATEGORY,
       pval019 P_ATTRIBUTE1,
       pval020 P_ATTRIBUTE2,
       pval021 P_ATTRIBUTE3,
       pval022 P_ATTRIBUTE4,
       pval023 P_ATTRIBUTE5,
       pval024 P_ATTRIBUTE6,
       pval025 P_ATTRIBUTE7,
       pval026 P_ATTRIBUTE8,
       pval027 P_ATTRIBUTE9,
       pval028 P_ATTRIBUTE10,
       pval029 P_ATTRIBUTE11,
       pval030 P_ATTRIBUTE12,
       pval031 P_ATTRIBUTE13,
       pval032 P_ATTRIBUTE14,
       pval033 P_ATTRIBUTE15,
       pval034 P_ATTRIBUTE16,
       pval035 P_ATTRIBUTE17,
       pval036 P_ATTRIBUTE18,
       pval037 P_ATTRIBUTE19,
       pval038 P_ATTRIBUTE20,
       pval039 P_EFFECTIVE_DATE,
       pval040 P_OBJECT_NAME,
       pval041 P_PARTY_ID,
       pval042 P_UNIT_STANDARD_TYPE,
       pval043 P_STATUS,
       pval044 P_INFORMATION_CATEGORY,
       pval045 P_INFORMATION1,
       pval046 P_INFORMATION2,
       pval047 P_INFORMATION3,
       pval048 P_INFORMATION4,
       pval049 P_INFORMATION5,
       pval050 P_INFORMATION6,
       pval051 P_INFORMATION7,
       pval052 P_INFORMATION8,
       pval053 P_INFORMATION9,
       pval054 P_INFORMATION10,
       pval055 P_INFORMATION11,
       pval056 P_INFORMATION12,
       pval057 P_INFORMATION13,
       pval058 P_INFORMATION14,
       pval059 P_INFORMATION15,
       pval060 P_INFORMATION16,
       pval061 P_INFORMATION17,
       pval062 P_INFORMATION18,
       pval063 P_INFORMATION19,
       pval064 P_INFORMATION20,
       pval065 P_ACHIEVED_DATE,
       pval066 P_APPR_LINE_SCORE,
       pval067 P_COMPETENCE_NAME,
       pval068 P_RATING_SCALE_NAME,
       pval069 P_RATING_LEVEL_NAME,
       pval070 P_JOB_NAME,
       pval071 P_ORGANIZATION_NAME,
       pval072 P_LANGUAGE_CODE,
       pval073 P_QUALIFICATION_TYPE_NAME
from hr_pump_batch_lines
where api_module_id = 1172
with check option

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, BATCH_LINE_ID BATCH_LINE_ID
, API_MODULE_ID API_MODULE_ID
, LINE_STATUS LINE_STATUS
, USER_SEQUENCE USER_SEQUENCE
, LINK_VALUE LINK_VALUE
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PVAL001 P_COMPETENCE_ELEMENT_ID
, PVAL002 P_OBJECT_VERSION_NUMBER
, PVAL003 P_TYPE
, PVAL004 P_MANDATORY
, PVAL005 P_EFFECTIVE_DATE_FROM
, PVAL006 P_EFFECTIVE_DATE_TO
, PVAL007 P_GROUP_COMPETENCE_TYPE
, PVAL008 P_COMPETENCE_TYPE
, PVAL009 P_NORMAL_ELAPSE_DURATION
, PVAL010 P_NORMAL_ELAPSE_DURATION_UNIT
, PVAL011 P_SEQUENCE_NUMBER
, PVAL012 P_SOURCE_OF_PROFICIENCY_LEVEL
, PVAL013 P_LINE_SCORE
, PVAL014 P_CERTIFICATION_DATE
, PVAL015 P_CERTIFICATION_METHOD
, PVAL016 P_NEXT_CERTIFICATION_DATE
, PVAL017 P_COMMENTS
, PVAL018 P_ATTRIBUTE_CATEGORY
, PVAL019 P_ATTRIBUTE1
, PVAL020 P_ATTRIBUTE2
, PVAL021 P_ATTRIBUTE3
, PVAL022 P_ATTRIBUTE4
, PVAL023 P_ATTRIBUTE5
, PVAL024 P_ATTRIBUTE6
, PVAL025 P_ATTRIBUTE7
, PVAL026 P_ATTRIBUTE8
, PVAL027 P_ATTRIBUTE9
, PVAL028 P_ATTRIBUTE10
, PVAL029 P_ATTRIBUTE11
, PVAL030 P_ATTRIBUTE12
, PVAL031 P_ATTRIBUTE13
, PVAL032 P_ATTRIBUTE14
, PVAL033 P_ATTRIBUTE15
, PVAL034 P_ATTRIBUTE16
, PVAL035 P_ATTRIBUTE17
, PVAL036 P_ATTRIBUTE18
, PVAL037 P_ATTRIBUTE19
, PVAL038 P_ATTRIBUTE20
, PVAL039 P_EFFECTIVE_DATE
, PVAL040 P_OBJECT_NAME
, PVAL041 P_PARTY_ID
, PVAL042 P_UNIT_STANDARD_TYPE
, PVAL043 P_STATUS
, PVAL044 P_INFORMATION_CATEGORY
, PVAL045 P_INFORMATION1
, PVAL046 P_INFORMATION2
, PVAL047 P_INFORMATION3
, PVAL048 P_INFORMATION4
, PVAL049 P_INFORMATION5
, PVAL050 P_INFORMATION6
, PVAL051 P_INFORMATION7
, PVAL052 P_INFORMATION8
, PVAL053 P_INFORMATION9
, PVAL054 P_INFORMATION10
, PVAL055 P_INFORMATION11
, PVAL056 P_INFORMATION12
, PVAL057 P_INFORMATION13
, PVAL058 P_INFORMATION14
, PVAL059 P_INFORMATION15
, PVAL060 P_INFORMATION16
, PVAL061 P_INFORMATION17
, PVAL062 P_INFORMATION18
, PVAL063 P_INFORMATION19
, PVAL064 P_INFORMATION20
, PVAL065 P_ACHIEVED_DATE
, PVAL066 P_APPR_LINE_SCORE
, PVAL067 P_COMPETENCE_NAME
, PVAL068 P_RATING_SCALE_NAME
, PVAL069 P_RATING_LEVEL_NAME
, PVAL070 P_JOB_NAME
, PVAL071 P_ORGANIZATION_NAME
, PVAL072 P_LANGUAGE_CODE
, PVAL073 P_QUALIFICATION_TYPE_NAME FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1172 WITH CHECK OPTION