[Home] [Help]
PACKAGE: APPS.PO_DRAFTS_PVT
Source
1 PACKAGE PO_DRAFTS_PVT AS
2 /* $Header: PO_DRAFTS_PVT.pls 120.20 2006/09/18 11:19:52 arudas noship $ */
3
4 g_ACCEPT_ALL CONSTANT VARCHAR2(10) := 'ACCEPT_ALL';
5 g_REJECT_ALL CONSTANT VARCHAR2(10) := 'REJECT_ALL';
6 g_LINE_DISP CONSTANT VARCHAR2(10) := 'LINE_DISP';
7
8 g_status_DRAFT CONSTANT PO_DRAFTS.status%TYPE := 'DRAFT';
9 g_status_IN_PROCESS CONSTANT PO_DRAFTS.status%TYPE := 'IN PROCESS';
10 g_status_PDOI_PROCESSING CONSTANT PO_DRAFTS.status%TYPE := 'PDOI PROCESSING';
11 g_status_PDOI_ERROR CONSTANT PO_DRAFTS.status%TYPE := 'PDOI ERROR';
12 g_status_COMPLETED CONSTANT PO_DRAFTS.status%TYPE := 'COMPLETED';
13
14 g_call_mod_HTML_UI CONSTANT VARCHAR2(30) := 'HTML UI';
15 g_call_mod_PDOI CONSTANT VARCHAR2(30) := 'PDOI';
16 g_call_mod_API CONSTANT VARCHAR2(30) := 'API';
17 g_call_mod_FORM CONSTANT VARCHAR2(30) := 'FORM';
18 g_call_mod_UNKNOWN CONSTANT VARCHAR2(30) := 'UNKNOWN';
19 g_call_mod_FORMS_PO_SUMMARY CONSTANT VARCHAR2(30) := 'FORMS PO SUMMARY'; --<Bug#4382472>
20 g_call_mod_HTML_UI_SAVE CONSTANT VARCHAR2(30) := 'HTML UI SAVE';
21
22 g_upload_status_PENDING CONSTANT VARCHAR2(10) := 'PENDING';
23 g_upload_status_RUNNING CONSTANT VARCHAR2(10) := 'RUNNING';
24 g_upload_status_ERROR CONSTANT VARCHAR2(10) := 'ERROR';
25
26 g_chg_accepted_flag_ACCEPT CONSTANT VARCHAR2(1) := 'Y';
27 g_chg_accepted_flag_REJECT CONSTANT VARCHAR2(1) := 'N';
28 g_chg_accepted_flag_NOTIFY CONSTANT VARCHAR2(1) := 'I'; -- bug5149827
29
30 TYPE DRAFT_INFO_REC_TYPE IS RECORD
31 ( draft_id PO_DRAFTS.draft_id%TYPE,
32 po_header_id PO_HEADERS_ALL.po_header_id%TYPE,
33 doc_type PO_DOCUMENT_TYPES.document_type_code%TYPE,
34 doc_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE,
35 ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE,
36 new_document VARCHAR2(1),
37 headers_changed VARCHAR2(1),
38 lines_changed VARCHAR2(1),
39 line_locations_changed VARCHAR2(1),
40 distributions_changed VARCHAR2(1),
41 ga_org_assign_changed VARCHAR2(1),
42 price_diff_changed VARCHAR2(1),
43 notification_ctrl_changed VARCHAR2(1),
44 attr_values_changed VARCHAR2(1),
45 attr_values_tlp_changed VARCHAR2(1)
46 );
47
48
49 FUNCTION draft_id_nextval RETURN NUMBER;
50
51 PROCEDURE populate_draft_info
52 ( p_draft_id IN NUMBER,
53 p_po_header_id IN NUMBER,
54 x_draft_info OUT NOCOPY DRAFT_INFO_REC_TYPE
55 );
56
57 PROCEDURE transfer_draft_to_txn
58 ( p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2,
60 p_draft_id IN NUMBER,
61 p_po_header_id IN NUMBER,
62 p_delete_processed_draft IN VARCHAR2,
63 p_acceptance_action IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2
65 );
66
67 PROCEDURE remove_draft_changes
68 ( p_draft_id IN NUMBER,
69 p_exclude_ctrl_tbl IN VARCHAR2,
70 x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 PROCEDURE apply_changes
74 ( p_draft_info IN DRAFT_INFO_REC_TYPE
75 );
76
77 PROCEDURE find_draft
78 ( p_po_header_id IN NUMBER,
79 x_draft_id OUT NOCOPY NUMBER,
80 x_draft_status OUT NOCOPY VARCHAR2,
81 x_draft_owner_role OUT NOCOPY VARCHAR2
82 );
83
84 PROCEDURE find_draft
85 ( p_po_header_id IN NUMBER,
86 x_draft_id OUT NOCOPY NUMBER
87 );
88
89 PROCEDURE get_request_id
90 ( p_draft_id IN NUMBER,
91 x_request_id OUT NOCOPY NUMBER
92 );
93
94 PROCEDURE get_lock_owner_info
95 ( p_po_header_id IN NUMBER,
96 x_lock_owner_role OUT NOCOPY VARCHAR2,
97 x_lock_owner_user_id OUT NOCOPY NUMBER
98 );
99
100 PROCEDURE set_lock_owner_info
101 ( p_po_header_id IN NUMBER,
102 p_role IN VARCHAR2,
103 p_role_user_id IN NUMBER
104 );
105
106 PROCEDURE update_permission_check
107 ( p_calling_module IN VARCHAR2,
108 p_po_header_id IN NUMBER,
109 p_role IN VARCHAR2,
110 p_skip_cat_upload_chk IN VARCHAR2 := NULL,
111 x_update_allowed OUT NOCOPY VARCHAR2,
112 x_locking_applicable OUT NOCOPY VARCHAR2,
113 x_unlock_required OUT NOCOPY VARCHAR2,
114 x_message OUT NOCOPY VARCHAR2
115 );
116
117 PROCEDURE update_permission_check
118 ( p_calling_module IN VARCHAR2,
119 p_po_header_id IN NUMBER,
120 p_role IN VARCHAR2,
121 p_skip_cat_upload_chk IN VARCHAR2 := NULL,
122 x_update_allowed OUT NOCOPY VARCHAR2,
123 x_locking_applicable OUT NOCOPY VARCHAR2,
124 x_unlock_required OUT NOCOPY VARCHAR2,
125 x_message OUT NOCOPY VARCHAR2,
126 x_token_name_tbl OUT NOCOPY PO_TBL_VARCHAR30,
127 x_token_value_tbl OUT NOCOPY PO_TBL_VARCHAR2000
128 );
129
130 PROCEDURE update_permission_check
131 ( p_calling_module IN VARCHAR2,
132 p_po_header_id IN NUMBER,
133 p_role IN VARCHAR2,
134 p_skip_cat_upload_chk IN VARCHAR2 := NULL,
135 x_update_allowed OUT NOCOPY VARCHAR2,
136 x_locking_applicable OUT NOCOPY VARCHAR2,
137 x_unlock_required OUT NOCOPY VARCHAR2,
138 x_message OUT NOCOPY VARCHAR2,
139 x_message_text OUT NOCOPY VARCHAR2
140 );
141
142 PROCEDURE unlock_document
143 ( p_po_header_id IN NUMBER
144 );
145
146 PROCEDURE lock_document
147 ( p_po_header_id IN NUMBER,
148 p_role IN VARCHAR2,
149 p_role_user_id IN NUMBER,
150 p_unlock_current IN VARCHAR2
151 );
152
153 FUNCTION is_locking_applicable
154 ( p_po_header_id IN NUMBER,
155 p_role IN VARCHAR2
156 ) RETURN VARCHAR2;
157
158 FUNCTION is_draft_applicable
159 ( p_po_header_id IN NUMBER,
160 p_role IN VARCHAR2
161 ) RETURN VARCHAR2;
162
163 PROCEDURE lock_document_with_validate
164 ( p_calling_module IN VARCHAR2,
165 p_po_header_id IN NUMBER,
166 p_role IN VARCHAR2,
167 p_role_user_id IN NUMBER,
168 x_locking_allowed OUT NOCOPY VARCHAR2,
169 x_message OUT NOCOPY VARCHAR2,
170 x_message_text OUT NOCOPY VARCHAR2
171 );
172
173 PROCEDURE update_draft_status
174 ( p_draft_id IN NUMBER,
175 p_new_status IN VARCHAR2
176 );
177
178 FUNCTION pending_changes_exist
179 ( p_po_header_id IN NUMBER
180 ) RETURN VARCHAR2;
181
182 FUNCTION changes_exist_for_draft
183 ( p_draft_id_tbl PO_TBL_NUMBER
184 ) RETURN PO_TBL_VARCHAR1;
185
186 FUNCTION lock_merge_view_records
187 ( p_view_name IN VARCHAR2,
188 p_entity_id IN NUMBER,
189 p_draft_id IN NUMBER
190 ) RETURN VARCHAR2;
191
192 FUNCTION is_pending_buyer_acceptance
193 ( p_po_header_id IN NUMBER
194 ) RETURN VARCHAR2;
195
196 FUNCTION get_supplier_auth_enabled_flag
197 (p_po_header_id IN NUMBER
198 ) RETURN VARCHAR2;
199
200 FUNCTION set_supplier_auth_enabled_flag
201 (p_po_header_id IN NUMBER,
202 p_supplier_auth_enabled_flag IN VARCHAR2
203 ) RETURN VARCHAR2;
204
205 FUNCTION get_cat_admin_auth_enable_flag
206 (p_po_header_id IN NUMBER
207 ) RETURN VARCHAR2;
208
209 FUNCTION set_cat_admin_auth_enable_flag
210 (p_po_header_id IN NUMBER,
211 p_cat_admin_auth_enable_flag IN VARCHAR2
212 ) RETURN VARCHAR2;
213
214 -- bug 5014131 START
215 PROCEDURE get_upload_status_info
216 ( p_po_header_id IN NUMBER,
217 p_role IN VARCHAR2,
218 x_upload_status_code OUT NOCOPY VARCHAR2,
219 x_upload_requestor_role_id OUT NOCOPY NUMBER,
220 x_upload_job_number OUT NOCOPY NUMBER,
221 x_upload_status_display OUT NOCOPY VARCHAR2,
222 x_upload_is_error OUT NOCOPY NUMBER
223 );
224
225 PROCEDURE get_in_process_upload_info
226 ( p_po_header_id IN NUMBER,
227 x_upload_in_progress OUT NOCOPY VARCHAR2,
228 x_upload_status_code OUT NOCOPY VARCHAR2,
229 x_upload_requestor_role OUT NOCOPY VARCHAR2,
230 x_upload_requestor_role_id OUT NOCOPY NUMBER,
231 x_upload_job_number OUT NOCOPY NUMBER,
232 x_upload_status_display OUT NOCOPY VARCHAR2
233 );
234 -- bug 5014131 START
235
236 -- bug5090429 START
237 PROCEDURE unlock_document_and_send_notif
238 ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
239 p_po_header_id IN NUMBER
240 );
241 -- bug5090429 END
242
243 --<Bug#4382472 Start>
244 PROCEDURE unlock_document_and_send_notif
245 ( p_commit IN VARCHAR2 := FND_API.G_FALSE,
246 p_po_header_id IN NUMBER,
247 p_org_id IN NUMBER,
248 p_segment1 IN VARCHAR2,
249 p_revision_num IN NUMBER
250 );
251
252 --<Bug#4382472 End>
253
254
255
256 END PO_DRAFTS_PVT;