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 84: p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 98: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 112: p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 113: ,p_pos_grp2_type in ghr_api.pos_grp2_type

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

Line 127: p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 144: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 160: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 175: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 197: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 213: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 231: ,p_pos_grp1_type in ghr_api.pos_grp1_type

227: --Bug 10030595 commenting this procedure since the pay plans are no longer exists
228: /*procedure psn_supv_status_5
229: (
230: p_pay_plan in VARCHAR2
231: ,p_pos_grp1_type in ghr_api.pos_grp1_type
232: )
233: is
234: begin
235: IF ( p_pay_plan IN ('GW', 'WW', 'YW', 'YV', 'IP', 'DW')

Line 246: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 261: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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

Line 276: ,p_pos_grp1_type in ghr_api.pos_grp1_type

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