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_UPDATE_POSITION

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_EFFECTIVE_START_DATE,
       pval002 P_EFFECTIVE_END_DATE,
       pval003 P_POSITION_DEFINITION_ID,
       pval004 P_VALID_GRADES_CHANGED_WARNING,
       pval005 P_NAME,
       pval006 P_LANGUAGE_CODE,
       pval007 P_POSITION_TRANSACTION_ID,
       pval008 P_AMENDMENT_DATE,
       pval009 P_AMENDMENT_RECOMMENDATION,
       pval010 P_AMENDMENT_REF_NUMBER,
       pval011 P_BARGAINING_UNIT_CD,
       pval012 P_COMMENTS,
       pval013 P_CURRENT_JOB_PROP_END_DATE,
       pval014 P_CURRENT_ORG_PROP_END_DATE,
       pval015 P_AVAIL_STATUS_PROP_END_DATE,
       pval016 P_DATE_EFFECTIVE,
       pval017 P_DATE_END,
       pval018 P_EARLIEST_HIRE_DATE,
       pval019 P_FILL_BY_DATE,
       pval020 P_FREQUENCY,
       pval021 P_FTE,
       pval022 P_MAX_PERSONS,
       pval023 P_OVERLAP_PERIOD,
       pval024 P_OVERLAP_UNIT_CD,
       pval025 P_PAY_TERM_END_DAY_CD,
       pval026 P_PAY_TERM_END_MONTH_CD,
       pval027 P_PERMANENT_TEMPORARY_FLAG,
       pval028 P_PERMIT_RECRUITMENT_FLAG,
       pval029 P_POSITION_TYPE,
       pval030 P_POSTING_DESCRIPTION,
       pval031 P_PROBATION_PERIOD,
       pval032 P_PROBATION_PERIOD_UNIT_CD,
       pval033 P_REPLACEMENT_REQUIRED_FLAG,
       pval034 P_REVIEW_FLAG,
       pval035 P_SEASONAL_FLAG,
       pval036 P_SECURITY_REQUIREMENTS,
       pval037 P_STATUS,
       pval038 P_TERM_START_DAY_CD,
       pval039 P_TERM_START_MONTH_CD,
       pval040 P_TIME_NORMAL_FINISH,
       pval041 P_TIME_NORMAL_START,
       pval042 P_UPDATE_SOURCE_CD,
       pval043 P_WORKING_HOURS,
       pval044 P_WORKS_COUNCIL_APPROVAL_FLAG,
       pval045 P_WORK_PERIOD_TYPE_CD,
       pval046 P_WORK_TERM_END_DAY_CD,
       pval047 P_WORK_TERM_END_MONTH_CD,
       pval048 P_PROPOSED_FTE_FOR_LAYOFF,
       pval049 P_PROPOSED_DATE_FOR_LAYOFF,
       pval050 P_INFORMATION1,
       pval051 P_INFORMATION2,
       pval052 P_INFORMATION3,
       pval053 P_INFORMATION4,
       pval054 P_INFORMATION5,
       pval055 P_INFORMATION6,
       pval056 P_INFORMATION7,
       pval057 P_INFORMATION8,
       pval058 P_INFORMATION9,
       pval059 P_INFORMATION10,
       pval060 P_INFORMATION11,
       pval061 P_INFORMATION12,
       pval062 P_INFORMATION13,
       pval063 P_INFORMATION14,
       pval064 P_INFORMATION15,
       pval065 P_INFORMATION16,
       pval066 P_INFORMATION17,
       pval067 P_INFORMATION18,
       pval068 P_INFORMATION19,
       pval069 P_INFORMATION20,
       pval070 P_INFORMATION21,
       pval071 P_INFORMATION22,
       pval072 P_INFORMATION23,
       pval073 P_INFORMATION24,
       pval074 P_INFORMATION25,
       pval075 P_INFORMATION26,
       pval076 P_INFORMATION27,
       pval077 P_INFORMATION28,
       pval078 P_INFORMATION29,
       pval079 P_INFORMATION30,
       pval080 P_INFORMATION_CATEGORY,
       pval081 P_ATTRIBUTE1,
       pval082 P_ATTRIBUTE2,
       pval083 P_ATTRIBUTE3,
       pval084 P_ATTRIBUTE4,
       pval085 P_ATTRIBUTE5,
       pval086 P_ATTRIBUTE6,
       pval087 P_ATTRIBUTE7,
       pval088 P_ATTRIBUTE8,
       pval089 P_ATTRIBUTE9,
       pval090 P_ATTRIBUTE10,
       pval091 P_ATTRIBUTE11,
       pval092 P_ATTRIBUTE12,
       pval093 P_ATTRIBUTE13,
       pval094 P_ATTRIBUTE14,
       pval095 P_ATTRIBUTE15,
       pval096 P_ATTRIBUTE16,
       pval097 P_ATTRIBUTE17,
       pval098 P_ATTRIBUTE18,
       pval099 P_ATTRIBUTE19,
       pval100 P_ATTRIBUTE20,
       pval101 P_ATTRIBUTE21,
       pval102 P_ATTRIBUTE22,
       pval103 P_ATTRIBUTE23,
       pval104 P_ATTRIBUTE24,
       pval105 P_ATTRIBUTE25,
       pval106 P_ATTRIBUTE26,
       pval107 P_ATTRIBUTE27,
       pval108 P_ATTRIBUTE28,
       pval109 P_ATTRIBUTE29,
       pval110 P_ATTRIBUTE30,
       pval111 P_ATTRIBUTE_CATEGORY,
       pval112 P_SEGMENT1,
       pval113 P_SEGMENT2,
       pval114 P_SEGMENT3,
       pval115 P_SEGMENT4,
       pval116 P_SEGMENT5,
       pval117 P_SEGMENT6,
       pval118 P_SEGMENT7,
       pval119 P_SEGMENT8,
       pval120 P_SEGMENT9,
       pval121 P_SEGMENT10,
       pval122 P_SEGMENT11,
       pval123 P_SEGMENT12,
       pval124 P_SEGMENT13,
       pval125 P_SEGMENT14,
       pval126 P_SEGMENT15,
       pval127 P_SEGMENT16,
       pval128 P_SEGMENT17,
       pval129 P_SEGMENT18,
       pval130 P_SEGMENT19,
       pval131 P_SEGMENT20,
       pval132 P_SEGMENT21,
       pval133 P_SEGMENT22,
       pval134 P_SEGMENT23,
       pval135 P_SEGMENT24,
       pval136 P_SEGMENT25,
       pval137 P_SEGMENT26,
       pval138 P_SEGMENT27,
       pval139 P_SEGMENT28,
       pval140 P_SEGMENT29,
       pval141 P_SEGMENT30,
       pval142 P_CONCAT_SEGMENTS,
       pval143 P_REQUEST_ID,
       pval144 P_PROGRAM_APPLICATION_ID,
       pval145 P_PROGRAM_UPDATE_DATE,
       pval146 P_EFFECTIVE_DATE,
       pval147 P_DATETRACK_MODE,
       pval148 P_POSITION_NAME,
       pval149 P_SHARED_TYPE_NAME,
       pval150 P_SYSTEM_TYPE_CD,
       pval151 P_ENTRY_STEP_USER_KEY,
       pval152 P_ENTRY_GRADE_RULE_USER_KEY,
       pval153 P_LOCATION_CODE,
       pval154 P_PAY_FREQ_PAYROLL_NAME,
       pval155 P_PRIOR_POSITION_NAME,
       pval156 P_RELIEF_POSITION_NAME,
       pval157 P_ENTRY_GRADE_NAME,
       pval158 P_SUCCESSOR_POSITION_NAME,
       pval159 P_SUPERVISOR_POSITION_NAME,
       pval160 P_PAY_BASIS_NAME,
       pval161 P_SUPERVISOR_USER_KEY
from hr_pump_batch_lines
where api_module_id = 1216
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_EFFECTIVE_START_DATE
, PVAL002 P_EFFECTIVE_END_DATE
, PVAL003 P_POSITION_DEFINITION_ID
, PVAL004 P_VALID_GRADES_CHANGED_WARNING
, PVAL005 P_NAME
, PVAL006 P_LANGUAGE_CODE
, PVAL007 P_POSITION_TRANSACTION_ID
, PVAL008 P_AMENDMENT_DATE
, PVAL009 P_AMENDMENT_RECOMMENDATION
, PVAL010 P_AMENDMENT_REF_NUMBER
, PVAL011 P_BARGAINING_UNIT_CD
, PVAL012 P_COMMENTS
, PVAL013 P_CURRENT_JOB_PROP_END_DATE
, PVAL014 P_CURRENT_ORG_PROP_END_DATE
, PVAL015 P_AVAIL_STATUS_PROP_END_DATE
, PVAL016 P_DATE_EFFECTIVE
, PVAL017 P_DATE_END
, PVAL018 P_EARLIEST_HIRE_DATE
, PVAL019 P_FILL_BY_DATE
, PVAL020 P_FREQUENCY
, PVAL021 P_FTE
, PVAL022 P_MAX_PERSONS
, PVAL023 P_OVERLAP_PERIOD
, PVAL024 P_OVERLAP_UNIT_CD
, PVAL025 P_PAY_TERM_END_DAY_CD
, PVAL026 P_PAY_TERM_END_MONTH_CD
, PVAL027 P_PERMANENT_TEMPORARY_FLAG
, PVAL028 P_PERMIT_RECRUITMENT_FLAG
, PVAL029 P_POSITION_TYPE
, PVAL030 P_POSTING_DESCRIPTION
, PVAL031 P_PROBATION_PERIOD
, PVAL032 P_PROBATION_PERIOD_UNIT_CD
, PVAL033 P_REPLACEMENT_REQUIRED_FLAG
, PVAL034 P_REVIEW_FLAG
, PVAL035 P_SEASONAL_FLAG
, PVAL036 P_SECURITY_REQUIREMENTS
, PVAL037 P_STATUS
, PVAL038 P_TERM_START_DAY_CD
, PVAL039 P_TERM_START_MONTH_CD
, PVAL040 P_TIME_NORMAL_FINISH
, PVAL041 P_TIME_NORMAL_START
, PVAL042 P_UPDATE_SOURCE_CD
, PVAL043 P_WORKING_HOURS
, PVAL044 P_WORKS_COUNCIL_APPROVAL_FLAG
, PVAL045 P_WORK_PERIOD_TYPE_CD
, PVAL046 P_WORK_TERM_END_DAY_CD
, PVAL047 P_WORK_TERM_END_MONTH_CD
, PVAL048 P_PROPOSED_FTE_FOR_LAYOFF
, PVAL049 P_PROPOSED_DATE_FOR_LAYOFF
, PVAL050 P_INFORMATION1
, PVAL051 P_INFORMATION2
, PVAL052 P_INFORMATION3
, PVAL053 P_INFORMATION4
, PVAL054 P_INFORMATION5
, PVAL055 P_INFORMATION6
, PVAL056 P_INFORMATION7
, PVAL057 P_INFORMATION8
, PVAL058 P_INFORMATION9
, PVAL059 P_INFORMATION10
, PVAL060 P_INFORMATION11
, PVAL061 P_INFORMATION12
, PVAL062 P_INFORMATION13
, PVAL063 P_INFORMATION14
, PVAL064 P_INFORMATION15
, PVAL065 P_INFORMATION16
, PVAL066 P_INFORMATION17
, PVAL067 P_INFORMATION18
, PVAL068 P_INFORMATION19
, PVAL069 P_INFORMATION20
, PVAL070 P_INFORMATION21
, PVAL071 P_INFORMATION22
, PVAL072 P_INFORMATION23
, PVAL073 P_INFORMATION24
, PVAL074 P_INFORMATION25
, PVAL075 P_INFORMATION26
, PVAL076 P_INFORMATION27
, PVAL077 P_INFORMATION28
, PVAL078 P_INFORMATION29
, PVAL079 P_INFORMATION30
, PVAL080 P_INFORMATION_CATEGORY
, PVAL081 P_ATTRIBUTE1
, PVAL082 P_ATTRIBUTE2
, PVAL083 P_ATTRIBUTE3
, PVAL084 P_ATTRIBUTE4
, PVAL085 P_ATTRIBUTE5
, PVAL086 P_ATTRIBUTE6
, PVAL087 P_ATTRIBUTE7
, PVAL088 P_ATTRIBUTE8
, PVAL089 P_ATTRIBUTE9
, PVAL090 P_ATTRIBUTE10
, PVAL091 P_ATTRIBUTE11
, PVAL092 P_ATTRIBUTE12
, PVAL093 P_ATTRIBUTE13
, PVAL094 P_ATTRIBUTE14
, PVAL095 P_ATTRIBUTE15
, PVAL096 P_ATTRIBUTE16
, PVAL097 P_ATTRIBUTE17
, PVAL098 P_ATTRIBUTE18
, PVAL099 P_ATTRIBUTE19
, PVAL100 P_ATTRIBUTE20
, PVAL101 P_ATTRIBUTE21
, PVAL102 P_ATTRIBUTE22
, PVAL103 P_ATTRIBUTE23
, PVAL104 P_ATTRIBUTE24
, PVAL105 P_ATTRIBUTE25
, PVAL106 P_ATTRIBUTE26
, PVAL107 P_ATTRIBUTE27
, PVAL108 P_ATTRIBUTE28
, PVAL109 P_ATTRIBUTE29
, PVAL110 P_ATTRIBUTE30
, PVAL111 P_ATTRIBUTE_CATEGORY
, PVAL112 P_SEGMENT1
, PVAL113 P_SEGMENT2
, PVAL114 P_SEGMENT3
, PVAL115 P_SEGMENT4
, PVAL116 P_SEGMENT5
, PVAL117 P_SEGMENT6
, PVAL118 P_SEGMENT7
, PVAL119 P_SEGMENT8
, PVAL120 P_SEGMENT9
, PVAL121 P_SEGMENT10
, PVAL122 P_SEGMENT11
, PVAL123 P_SEGMENT12
, PVAL124 P_SEGMENT13
, PVAL125 P_SEGMENT14
, PVAL126 P_SEGMENT15
, PVAL127 P_SEGMENT16
, PVAL128 P_SEGMENT17
, PVAL129 P_SEGMENT18
, PVAL130 P_SEGMENT19
, PVAL131 P_SEGMENT20
, PVAL132 P_SEGMENT21
, PVAL133 P_SEGMENT22
, PVAL134 P_SEGMENT23
, PVAL135 P_SEGMENT24
, PVAL136 P_SEGMENT25
, PVAL137 P_SEGMENT26
, PVAL138 P_SEGMENT27
, PVAL139 P_SEGMENT28
, PVAL140 P_SEGMENT29
, PVAL141 P_SEGMENT30
, PVAL142 P_CONCAT_SEGMENTS
, PVAL143 P_REQUEST_ID
, PVAL144 P_PROGRAM_APPLICATION_ID
, PVAL145 P_PROGRAM_UPDATE_DATE
, PVAL146 P_EFFECTIVE_DATE
, PVAL147 P_DATETRACK_MODE
, PVAL148 P_POSITION_NAME
, PVAL149 P_SHARED_TYPE_NAME
, PVAL150 P_SYSTEM_TYPE_CD
, PVAL151 P_ENTRY_STEP_USER_KEY
, PVAL152 P_ENTRY_GRADE_RULE_USER_KEY
, PVAL153 P_LOCATION_CODE
, PVAL154 P_PAY_FREQ_PAYROLL_NAME
, PVAL155 P_PRIOR_POSITION_NAME
, PVAL156 P_RELIEF_POSITION_NAME
, PVAL157 P_ENTRY_GRADE_NAME
, PVAL158 P_SUCCESSOR_POSITION_NAME
, PVAL159 P_SUPERVISOR_POSITION_NAME
, PVAL160 P_PAY_BASIS_NAME
, PVAL161 P_SUPERVISOR_USER_KEY FROM HR_PUMP_BATCH_LINES WHERE API_MODULE_ID = 1216 WITH CHECK OPTION