[Home] [Help]
PACKAGE: APPS.HR_WIP_TXNS
Source
4 --
1 PACKAGE hr_wip_txns
2 /* $Header: hrwiptxn.pkh 115.2 2003/01/17 21:59:26 pbrimble ship $ */
3 AUTHID CURRENT_USER AS
5 -- ----------------------------------------------------------------------------
6 -- |-----------------------< chk_transaction_creator >-----------------------|
7 -- ----------------------------------------------------------------------------
8 Procedure chk_transaction_creator(p_creator_user_id in fnd_user.user_id%TYPE
9 ,p_current_user_id in fnd_user.user_id%TYPE
10 );
11 --
12 -- ----------------------------------------------------------------------------
13 -- |-----------------------< create_transaction >-----------------------|
14 -- ----------------------------------------------------------------------------
15 Function create_transaction
16 (p_item_type IN wf_items.item_type%TYPE
17 ,p_item_key IN wf_items.item_key%TYPE
18 ,p_function_id IN fnd_form_functions.function_id%TYPE
19 ,p_creator_user_id IN fnd_user.user_id%TYPE
20 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
21 ,p_vo_xml IN VARCHAR2
22 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
23 ) RETURN hr_wip_transactions.transaction_id%TYPE;
24 --
25 --
26 -- ----------------------------------------------------------------------------
27 -- |-----------------------< create_transaction >-----------------------|
28 -- ----------------------------------------------------------------------------
29 Procedure create_transaction
30 (p_item_type IN wf_items.item_type%TYPE
31 ,p_item_key IN wf_items.item_key%TYPE
32 ,p_function_id IN fnd_form_functions.function_id%TYPE
33 ,p_creator_user_id IN fnd_user.user_id%TYPE
34 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
35 ,p_vo_xml IN VARCHAR2
36 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
37 ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
38 );
39 --
40 -- ----------------------------------------------------------------------------
41 -- |-----------------------< create_query_only_transaction >-----------------|
42 -- ----------------------------------------------------------------------------
43 Function create_query_only_transaction
44 (p_item_type IN wf_items.item_type%TYPE
45 ,p_item_key IN wf_items.item_key%TYPE
46 ,p_function_id IN fnd_form_functions.function_id%TYPE
47 ,p_creator_user_id IN fnd_user.user_id%TYPE
48 ,p_vo_xml IN VARCHAR2
49 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
50 ) RETURN hr_wip_transactions.transaction_id%TYPE;
51 --
52 -- ----------------------------------------------------------------------------
53 -- |-----------------------< create_query_only_transaction >-----------------|
54 -- ----------------------------------------------------------------------------
55 Procedure create_query_only_transaction
56 (p_item_type IN wf_items.item_type%TYPE
57 ,p_item_key IN wf_items.item_key%TYPE
58 ,p_function_id IN fnd_form_functions.function_id%TYPE
59 ,p_creator_user_id IN fnd_user.user_id%TYPE
60 ,p_vo_xml IN VARCHAR2
61 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
62 ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
63 );
64 --
65 -- ----------------------------------------------------------------------------
66 -- |-----------------------< save_for_later >-----------------------|
67 -- ----------------------------------------------------------------------------
68 Procedure save_for_later
69 (p_item_type IN wf_items.item_type%TYPE
70 ,p_item_key IN wf_items.item_key%TYPE
71 ,p_current_user_id IN fnd_user.user_id%TYPE
72 ,p_vo_xml IN VARCHAR2
73 ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
74 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
75 default hr_api.g_varchar2
76 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
77 default hr_api.g_varchar2
78 ,p_transaction_id OUT NOCOPY hr_wip_transactions.transaction_id%TYPE
79 );
80 --
81 -- ----------------------------------------------------------------------------
82 -- |-----------------------< save_for_later >-----------------------|
83 -- ----------------------------------------------------------------------------
84 Procedure save_for_later
85 (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
86 ,p_current_user_id IN fnd_user.user_id%TYPE
87 ,p_vo_xml IN VARCHAR2
88 ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
89 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
90 default hr_api.g_varchar2
91 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
92 default hr_api.g_varchar2
93 );
94 --
95 -- ----------------------------------------------------------------------------
96 -- |-----------------------< save_for_later_append >-----------------------|
97 -- ----------------------------------------------------------------------------
98 Procedure save_for_later_append
99 (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
100 ,p_vo_xml IN VARCHAR2
101 );
102 --
103 -- ----------------------------------------------------------------------------
104 -- |-----------------------< pending_approval >-----------------------|
105 -- ----------------------------------------------------------------------------
106 Procedure pending_approval
107 (p_item_type IN wf_items.item_type%TYPE
108 ,p_item_key IN wf_items.item_key%TYPE
109 ,p_current_user_id IN fnd_user.user_id%TYPE
110 ,p_vo_xml IN VARCHAR2
111 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
112 default hr_api.g_varchar2
113 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
114 default hr_api.g_varchar2
115 );
116 -- ----------------------------------------------------------------------------
117 -- |-----------------------< pending_approval >-----------------------|
118 -- ----------------------------------------------------------------------------
119 Procedure pending_approval
120 (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
121 ,p_current_user_id IN fnd_user.user_id%TYPE
122 ,p_vo_xml IN VARCHAR2
123 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
124 default hr_api.g_varchar2
125 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
126 default hr_api.g_varchar2
127 );
128 --
129 -- ----------------------------------------------------------------------------
130 -- |-----------------------< reject_for_correction >-----------------------|
131 -- ----------------------------------------------------------------------------
132 Procedure reject_for_correction
133 (p_item_type IN wf_items.item_type%TYPE
134 ,p_item_key IN wf_items.item_key%TYPE
135 );
136 -- ----------------------------------------------------------------------------
137 -- |-----------------------< reject_for_correction >-----------------------|
138 -- ----------------------------------------------------------------------------
139 Procedure reject_for_correction
140 (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
141 );
142 --
143 -- ----------------------------------------------------------------------------
144 -- |-----------------------< delete_transaction >-----------------------|
145 -- ----------------------------------------------------------------------------
146 Procedure delete_transaction
147 (p_item_type IN wf_items.item_type%TYPE
148 ,p_item_key IN wf_items.item_key%TYPE
149 );
150 --
151 -- ----------------------------------------------------------------------------
152 -- |-----------------------< delete_transaction >-----------------------|
153 -- ----------------------------------------------------------------------------
154 Procedure delete_transaction
155 (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
156 );
157 --
158 --
159 -- ----------------------------------------------------------------------------
160 -- |-----------------------< update_transaction >-----------------------|
161 -- ----------------------------------------------------------------------------
162 Procedure update_transaction
163 (p_item_type IN wf_items.item_type%TYPE
164 ,p_item_key IN wf_items.item_key%TYPE
165 ,p_state IN hr_wip_transactions.state%TYPE
166 ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
167 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
168 default hr_api.g_varchar2
169 ,p_vo_xml IN VARCHAR2
170 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
171 default hr_api.g_varchar2
172 );
173 --
174 -- ----------------------------------------------------------------------------
175 -- |-----------------------< update_transaction >-----------------------|
176 -- ----------------------------------------------------------------------------
177 Procedure update_transaction
178 (p_transaction_id IN hr_wip_transactions.transaction_id%TYPE
179 ,p_state IN hr_wip_transactions.state%TYPE
180 ,p_sub_state IN hr_wip_transactions.sub_state%TYPE
181 ,p_dml_mode IN hr_wip_transactions.dml_mode%TYPE
182 default hr_api.g_varchar2
183 ,p_vo_xml IN VARCHAR2
184 ,p_context_display_text IN hr_wip_transactions.context_display_text%TYPE
185 default hr_api.g_varchar2
186 );
187 --
188 END hr_wip_txns;