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.

APPS.GHR_FETCH_POSITION_HISTORY dependencies on PER_POSITIONS

Line 7: p_position_id IN per_positions.position_id%type,

3: g_package_name varchar2(31) := 'GHR_FETCH_POSITION_HISTORY.';
4: -- -------------------------------
5: PROCEDURE get_position_detail (
6: -- -------------------------------
7: p_position_id IN per_positions.position_id%type,
8: p_session_date IN DATE,
9: p_date_effective IN out NOCOPY per_positions.date_effective%type,
10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,

Line 9: p_date_effective IN out NOCOPY per_positions.date_effective%type,

5: PROCEDURE get_position_detail (
6: -- -------------------------------
7: p_position_id IN per_positions.position_id%type,
8: p_session_date IN DATE,
9: p_date_effective IN out NOCOPY per_positions.date_effective%type,
10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,

Line 10: p_date_end IN out NOCOPY per_positions.date_end%type,

6: -- -------------------------------
7: p_position_id IN per_positions.position_id%type,
8: p_session_date IN DATE,
9: p_date_effective IN out NOCOPY per_positions.date_effective%type,
10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,

Line 11: p_working_hours IN out NOCOPY per_positions.working_hours%type,

7: p_position_id IN per_positions.position_id%type,
8: p_session_date IN DATE,
9: p_date_effective IN out NOCOPY per_positions.date_effective%type,
10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,

Line 12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,

8: p_session_date IN DATE,
9: p_date_effective IN out NOCOPY per_positions.date_effective%type,
10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,

Line 13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,

9: p_date_effective IN out NOCOPY per_positions.date_effective%type,
10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,

Line 14: p_probation_period IN out NOCOPY per_positions.probation_period%type,

10: p_date_end IN out NOCOPY per_positions.date_end%type,
11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,

Line 15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,

11: p_working_hours IN out NOCOPY per_positions.working_hours%type,
12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,

Line 16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,

12: p_time_normal_start IN out NOCOPY per_positions.time_normal_start%type,
13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,

Line 17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,

13: p_time_normal_finish IN out NOCOPY per_positions.time_normal_finish%type,
14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,

Line 18: p_job_id IN out NOCOPY per_positions.job_id%type,

14: p_probation_period IN out NOCOPY per_positions.probation_period%type,
15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,

Line 19: p_organization_id IN out NOCOPY per_positions.organization_id%type,

15: p_probation_period_units IN out NOCOPY per_positions.probation_period_units%type,
16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,

Line 20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,

16: p_position_definition_id IN out NOCOPY per_positions.position_definition_id%type,
17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,

Line 21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,

17: p_business_group_id IN out NOCOPY per_positions.business_group_id%type,
18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,

Line 22: p_location_id IN out NOCOPY per_positions.location_id%type,

18: p_job_id IN out NOCOPY per_positions.job_id%type,
19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,

Line 23: p_comments IN out NOCOPY per_positions.comments%type,

19: p_organization_id IN out NOCOPY per_positions.organization_id%type,
20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,

Line 24: p_status IN out NOCOPY per_positions.status%type,

20: p_successor_position_id IN out NOCOPY per_positions.successor_position_id%type,
21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,

Line 25: p_frequency IN out NOCOPY per_positions.frequency%type,

21: p_relief_position_id IN out NOCOPY per_positions.relief_position_id%type,
22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,

Line 26: p_name IN out NOCOPY per_positions.name%type,

22: p_location_id IN out NOCOPY per_positions.location_id%type,
23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,

Line 27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,

23: p_comments IN out NOCOPY per_positions.comments%type,
24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,

Line 28: p_request_id IN out NOCOPY per_positions.request_id%type,

24: p_status IN out NOCOPY per_positions.status%type,
25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,

Line 29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,

25: p_frequency IN out NOCOPY per_positions.frequency%type,
26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,

Line 30: p_program_id IN out NOCOPY per_positions.program_id%type,

26: p_name IN out NOCOPY per_positions.name%type,
27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,

Line 31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,

27: p_replacement_required_flag IN out NOCOPY per_positions.replacement_required_flag%type,
28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,

Line 32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,

28: p_request_id IN out NOCOPY per_positions.request_id%type,
29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,

Line 33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,

29: p_program_application_id IN out NOCOPY per_positions.program_application_id%type,
30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,

Line 34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,

30: p_program_id IN out NOCOPY per_positions.program_id%type,
31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,

Line 35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,

31: p_program_update_date IN out NOCOPY per_positions.program_update_date%type,
32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,

Line 36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,

32: p_attribute_category IN out NOCOPY per_positions.attribute_category%type,
33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,

Line 37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,

33: p_attribute1 IN out NOCOPY per_positions.attribute1%type,
34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,

Line 38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,

34: p_attribute2 IN out NOCOPY per_positions.attribute2%type,
35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,

Line 39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,

35: p_attribute3 IN out NOCOPY per_positions.attribute3%type,
36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,

Line 40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,

36: p_attribute4 IN out NOCOPY per_positions.attribute4%type,
37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,

Line 41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,

37: p_attribute5 IN out NOCOPY per_positions.attribute5%type,
38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,

Line 42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,

38: p_attribute6 IN out NOCOPY per_positions.attribute6%type,
39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,

Line 43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,

39: p_attribute7 IN out NOCOPY per_positions.attribute7%type,
40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,

Line 44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,

40: p_attribute8 IN out NOCOPY per_positions.attribute8%type,
41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,

Line 45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,

41: p_attribute9 IN out NOCOPY per_positions.attribute9%type,
42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,

Line 46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,

42: p_attribute10 IN out NOCOPY per_positions.attribute10%type,
43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,

Line 47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,

43: p_attribute11 IN out NOCOPY per_positions.attribute11%type,
44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,

Line 48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,

44: p_attribute12 IN out NOCOPY per_positions.attribute12%type,
45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,

Line 49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,

45: p_attribute13 IN out NOCOPY per_positions.attribute13%type,
46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,

Line 50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,

46: p_attribute14 IN out NOCOPY per_positions.attribute14%type,
47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,

Line 51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,

47: p_attribute15 IN out NOCOPY per_positions.attribute15%type,
48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,

Line 52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,

48: p_attribute16 IN out NOCOPY per_positions.attribute16%type,
49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,
56: p_created_by IN out NOCOPY per_positions.created_by%type,

Line 53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,

49: p_attribute17 IN out NOCOPY per_positions.attribute17%type,
50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,
56: p_created_by IN out NOCOPY per_positions.created_by%type,
57: p_creation_date IN out NOCOPY per_positions.creation_date%type,

Line 54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,

50: p_attribute18 IN out NOCOPY per_positions.attribute18%type,
51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,
56: p_created_by IN out NOCOPY per_positions.created_by%type,
57: p_creation_date IN out NOCOPY per_positions.creation_date%type,
58: p_org_name IN out NOCOPY hr_all_organization_units.name%type,

Line 55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,

51: p_attribute19 IN out NOCOPY per_positions.attribute19%type,
52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,
56: p_created_by IN out NOCOPY per_positions.created_by%type,
57: p_creation_date IN out NOCOPY per_positions.creation_date%type,
58: p_org_name IN out NOCOPY hr_all_organization_units.name%type,
59: p_job_name IN out NOCOPY per_jobs.name%type,

Line 56: p_created_by IN out NOCOPY per_positions.created_by%type,

52: p_attribute20 IN out NOCOPY per_positions.attribute20%type,
53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,
56: p_created_by IN out NOCOPY per_positions.created_by%type,
57: p_creation_date IN out NOCOPY per_positions.creation_date%type,
58: p_org_name IN out NOCOPY hr_all_organization_units.name%type,
59: p_job_name IN out NOCOPY per_jobs.name%type,
60: p_location_code IN out NOCOPY hr_locations.location_code%type,

Line 57: p_creation_date IN out NOCOPY per_positions.creation_date%type,

53: p_last_update_date IN out NOCOPY per_positions.last_update_date%type,
54: p_last_updated_by IN out NOCOPY per_positions.last_updated_by%type,
55: p_last_update_login IN out NOCOPY per_positions.last_update_login%type,
56: p_created_by IN out NOCOPY per_positions.created_by%type,
57: p_creation_date IN out NOCOPY per_positions.creation_date%type,
58: p_org_name IN out NOCOPY hr_all_organization_units.name%type,
59: p_job_name IN out NOCOPY per_jobs.name%type,
60: p_location_code IN out NOCOPY hr_locations.location_code%type,
61: p_status_desc IN out NOCOPY hr_lookups.meaning%type,

Line 65: p_rel_name IN out NOCOPY per_positions.name%type,

61: p_status_desc IN out NOCOPY hr_lookups.meaning%type,
62: p_frequency_desc IN out NOCOPY hr_lookups.meaning%type,
63: p_prob_units_desc IN out NOCOPY hr_lookups.meaning%type,
64: p_rep_req_desc IN out NOCOPY hr_lookups.meaning%type,
65: p_rel_name IN out NOCOPY per_positions.name%type,
66: p_succ_name IN out NOCOPY per_positions.name%type,
67: p_result_code IN out NOCOPY varchar2
68: )
69: IS

Line 66: p_succ_name IN out NOCOPY per_positions.name%type,

62: p_frequency_desc IN out NOCOPY hr_lookups.meaning%type,
63: p_prob_units_desc IN out NOCOPY hr_lookups.meaning%type,
64: p_rep_req_desc IN out NOCOPY hr_lookups.meaning%type,
65: p_rel_name IN out NOCOPY per_positions.name%type,
66: p_succ_name IN out NOCOPY per_positions.name%type,
67: p_result_code IN out NOCOPY varchar2
68: )
69: IS
70: l_proc VARCHAR2(61) := g_package_name || 'CLOSE_CURSOR';

Line 71: l_position_rec per_positions%rowtype;

67: p_result_code IN out NOCOPY varchar2
68: )
69: IS
70: l_proc VARCHAR2(61) := g_package_name || 'CLOSE_CURSOR';
71: l_position_rec per_positions%rowtype;
72: l_position_rec_temp per_positions%rowtype;
73: l_result_code varchar2(30);
74:
75: CURSOR c_org_name (p_org_id IN NUMBER) IS

Line 72: l_position_rec_temp per_positions%rowtype;

68: )
69: IS
70: l_proc VARCHAR2(61) := g_package_name || 'CLOSE_CURSOR';
71: l_position_rec per_positions%rowtype;
72: l_position_rec_temp per_positions%rowtype;
73: l_result_code varchar2(30);
74:
75: CURSOR c_org_name (p_org_id IN NUMBER) IS
76: SELECT org.name