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_MASS_AWARDS_PKG dependencies on GHR_PA_REQUESTS

Line 6: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,

2: /* $Header: ghrmarpa.pkh 120.1.12000000.1 2007/01/18 14:14:43 appldev noship $ */
3:
4:
5: type first_lac1_record is record
6: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,

Line 7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,

3:
4:
5: type first_lac1_record is record
6: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,

Line 8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,

4:
5: type first_lac1_record is record
6: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);

Line 9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,

5: type first_lac1_record is record
6: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13:

Line 10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,

6: ( first_action_la_code1 ghr_pa_requests.first_action_la_code1%type,
7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13:
14: type first_lac2_record is record

Line 11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,

7: first_action_la_desc1 ghr_pa_requests.first_action_la_desc1%type,
8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13:
14: type first_lac2_record is record
15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,

Line 12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);

8: first_lac1_information1 ghr_pa_requests.first_lac1_information1%type,
9: first_lac1_information2 ghr_pa_requests.first_lac1_information2%type,
10: first_lac1_information3 ghr_pa_requests.first_lac1_information3%type,
11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13:
14: type first_lac2_record is record
15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,

Line 15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,

11: first_lac1_information4 ghr_pa_requests.first_lac1_information4%type,
12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13:
14: type first_lac2_record is record
15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,

Line 16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,

12: first_lac1_information5 ghr_pa_requests.first_lac1_information5%type);
13:
14: type first_lac2_record is record
15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,

Line 17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,

13:
14: type first_lac2_record is record
15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);

Line 18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,

14: type first_lac2_record is record
15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
22:

Line 19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,

15: ( first_action_la_code2 ghr_pa_requests.first_action_la_code2%type,
16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
22:
23: PROCEDURE get_noa_code_desc

Line 20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,

16: first_action_la_desc2 ghr_pa_requests.first_action_la_desc2%type,
17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
22:
23: PROCEDURE get_noa_code_desc
24: (

Line 21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);

17: first_lac2_information1 ghr_pa_requests.first_lac2_information1%type,
18: first_lac2_information2 ghr_pa_requests.first_lac2_information2%type,
19: first_lac2_information3 ghr_pa_requests.first_lac2_information3%type,
20: first_lac2_information4 ghr_pa_requests.first_lac2_information4%type,
21: first_lac2_information5 ghr_pa_requests.first_lac2_information5%type);
22:
23: PROCEDURE get_noa_code_desc
24: (
25: p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,

Line 45: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,

41: (
42: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
43: p_effective_date in date,
44: p_person_id in per_people_f.person_id%TYPE,
45: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,

Line 46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,

42: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
43: p_effective_date in date,
44: p_person_id in per_people_f.person_id%TYPE,
45: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
50: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE

Line 47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,

43: p_effective_date in date,
44: p_person_id in per_people_f.person_id%TYPE,
45: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
50: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
51: );

Line 48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,

44: p_person_id in per_people_f.person_id%TYPE,
45: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
50: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
51: );
52:

Line 49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,

45: p_pa_request_id out nocopy ghr_pa_requests.pa_request_id%TYPE,
46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
50: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
51: );
52:
53: PROCEDURE get_award_details

Line 50: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE

46: p_pa_notification_id out nocopy ghr_pa_requests.pa_notification_id%TYPE,
47: p_rpa_type out nocopy ghr_pa_requests.rpa_type%TYPE,
48: p_mass_action_sel_flag out nocopy ghr_pa_requests.mass_action_select_flag%TYPE,
49: p_mass_action_comments out nocopy ghr_pa_requests.mass_action_comments%TYPE,
50: p_object_version_number out nocopy ghr_pa_requests.object_version_number%TYPE
51: );
52:
53: PROCEDURE get_award_details
54: (

Line 56: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

52:
53: PROCEDURE get_award_details
54: (
55: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
56: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
57: p_effective_date in date,
58: p_person_id in ghr_pa_requests.person_id%TYPE,
59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,

Line 58: p_person_id in ghr_pa_requests.person_id%TYPE,

54: (
55: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
56: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
57: p_effective_date in date,
58: p_person_id in ghr_pa_requests.person_id%TYPE,
59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,

Line 59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,

55: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
56: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
57: p_effective_date in date,
58: p_person_id in ghr_pa_requests.person_id%TYPE,
59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,

Line 60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,

56: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
57: p_effective_date in date,
58: p_person_id in ghr_pa_requests.person_id%TYPE,
59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,

Line 61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,

57: p_effective_date in date,
58: p_person_id in ghr_pa_requests.person_id%TYPE,
59: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
60: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
61: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
62: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
63: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
64: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
65: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,

Line 74: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

70:
71: PROCEDURE get_award_lac
72: (
73: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
74: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
75: p_effective_date in date,
76: p_first_lac1_record out nocopy first_lac1_record,
77: p_first_lac2_record out nocopy first_lac2_record
78: );

Line 84: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,

80:
81: PROCEDURE get_award_details_shadow
82: (
83: p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,
84: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,

Line 85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,

81: PROCEDURE get_award_details_shadow
82: (
83: p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,
84: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,

Line 86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,

82: (
83: p_pa_request_id in ghr_pa_request_ei_shadow.pa_request_id%type,
84: p_award_amount out nocopy ghr_pa_requests.award_amount%TYPE,
85: p_award_uom out nocopy ghr_pa_requests.award_uom%TYPE,
86: p_award_percentage out nocopy ghr_pa_requests.award_percentage%TYPE,
87: p_award_agency out nocopy ghr_pa_request_extra_info.rei_information3%type,
88: p_award_type out nocopy ghr_pa_request_extra_info.rei_information4%type,
89: p_group_award out nocopy ghr_pa_request_extra_info.rei_information6%type,
90: p_tangible_benefit_dollars out nocopy ghr_pa_request_extra_info.rei_information7%type,

Line 109: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

105:
106: PROCEDURE upd_elig_flag_bef_selection
107: (
108: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
109: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
110: p_effective_date in date
111: );
112:
113: Procedure marpa_process

Line 117: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

113: Procedure marpa_process
114: (
115: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
116: p_action_type in VARCHAR2,
117: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
118: p_effective_date in date,
119: p_person_id in per_people_f.person_id%TYPE,
120: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
121: p_log_text out nocopy varchar2,

Line 120: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,

116: p_action_type in VARCHAR2,
117: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
118: p_effective_date in date,
119: p_person_id in per_people_f.person_id%TYPE,
120: p_pa_request_rec in out nocopy ghr_pa_requests%rowtype ,
121: p_log_text out nocopy varchar2,
122: p_maxcheck out nocopy number
123: );
124:

Line 129: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

125: PROCEDURE build_rpa_for_mass_awards
126: (
127: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
128: p_action_type in varchar2,
129: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
130: p_effective_date in date,
131: p_person_id in per_people_f.person_id%TYPE,
132: p_assignment_id in per_assignments_f.assignment_id%TYPE,
133: p_position_id in hr_positions_f.position_id%TYPE,

Line 146: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

142:
143: PROCEDURE refresh_award_details
144: (
145: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
146: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
147: p_effective_date in date,
148: p_person_id in per_people_f.person_id%TYPE,
149: p_pa_request_id in ghr_pa_requests.pa_request_id%type
150: );

Line 149: p_pa_request_id in ghr_pa_requests.pa_request_id%type

145: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
146: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
147: p_effective_date in date,
148: p_person_id in per_people_f.person_id%TYPE,
149: p_pa_request_id in ghr_pa_requests.pa_request_id%type
150: );
151:
152: PROCEDURE del_elig_flag_aft_selection
153: (

Line 155: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

151:
152: PROCEDURE del_elig_flag_aft_selection
153: (
154: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
155: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
156: p_effective_date in date
157: );
158:
159: Procedure set_ei

Line 165: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);

161: p_template in varchar2,
162: p_person in out nocopy varchar2,
163: p_refresh_flag in varchar2 default 'Y');
164:
165: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);
166:
167: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
168: p_result out nocopy Boolean );
169: Procedure create_remarks

Line 167: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,

163: p_refresh_flag in varchar2 default 'Y');
164:
165: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype);
166:
167: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
168: p_result out nocopy Boolean );
169: Procedure create_remarks
170: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
171: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

Line 171: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,

167: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
168: p_result out nocopy Boolean );
169: Procedure create_remarks
170: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
171: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
172: p_effective_date in date,
173: p_pa_request_id in ghr_pa_requests.pa_request_id%type
174: );
175:

Line 173: p_pa_request_id in ghr_pa_requests.pa_request_id%type

169: Procedure create_remarks
170: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
171: p_rpa_type in ghr_pa_requests.rpa_type%TYPE,
172: p_effective_date in date,
173: p_pa_request_id in ghr_pa_requests.pa_request_id%type
174: );
175:
176: Procedure mass_awards_error_handling
177: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

Line 177: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

173: p_pa_request_id in ghr_pa_requests.pa_request_id%type
174: );
175:
176: Procedure mass_awards_error_handling
177: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
178: p_object_version_number in ghr_pa_requests.object_version_number%type,
179: p_error in varchar2 default null,
180: p_result out nocopy boolean
181: );

Line 178: p_object_version_number in ghr_pa_requests.object_version_number%type,

174: );
175:
176: Procedure mass_awards_error_handling
177: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
178: p_object_version_number in ghr_pa_requests.object_version_number%type,
179: p_error in varchar2 default null,
180: p_result out nocopy boolean
181: );
182:

Line 184: (p_noa_code ghr_pa_requests.first_noa_code%TYPE,

180: p_result out nocopy boolean
181: );
182:
183: PROCEDURE check_award_amount
184: (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
185: p_effective_date ghr_pa_requests.effective_date%TYPE,
186: p_award_amount NUMBER,
187: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
188: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,

Line 185: p_effective_date ghr_pa_requests.effective_date%TYPE,

181: );
182:
183: PROCEDURE check_award_amount
184: (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
185: p_effective_date ghr_pa_requests.effective_date%TYPE,
186: p_award_amount NUMBER,
187: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
188: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
189: p_to_position_id ghr_pa_requests.to_position_id%TYPE,

Line 187: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,

183: PROCEDURE check_award_amount
184: (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
185: p_effective_date ghr_pa_requests.effective_date%TYPE,
186: p_award_amount NUMBER,
187: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
188: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
189: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
190: p_comments OUT NOCOPY varchar2,
191: p_error_flg OUT NOCOPY BOOLEAN

Line 188: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,

184: (p_noa_code ghr_pa_requests.first_noa_code%TYPE,
185: p_effective_date ghr_pa_requests.effective_date%TYPE,
186: p_award_amount NUMBER,
187: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
188: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
189: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
190: p_comments OUT NOCOPY varchar2,
191: p_error_flg OUT NOCOPY BOOLEAN
192: ) ;

Line 189: p_to_position_id ghr_pa_requests.to_position_id%TYPE,

185: p_effective_date ghr_pa_requests.effective_date%TYPE,
186: p_award_amount NUMBER,
187: p_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE,
188: p_from_basic_pay_pa ghr_pa_requests.from_basic_pay%TYPE,
189: p_to_position_id ghr_pa_requests.to_position_id%TYPE,
190: p_comments OUT NOCOPY varchar2,
191: p_error_flg OUT NOCOPY BOOLEAN
192: ) ;
193: