DBA Data[Home] [Help]

PACKAGE: APPS.HR_OFFER_WF

Source


1 package hr_offer_wf AUTHID CURRENT_USER as
2 /* $Header: hrofwrwf.pkh 115.3 2002/12/12 07:01:06 hjonnala ship $ */
3 --
4 -- ------------------------------------------------------------------------
5 -- |----------------------< Start_Hroffer_Process>-------------------------|
6 -- ------------------------------------------------------------------------
7 	procedure Start_Hroffer_Process (p_hiring_mgr_id           in number
8 					,p_candidate_assignment_id in number
9 					,p_process	 	   in varchar2
10                                         ,p_read_parameters         in varchar2);
11 --
12 --      03/07/97 Add a global value to store information whether the hiring
13 --               manager wants to bypass the next approver or not.
14         g_bypass_next_apprvr   varchar2(1) := 'N';
15 
16 -- ------------------------------------------------------------------------
17 -- |------------------------< Initialize >---------------------------------|
18 -- ------------------------------------------------------------------------
19 	procedure Initialize ( 	itemtype	in varchar2,
20 				itemkey  	in varchar2,
21 				actid		in number,
22 				funmode		in varchar2,
23 				result	 out nocopy varchar2	);
24 --
25 -- ------------------------------------------------------------------------
26 -- |------------------------< Get_next_approver >-------------------------|
27 -- ------------------------------------------------------------------------
28 	procedure Get_Next_Approver ( 	itemtype	in varchar2,
29 					itemkey  	in varchar2,
30 					actid		in number,
31 					funmode		in varchar2,
32 					result	 out nocopy varchar2	);
33 --
34 -- ------------------------------------------------------------------------
35 -- |----------------------< Check_Final_Approver >-------------------------|
36 -- ------------------------------------------------------------------------
37 	procedure Check_Final_Approver (itemtype	in varchar2,
38 					itemkey  	in varchar2,
39 					actid		in number,
40 					funmode		in varchar2,
41 					result	 out nocopy varchar2	);
42 --
43 -- ------------------------------------------------------------------------
44 -- |----------------------< Set_Status_To_Offer >-------------------------|
45 -- ------------------------------------------------------------------------
46 	procedure Set_Status_To_Offer ( itemtype	in varchar2,
47 					itemkey  	in varchar2,
48 					actid		in number,
49 					funmode		in varchar2,
50 					result	 out nocopy varchar2	);
51 --
52 -- ------------------------------------------------------------------------
53 -- |----------------------< Set_Status_To_Sent >---------------------------|
54 -- ------------------------------------------------------------------------
55 	procedure Set_Status_To_Sent ( itemtype	in varchar2,
56 					itemkey  	in varchar2,
57 					actid		in number,
58 					funmode		in varchar2,
59 					result	 out nocopy varchar2	);
60 --
61 -- ------------------------------------------------------------------------
62 -- |----------------------< Reset_Approval_Chain >-------------------------|
63 -- ------------------------------------------------------------------------
64 	procedure Reset_Approval_Chain(	itemtype	in varchar2,
65 					itemkey  	in varchar2,
66 					actid		in number,
67 					funmode		in varchar2,
68 					result	 out nocopy varchar2	);
69 --
70 -- ------------------------------------------------------------------------
71 -- |----------------------< Get_summary_URL >------------------------------|
72 -- ------------------------------------------------------------------------
73 	procedure Get_Summary_URL( 	itemtype	in varchar2,
74 					itemkey  	in varchar2,
75 					actid		in number,
76 					funmode		in varchar2,
77 					result	 out nocopy varchar2	);
78 --
79 -- ------------------------------------------------------------------------
80 -- |------------------------< Get_Offer_URL >------------------------------|
81 -- ------------------------------------------------------------------------
82 	procedure Get_Offer_URL( 	itemtype	in varchar2,
83 					itemkey  	in varchar2,
84 					actid		in number,
85 					funmode		in varchar2,
86 					result	 out nocopy varchar2	);
87 --
88 -- ------------------------------------------------------------------------
89 -- |------------------------< Get_Letter_URL >-----------------------------|
90 -- ------------------------------------------------------------------------
91 	procedure Get_Letter_URL( 	itemtype	in varchar2,
92 					itemkey  	in varchar2,
93 					actid		in number,
94 					funmode		in varchar2,
95 					result	 out nocopy varchar2	);
96 --
97 -- ------------------------------------------------------------------------
98 -- |------------------------< Get_HR_Routing_Details >---------------------|
99 -- ------------------------------------------------------------------------
100 	procedure Get_HR_Routing_Details(	itemtype	in varchar2,
101 						itemkey  	in varchar2,
102 						actid		in number,
103 						funmode		in varchar2,
104 						result	 out nocopy varchar2	);
105 --
106 -- ------------------------------------------------------------------------
107 -- |------------------------< copy_approval_comment >---------------------|
108 -- ------------------------------------------------------------------------
109 	procedure copy_approval_comment(itemtype	in varchar2,
110 					itemkey  	in varchar2,
111 					actid		in number,
112 					funmode		in varchar2,
113 					result	 out nocopy varchar2	);
114 --
115 --
116 -- ------------------------------------------------------------------------
117 -- |------------------------< Get_HR_Candidate_Details >---------------------|
118 -- ------------------------------------------------------------------------
119    procedure Get_HR_Candidate_Details(itemtype        in varchar2,
120                                       itemkey         in varchar2,
121                                       actid           in number,
122                                       funmode         in varchar2,
123                                       result          out nocopy varchar2);
124 
125 --
126 --
127 -- ------------------------------------------------------------------------
128 -- |------------------------< check_if_bypass >---------------------|
129 -- ------------------------------------------------------------------------
130    procedure check_if_bypass(itemtype        in varchar2,
131                              itemkey         in varchar2,
132                              actid           in number,
133                              funmode         in varchar2,
134                              result          out nocopy varchar2);
135 
136 --
137 --
138 -- ------------------------------------------------------------------------
139 -- |----------------------< Set_Bypass_To_No >---------------------------|
140 -- ------------------------------------------------------------------------
141    procedure Set_Bypass_To_No (itemtype        in varchar2,
142                                itemkey         in varchar2,
143                                actid           in number,
144                                funmode         in varchar2,
145                                result          out nocopy varchar2);
146 
147 
148 
149 end hr_offer_wf;