198: --
199: begin
200: --
201: if (not p_force) and (not g_server_validate) then
202: return hr_general.decode_lookup('ACTION_STATUS',p_payroll_action_status);
203: end if;
204: --
205: if ( p_payroll_action_status = 'C' ) then
206: --
206: --
207: open c1 ;
208: fetch c1 into l_dummy ;
209: if c1%found then
210: l_status := hr_general.decode_lookup( 'ACTION_STATUS' , 'I') ;
211: else
212: l_status := hr_general.decode_lookup( 'ACTION_STATUS' , 'C') ;
213: end if ;
214: close c1 ;
208: fetch c1 into l_dummy ;
209: if c1%found then
210: l_status := hr_general.decode_lookup( 'ACTION_STATUS' , 'I') ;
211: else
212: l_status := hr_general.decode_lookup( 'ACTION_STATUS' , 'C') ;
213: end if ;
214: close c1 ;
215: --
216: elsif ( p_payroll_action_status = 'P' and p_request_id is not null ) then
222: open c2 ;
223: fetch c2 into l_status ;
224: if c2%notfound
225: then
226: l_status := hr_general.decode_lookup('ACTION_STATUS','P');
227: end if;
228: close c2 ;
229: --
230: else
228: close c2 ;
229: --
230: else
231: --
232: l_status := hr_general.decode_lookup('ACTION_STATUS',p_payroll_action_status ) ;
233: --
234: end if ;
235: --
236: return l_status ;
324: from hr_assignment_sets ast
325: where ast.assignment_set_id = p_assignment_set_id;
326: --
327: cursor get_purge_phase is
328: select hr_general.decode_lookup('PURGE_PHASE', to_char(ppa.purge_phase))
329: from pay_payroll_actions ppa
330: where ppa.payroll_action_id = p_payroll_action_id;
331: --
332: cursor get_person_name is
719: begin
720: set_query_bindvar( 'BUSINESS_GROUP_ID',fnd_profile.value('PER_BUSINESS_GROUP_ID'));
721: set_query_bindvar( 'PAYROLL_ID', to_number(p_payroll_id));
722: set_query_bindvar( 'PERIOD_DATE_FROM', nvl(to_char(p_date_from,'YYYY/MM/DD'),
723: to_char(hr_general.start_of_time,'YYYY/MM/DD')));
724: set_query_bindvar( 'PERIOD_DATE_TO', nvl(to_char(p_date_to,'YYYY/MM/DD'),
725: to_char(hr_general.end_of_time,'YYYY/MM/DD')));
726: set_query_bindvar( 'ACTION_TYPE', p_action_type );
727: set_query_bindvar( 'SERVER_VALIDATE', p_server_validate );
721: set_query_bindvar( 'PAYROLL_ID', to_number(p_payroll_id));
722: set_query_bindvar( 'PERIOD_DATE_FROM', nvl(to_char(p_date_from,'YYYY/MM/DD'),
723: to_char(hr_general.start_of_time,'YYYY/MM/DD')));
724: set_query_bindvar( 'PERIOD_DATE_TO', nvl(to_char(p_date_to,'YYYY/MM/DD'),
725: to_char(hr_general.end_of_time,'YYYY/MM/DD')));
726: set_query_bindvar( 'ACTION_TYPE', p_action_type );
727: set_query_bindvar( 'SERVER_VALIDATE', p_server_validate );
728: end set_where;
729: --