1 PACKAGE ghr_wf_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghwfpkg.pkh 120.2.12020000.3 2012/07/05 15:05:15 amnaraya ship $ */
3 --
4 --
5 --
6 procedure StartSF52Process( p_pa_request_id in number,
7 p_forward_to_name in varchar2,
8 p_error_msg in varchar2 default null
9 );
10 --
11 procedure CompleteBlockingOfPArequest ( p_pa_request_id in Number,
12 p_error_msg in varchar2 default null);
13 --
14 --
15 procedure CompleteBlockingOfFutureAction ( p_pa_request_id in Number,
16 p_action_taken in varchar2,
17 p_error_msg in varchar2 default null
18 );
19 --
20 --
21 procedure UpdateFinalFYIWFUsers(
22 itemtype in varchar2,
23 itemkey in varchar2,
24 actid in number,
25 funcmode in varchar2,
26 result in out nocopy varchar2);
27 --
28 --
29 --
30 procedure CheckIFSameFYIUsers(
31 itemtype in varchar2,
32 itemkey in varchar2,
33 actid in number,
34 funcmode in varchar2,
35 result in out nocopy varchar2);
36 --
37 --
38 --
39 procedure UpdateRHistoryProcess(
40 itemtype in varchar2,
41 itemkey in varchar2,
42 actid in number,
43 funcmode in varchar2,
44 result in out nocopy varchar2);
45 --
46 --
47 procedure FindDestination(
48 itemtype in varchar2,
49 itemkey in varchar2,
50 actid in number,
51 funcmode in varchar2,
52 result in out nocopy varchar2 );
53 procedure GetDestinationDetails (
54 p_pa_request_id in NUMBER,
55 p_action_taken OUT nocopy varchar2,
56 p_user_name OUT nocopy varchar2,
57 p_groupbox_name OUT nocopy varchar2
58 );
59 --
60 --
61 function CheckItemAttribute
62 ( p_name in wf_item_attribute_values.name%TYPE,
63 p_itemtype in varchar2,
64 p_itemkey in varchar2
65 ) return boolean;
66 --
67 --
68 procedure SetDestinationDetails (
69 p_pa_request_id in NUMBER,
70 p_subject OUT nocopy varchar2,
71 p_line1 OUT nocopy varchar2,
72 p_line2 OUT nocopy varchar2,
73 p_line3 OUT nocopy varchar2,
74 p_line4 OUT nocopy varchar2,
75 p_line5 OUT nocopy varchar2,
76 p_line6 OUT nocopy varchar2,
77 p_line7 OUT nocopy varchar2,
78 p_line8 OUT nocopy varchar2,
79 p_line9 OUT nocopy varchar2
80 );
81 --
82 PROCEDURE CheckIfPARWfEnd ( itemtype in varchar2,
83 itemkey in varchar2,
84 actid in number,
85 funcmode in varchar2,
86 result in out nocopy varchar2);
87 --
88 procedure VerifyIfNtfyUpdHRUsr( itemtype in varchar2,
89 itemkey in varchar2,
90 actid in number,
91 funcmode in varchar2,
92 result in out nocopy varchar2 );
93 --
94 procedure CheckIfNtfyUpdHRUsr( itemtype in varchar2,
95 itemkey in varchar2,
96 actid in number,
97 funcmode in varchar2,
98 result in out nocopy varchar2);
99 --
100 procedure EndSF52Process( itemtype in varchar2,
101 itemkey in varchar2,
102 actid in number,
103 funcmode in varchar2,
104 result in out nocopy varchar2 ) ;
105
106 procedure norout(
107 itemtype in varchar2,
108 itemkey in varchar2,
109 actid in number,
110 funcmode in varchar2,
111 result in out nocopy varchar2);
112 --
113 end ghr_wf_pkg;