DBA Data[Home] [Help]

APPS.GHR_PSN_POS_GRP1_PK dependencies on GHR_API

Line 7: ,p_pos_grp1_type in ghr_api.pos_grp1_type

3: procedure ghr_psn_pos_grp1_pk_drv
4: (
5: p_grade in VARCHAR2
6: ,p_pay_plan in VARCHAR2
7: ,p_pos_grp1_type in ghr_api.pos_grp1_type
8: ,p_pos_grp2_type in ghr_api.pos_grp2_type
9: )
10: is
11: begin

Line 8: ,p_pos_grp2_type in ghr_api.pos_grp2_type

4: (
5: p_grade in VARCHAR2
6: ,p_pay_plan in VARCHAR2
7: ,p_pos_grp1_type in ghr_api.pos_grp1_type
8: ,p_pos_grp2_type in ghr_api.pos_grp2_type
9: )
10: is
11: begin
12: psn_flsa_cat

Line 83: p_pos_grp1_type in ghr_api.pos_grp1_type

79: --
80: --
81: procedure psn_flsa_cat
82: (
83: p_pos_grp1_type in ghr_api.pos_grp1_type
84: )
85: is
86: begin
87: IF ( p_pos_grp1_type.flsa_category IS NULL)

Line 97: ,p_pos_grp1_type in ghr_api.pos_grp1_type

93: --
94: procedure psn_flsa_cat_3
95: (
96: p_pay_plan in VARCHAR2
97: ,p_pos_grp1_type in ghr_api.pos_grp1_type
98: )
99: is
100: begin
101: IF ( p_pay_plan IN ('AL', 'CA', 'ES', 'EX', 'SL', 'ST')

Line 111: p_pos_grp1_type in ghr_api.pos_grp1_type

107: end psn_flsa_cat_3;
108: --
109: procedure psn_funct_class_id_3
110: (
111: p_pos_grp1_type in ghr_api.pos_grp1_type
112: ,p_pos_grp2_type in ghr_api.pos_grp2_type
113: )
114: is
115: begin

Line 112: ,p_pos_grp2_type in ghr_api.pos_grp2_type

108: --
109: procedure psn_funct_class_id_3
110: (
111: p_pos_grp1_type in ghr_api.pos_grp1_type
112: ,p_pos_grp2_type in ghr_api.pos_grp2_type
113: )
114: is
115: begin
116: IF ( p_pos_grp2_type.training_program_id = '53'

Line 126: p_pos_grp1_type in ghr_api.pos_grp1_type

122: end psn_funct_class_id_3;
123: --
124: procedure psn_pos_scty_acs_1
125: (
126: p_pos_grp1_type in ghr_api.pos_grp1_type
127: )
128: is
129: begin
130: IF ( p_pos_grp1_type.position_sensitivity <> '1'

Line 143: ,p_pos_grp1_type in ghr_api.pos_grp1_type

139: /* Removed as per Aug 2001 10.7 Patch and patched in April 2002 Patch for 11i
140: procedure psn_supv_status_11
141: (
142: p_pay_plan in VARCHAR2
143: ,p_pos_grp1_type in ghr_api.pos_grp1_type
144: )
145: is
146: begin
147: IF ( p_pos_grp1_type.supervisory_status = '5'

Line 159: ,p_pos_grp1_type in ghr_api.pos_grp1_type

155: --
156: procedure psn_supv_status_19
157: (
158: p_pay_plan in VARCHAR2
159: ,p_pos_grp1_type in ghr_api.pos_grp1_type
160: )
161: is
162: begin
163: IF ( p_pay_plan IN ('ES', 'EX', 'FE')

Line 174: ,p_pos_grp1_type in ghr_api.pos_grp1_type

170: --
171: procedure psn_supv_status_2
172: (
173: p_pay_plan in VARCHAR2
174: ,p_pos_grp1_type in ghr_api.pos_grp1_type
175: )
176: is
177: begin
178: IF ( p_pay_plan IN ('WN', 'WS')

Line 196: ,p_pos_grp1_type in ghr_api.pos_grp1_type

192: procedure psn_supv_status_3
193: (
194: p_grade in VARCHAR2
195: ,p_pay_plan in VARCHAR2
196: ,p_pos_grp1_type in ghr_api.pos_grp1_type
197: )
198: is
199: begin
200: IF ( p_pay_plan = 'GS'

Line 212: ,p_pos_grp1_type in ghr_api.pos_grp1_type

208: --
209: procedure psn_supv_status_4
210: (
211: p_pay_plan in VARCHAR2
212: ,p_pos_grp1_type in ghr_api.pos_grp1_type
213: )
214: is
215: begin
216: -- Bug 2681833 -- Added code '7'

Line 229: ,p_pos_grp1_type in ghr_api.pos_grp1_type

225: --
226: procedure psn_supv_status_5
227: (
228: p_pay_plan in VARCHAR2
229: ,p_pos_grp1_type in ghr_api.pos_grp1_type
230: )
231: is
232: begin
233: IF ( p_pay_plan IN ('GW', 'WW', 'YW', 'YV', 'IP', 'DW')

Line 244: ,p_pos_grp1_type in ghr_api.pos_grp1_type

240: --
241: procedure psn_supv_status_6
242: (
243: p_pay_plan in VARCHAR2
244: ,p_pos_grp1_type in ghr_api.pos_grp1_type
245: )
246: is
247: begin
248: IF ( p_pos_grp1_type.supervisory_status NOT IN ('1','2')

Line 259: ,p_pos_grp1_type in ghr_api.pos_grp1_type

255: --
256: procedure psn_supv_status_8
257: (
258: p_pay_plan in VARCHAR2
259: ,p_pos_grp1_type in ghr_api.pos_grp1_type
260: )
261: is
262: begin
263: IF ( p_pay_plan = 'WB'

Line 274: ,p_pos_grp1_type in ghr_api.pos_grp1_type

270: --
271: procedure psn_supv_status_9
272: (
273: p_pay_plan in VARCHAR2
274: ,p_pos_grp1_type in ghr_api.pos_grp1_type
275: )
276: is
277: begin
278: IF ( p_pos_grp1_type.supervisory_status <> '6'