DBA Data[Home] [Help]

PACKAGE: APPS.GHR_WF_PKG

Source


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;