APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_MASS_AWARDS

Line 1: PACKAGE GHR_MASS_AWARDS_PKG AUTHID CURRENT_USER AS

1: PACKAGE GHR_MASS_AWARDS_PKG AUTHID CURRENT_USER AS
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

Line 32: p_mass_award_id in ghr_mass_awards.mass_award_id%type)

28: p_noa_desc out nocopy ghr_nature_of_actions.description%type
29: );
30:
31: FUNCTION get_noa_id (
32: p_mass_award_id in ghr_mass_awards.mass_award_id%type)
33: RETURN NUMBER;
34:
35: PROCEDURE get_business_group(p_person_id in number,
36: p_effective_date in date,

Line 42: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

38:
39: --Bug#3804067 Added new parameter p_mass_action_comments
40: PROCEDURE get_pa_request_id_ovn
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,

Line 55: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

51: );
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,

Line 73: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

69: );
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

Line 98: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

94: ---- Fetch Remarks and Legal Authority codes.
95:
96: PROCEDURE main_awards
97: (
98: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,
99: p_action_type in varchar2,
100: p_errbuf out nocopy varchar2, --\___ error log
101: p_status out nocopy varchar2, --||
102: p_retcode out nocopy number, --/ in conc. manager.

Line 108: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

104: );
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:

Line 115: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

111: );
112:
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,

Line 127: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

123: );
124:
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,

Line 145: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

141: );
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

Line 154: p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

150: );
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:

Line 170: (p_mass_award_id in ghr_mass_awards.mass_award_id%TYPE,

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,
172: p_effective_date in date,
173: p_pa_request_id in ghr_pa_requests.pa_request_id%type
174: );

Line 194: END GHR_MASS_AWARDS_PKG;

190: p_comments OUT NOCOPY varchar2,
191: p_error_flg OUT NOCOPY BOOLEAN
192: ) ;
193:
194: END GHR_MASS_AWARDS_PKG;