DBA Data[Home] [Help]

APPS.GHR_PDI_API dependencies on GHR_POSITION_DESCRIPTIONS

Line 19: * GHR_POSITION_DESCRIPTIONS table.

15: /*#
16: * This API creates the Federal Position Description.
17: *
18: * This API creates the Position Description record in the
19: * GHR_POSITION_DESCRIPTIONS table.
20: *
21: *

Licensing
22: * This API is licensed for use with Human Resources.
23: *

Line 58: * GHR_POSITION_DESCRIPTIONS.COMPETITIVE_LEVEL}

54: * 'GHR_US_SUPERVISORY_STATUS' Lookup Type.
55: * @param p_position_sensitivity Position Sensitivity. Valid Values are defined
56: * by 'GHR_US_POSN_SENSITIVITY' Lookup Type.
57: * @param p_competitive_level {@rep:casecolumn
58: * GHR_POSITION_DESCRIPTIONS.COMPETITIVE_LEVEL}
59: * @param p_pd_remarks Remarks
60: * @param p_position_class_std Position classification standards
61: * @param p_category Category Code. Valid Values are A - Active, I - Inactive,
62: * S - Standard, C - Cancelled

Line 138: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,

134: p_position_description_id OUT NOCOPY number,
135: p_date_from IN date,
136: p_routing_grp_id IN number default null,
137: p_date_to IN date default null,
138: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,

Line 139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,

135: p_date_from IN date,
136: p_routing_grp_id IN number default null,
137: p_date_to IN date default null,
138: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,

Line 140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,

136: p_routing_grp_id IN number default null,
137: p_date_to IN date default null,
138: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,

Line 141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,

137: p_date_to IN date default null,
138: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,

Line 142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,

138: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default null,
139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,

Line 143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,

139: p_flsa IN ghr_position_descriptions.flsa%TYPE default null,
140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,

Line 144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,

140: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default null,
141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148: p_category IN ghr_position_descriptions.category%TYPE default null,

Line 145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,

141: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default null,
142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148: p_category IN ghr_position_descriptions.category%TYPE default null,
149: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,

Line 146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,

142: p_position_status IN ghr_position_descriptions.position_status%TYPE default null,
143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148: p_category IN ghr_position_descriptions.category%TYPE default null,
149: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
150: p_supervisor_name in varchar2 default hr_api.g_varchar2,

Line 147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,

143: p_position_is IN ghr_position_descriptions.position_is%TYPE default null,
144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148: p_category IN ghr_position_descriptions.category%TYPE default null,
149: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
150: p_supervisor_name in varchar2 default hr_api.g_varchar2,
151: p_supervisor_title in varchar2 default hr_api.g_varchar2,

Line 148: p_category IN ghr_position_descriptions.category%TYPE default null,

144: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default null,
145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148: p_category IN ghr_position_descriptions.category%TYPE default null,
149: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
150: p_supervisor_name in varchar2 default hr_api.g_varchar2,
151: p_supervisor_title in varchar2 default hr_api.g_varchar2,
152: p_supervisor_date in date default hr_api.g_date,

Line 149: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,

145: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default null,
146: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default null,
147: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default null,
148: p_category IN ghr_position_descriptions.category%TYPE default null,
149: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default null,
150: p_supervisor_name in varchar2 default hr_api.g_varchar2,
151: p_supervisor_title in varchar2 default hr_api.g_varchar2,
152: p_supervisor_date in date default hr_api.g_date,
153: p_manager_name in varchar2 default hr_api.g_varchar2,

Line 203: * GHR_POSITION_DESCRIPTIONS

199: /*#
200: * This API updates the Position Description.
201: *
202: * This API updates the Position Description record in the
203: * GHR_POSITION_DESCRIPTIONS
204: *
205: *

Licensing
206: * This API is licensed for use with Human Resources.
207: *

Line 241: * GHR_POSITION_DESCRIPTIONS.COMPETITIVE_LEVEL}

237: * 'GHR_US_SUPERVISORY_STATUS' Lookup Type.
238: * @param p_position_sensitivity Position Sensitivity. Valid Values are defined
239: * by 'GHR_US_POSN_SENSITIVITY' Lookup Type.
240: * @param p_competitive_level {@rep:casecolumn
241: * GHR_POSITION_DESCRIPTIONS.COMPETITIVE_LEVEL}
242: * @param p_pd_remarks Remarks
243: * @param p_position_class_std Position classification standards
244: * @param p_category Category Code. Valid Values are A - Active, I - Inactive,
245: * S - Standard, C - Cancelled

Line 328: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,

324: p_position_description_id IN number,
325: p_routing_grp_id IN number default hr_api.g_number,
326: p_date_from IN date,
327: p_date_to IN date default hr_api.g_date,
328: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,

Line 329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,

325: p_routing_grp_id IN number default hr_api.g_number,
326: p_date_from IN date,
327: p_date_to IN date default hr_api.g_date,
328: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,

Line 330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,

326: p_date_from IN date,
327: p_date_to IN date default hr_api.g_date,
328: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,

Line 331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,

327: p_date_to IN date default hr_api.g_date,
328: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,

Line 332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,

328: p_opm_cert_num IN ghr_position_descriptions.opm_cert_num%TYPE default hr_api.g_varchar2,
329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,

Line 333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,

329: p_flsa IN ghr_position_descriptions.flsa%TYPE default hr_api.g_varchar2,
330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,

Line 334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,

330: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE default hr_api.g_varchar2,
331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,

Line 335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,

331: p_subject_to_ia_action IN ghr_position_descriptions.subject_to_ia_action%TYPE default hr_api.g_varchar2,
332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
339: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,

Line 336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,

332: p_position_status IN ghr_position_descriptions.position_status%TYPE default hr_api.g_number,
333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
339: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
340: p_supervisor_name in varchar2 default hr_api.g_varchar2,

Line 337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,

333: p_position_is IN ghr_position_descriptions.position_is%TYPE default hr_api.g_varchar2,
334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
339: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
340: p_supervisor_name in varchar2 default hr_api.g_varchar2,
341: p_supervisor_title in varchar2 default hr_api.g_varchar2,

Line 338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,

334: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE default hr_api.g_varchar2,
335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
339: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
340: p_supervisor_name in varchar2 default hr_api.g_varchar2,
341: p_supervisor_title in varchar2 default hr_api.g_varchar2,
342: p_supervisor_date in date default hr_api.g_date,

Line 339: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,

335: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE default hr_api.g_varchar2,
336: p_pd_remarks IN ghr_position_descriptions.pd_remarks%TYPE default hr_api.g_varchar2,
337: p_position_class_std IN ghr_position_descriptions.position_class_std%TYPE default hr_api.g_varchar2,
338: p_category IN ghr_position_descriptions.category%TYPE default hr_api.g_varchar2,
339: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE default hr_api.g_varchar2,
340: p_supervisor_name in varchar2 default hr_api.g_varchar2,
341: p_supervisor_title in varchar2 default hr_api.g_varchar2,
342: p_supervisor_date in date default hr_api.g_date,
343: p_manager_name in varchar2 default hr_api.g_varchar2,

Line 389: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,

385: p_pdi_object_version_number in out nocopy number);
386:
387: procedure call_workflow
388: (
389: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
390: p_action_taken IN ghr_pd_routing_history.action_taken%TYPE
391: );
392: end ghr_pdi_api;