DBA Data[Home] [Help]

APPS.PAY_PAYROLL_ACTIONS_PKG dependencies on HR_GENERAL

Line 202: return hr_general.decode_lookup('ACTION_STATUS',p_payroll_action_status);

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: --

Line 210: l_status := hr_general.decode_lookup( 'ACTION_STATUS' , 'I') ;

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 ;

Line 212: l_status := hr_general.decode_lookup( 'ACTION_STATUS' , 'C') ;

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

Line 226: l_status := hr_general.decode_lookup('ACTION_STATUS','P');

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

Line 232: l_status := hr_general.decode_lookup('ACTION_STATUS',p_payroll_action_status ) ;

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 ;

Line 328: select hr_general.decode_lookup('PURGE_PHASE', to_char(ppa.purge_phase))

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

Line 723: to_char(hr_general.start_of_time,'YYYY/MM/DD')));

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

Line 725: to_char(hr_general.end_of_time,'YYYY/MM/DD')));

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: --