DBA Data[Home] [Help]

PACKAGE BODY: APPS.PER_PQH_WF

Source


1 Package Body per_pqh_wf as
2 /* $Header: perpqhwf.pkb 120.0.12020000.3 2013/04/23 13:42:08 pathota ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |                     Private Global Definitions                           |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package  varchar2(33)	:= '  per_pqh_wf.';  -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-------------------------< my_callbackable_routine >----------------------|
12 -- ----------------------------------------------------------------------------
13 
14 procedure my_callbackable_routine(my_parms in wf_parameter_list_t) is
15 mykey   varchar2(100);
16 
17 begin
18         mykey := wf_event.getValueForParameter('USERKEY', my_parms);
19         per_pqh_shr.my_synch_routine(mykey);
20 
21 end my_callbackable_routine;
22 -- ----------------------------------------------------------------------------
23 -- |-------------------------< callbackable_routine >----------------------|
24 -- ----------------------------------------------------------------------------
25 --
26 procedure callbackable_routine(my_parms in wf_parameter_list_t) is
27 mykey   varchar2(100);
28 l_action varchar2(30) := 'ACTION';
29 l_effective_start_date date := trunc(sysdate);
30 l_effective_end_date date := trunc(sysdate);
31 begin
32         mykey := wf_event.getValueForParameter('USERKEY', my_parms);
33         --hr_psf_shd.my_synch_routine(mykey);
34 	hr_psf_shd.my_synch_routine(mykey,l_action ,l_effective_start_date , l_effective_end_date );
35 end callbackable_routine;
36 --
37 end per_pqh_wf;