1 PACKAGE GHR_FETCH_POSITION_HISTORY AUTHID CURRENT_USER AS
2 /* $Header: ghfetdpo.pkh 115.3 1999/11/09 22:37:15 pkm ship $ */
3 PROCEDURE get_position_detail (
4 p_position_id IN per_positions.position_id%type,
5 p_session_date IN DATE,
6 p_date_effective IN OUT per_positions.date_effective%type,
7 p_date_end IN OUT per_positions.date_end%type,
8 p_working_hours IN OUT per_positions.working_hours%type,
9 p_time_normal_start IN OUT per_positions.time_normal_start%type,
10 p_time_normal_finish IN OUT per_positions.time_normal_finish%type,
11 p_probation_period IN OUT per_positions.probation_period%type,
12 p_probation_period_units IN OUT per_positions.probation_period_units%type,
13 p_position_definition_id IN OUT per_positions.position_definition_id%type,
14 p_business_group_id IN OUT per_positions.business_group_id%type,
15 p_job_id IN OUT per_positions.job_id%type,
16 p_organization_id IN OUT per_positions.organization_id%type,
17 p_successor_position_id IN OUT per_positions.successor_position_id%type,
18 p_relief_position_id IN OUT per_positions.relief_position_id%type,
19 p_location_id IN OUT per_positions.location_id%type,
20 p_comments IN OUT per_positions.comments%type,
21 p_status IN OUT per_positions.status%type,
22 p_frequency IN OUT per_positions.frequency%type,
23 p_name IN OUT per_positions.name%type,
24 p_replacement_required_flag IN OUT per_positions.replacement_required_flag%type,
25 p_request_id IN OUT per_positions.request_id%type,
26 p_program_application_id IN OUT per_positions.program_application_id%type,
27 p_program_id IN OUT per_positions.program_id%type,
28 p_program_update_date IN OUT per_positions.program_update_date%type,
29 p_attribute_category IN OUT per_positions.attribute_category%type,
30 p_attribute1 IN OUT per_positions.attribute1%type,
31 p_attribute2 IN OUT per_positions.attribute2%type,
32 p_attribute3 IN OUT per_positions.attribute3%type,
33 p_attribute4 IN OUT per_positions.attribute4%type,
34 p_attribute5 IN OUT per_positions.attribute5%type,
35 p_attribute6 IN OUT per_positions.attribute6%type,
36 p_attribute7 IN OUT per_positions.attribute7%type,
37 p_attribute8 IN OUT per_positions.attribute8%type,
38 p_attribute9 IN OUT per_positions.attribute9%type,
39 p_attribute10 IN OUT per_positions.attribute10%type,
40 p_attribute11 IN OUT per_positions.attribute11%type,
41 p_attribute12 IN OUT per_positions.attribute12%type,
42 p_attribute13 IN OUT per_positions.attribute13%type,
43 p_attribute14 IN OUT per_positions.attribute14%type,
44 p_attribute15 IN OUT per_positions.attribute15%type,
45 p_attribute16 IN OUT per_positions.attribute16%type,
46 p_attribute17 IN OUT per_positions.attribute17%type,
47 p_attribute18 IN OUT per_positions.attribute18%type,
48 p_attribute19 IN OUT per_positions.attribute19%type,
49 p_attribute20 IN OUT per_positions.attribute20%type,
50 p_last_update_date IN OUT per_positions.last_update_date%type,
51 p_last_updated_by IN OUT per_positions.last_updated_by%type,
52 p_last_update_login IN OUT per_positions.last_update_login%type,
53 p_created_by IN OUT per_positions.created_by%type,
54 p_creation_date IN OUT per_positions.creation_date%type,
55 p_org_name IN OUT hr_all_organization_units.name%type,
56 p_job_name IN OUT per_jobs.name%type,
57 p_location_code IN OUT hr_locations.location_code%type,
58 p_status_desc IN OUT hr_lookups.meaning%type,
59 p_frequency_desc IN OUT hr_lookups.meaning%type,
60 p_prob_units_desc IN OUT hr_lookups.meaning%type,
61 p_rep_req_desc IN OUT hr_lookups.meaning%type,
62 p_rel_name IN OUT per_positions.name%type,
63 p_succ_name IN OUT per_positions.name%type,
64 p_result_code IN OUT varchar2
65 );
66 END GHR_FETCH_POSITION_HISTORY;