[Home] [Help]
PACKAGE: APPS.POR_AMENDMENT_PKG
Source
1 PACKAGE por_amendment_pkg AUTHID CURRENT_USER AS
2 /* $Header: POR_AMENDMENT_PKG.pls 120.18.12020000.4 2013/04/12 06:54:53 mzhussai ship $ */
3
4 TYPE rec_table_varchar_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
5 TYPE rec_table_num_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
6
7
8 TYPE dist_num_type IS TABLE OF VARCHAR2(100);
9 TYPE dist_id_type IS TABLE OF VARCHAR2(100);
10
11 rec_index NUMBER;
12
13 -- table type to store the data --
14 po_num_tab rec_table_varchar_type;
15 revision_num_tab rec_table_varchar_type;
16 line_num_tab rec_table_varchar_type;
17 distribution_num_tab rec_table_varchar_type;
18 item_id_tab rec_table_num_type;
19 level_altered_tab rec_table_varchar_type;
20 field_altered_tab rec_table_varchar_type;
21 changes_from_tab rec_table_varchar_type;
22 changes_to_tab rec_table_varchar_type;
23 line_num_disp_tab rec_table_varchar_type;
24 -- table type to store the data --
25
26
27 -- UDA related changes
28 g_address_attr_group_id PO_UDA_AG_TEMPLATE_USAGES.attribute_group_id%TYPE;
29 g_address_group_name EGO_ATTRS_V.attr_group_name%TYPE;
30 x_template_id NUMBER;
31 g_org_id number ;
32
33 PROCEDURE compare_table(p_table_name VARCHAR2,
34 p_revision_num NUMBER,
35 p_confirmed_id NUMBER,
36 amend_num IN OUT NOCOPY varchar2);
37
38 PROCEDURE compare(sql_stmt1 VARCHAR2,
39 sql_stmt2 VARCHAR2,
40 p_level VARCHAR2,
41 p_revision_num NUMBER,
42 amend_num IN OUT NOCOPY varchar2);
43
44
45 PROCEDURE change_history(p_confirmed_id NUMBER, p_revision_num NUMBER, p_sequence_num NUMBER);
46
47 PROCEDURE compare_req(p_confirmed_id IN NUMBER,
48 p_revision_num IN NUMBER,
49 p_comparison_flag IN VARCHAR2,
50 p_sequence_num OUT NOCOPY NUMBER);
51
52 PROCEDURE purge(sequenceNumber NUMBER);
53
54 FUNCTION create_xml(p_sql_stmt VARCHAR2) RETURN CLOB;
55
56 PROCEDURE insert_changes(p_line_seq NUMBER,p_confirmed_id NUMBER);
57
58 PROCEDURE verify_no_differences( p_line_seq IN NUMBER,p_revision_num IN NUMBER,amend_num IN VARCHAR2);
59
60 FUNCTION map_id_to_num(p_id VARCHAR2, label VARCHAR2) RETURN varchar2;
61
62 PROCEDURE set_amendment_status(p_table_name VARCHAR2,
63 p_revision_num NUMBER,
64 p_confirmed_id NUMBER);
65
66 PROCEDURE update_amendment(p_confirmed_id NUMBER, p_revision_num NUMBER);
67
68
69 PROCEDURE getAmendmentAttributes(p_req_header_id IN NUMBER, p_req_number IN VARCHAR2,
70 x_revision_num OUT NOCOPY NUMBER, x_segment1 OUT NOCOPY VARCHAR2);
71
72 FUNCTION is_req_amendable(l_req_header_id IN NUMBER) RETURN NUMBER ;
73
74 /* merge_amendment -- start */
75 PROCEDURE merge_amendment(p_confirmed_id IN NUMBER, p_revision_num IN NUMBER);
76 /* merge_amendment -- end */
77
78
79
80 /* create base copy -- start */
81
82 PROCEDURE create_base_copy( p_from_req_header_id IN number,
83 x_to_req_header_id OUT NOCOPY number,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_return_msg OUT NOCOPY varchar2);
86
87 PROCEDURE copy_header(p_from_req_header_id IN number,
88 p_to_revision_num in number,
89 x_to_req_header_id OUT NOCOPY number,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_return_msg OUT NOCOPY varchar2);
92
93 PROCEDURE copy_lines(p_from_req_header_id IN number,
94 p_to_req_header_id IN number,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_return_msg OUT NOCOPY varchar2);
97
98
99 PROCEDURE copy_distributions(p_from_req_line_id IN number,
100 p_to_req_line_id IN number,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_return_msg OUT NOCOPY varchar2);
103
104 /* create base copy -- end */
105
106 procedure CREATE_BASE_VERSION(itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 resultout out NOCOPY varchar2);
111
112 procedure MERGE_INTO_CONFORM_VERSION(itemtype in varchar2,
113 itemkey in varchar2,
114 actid in number,
115 funcmode in varchar2,
116 resultout out NOCOPY varchar2);
117
118 procedure AUTO_ACCEPT_AND_REJECT(itemtype in varchar2,
119 itemkey in varchar2,
120 actid in number,
121 funcmode in varchar2,
122 resultout out NOCOPY varchar2);
123
124 procedure MORE_BUYER_TO_NOTIFY(itemtype in varchar2,
125 itemkey in varchar2,
126 actid in number,
127 funcmode in varchar2,
128 resultout out NOCOPY varchar2);
129
130 procedure MORE_SOURCING_OWNER_TO_NOTIFY(itemtype in varchar2,
131 itemkey in varchar2,
132 actid in number,
133 funcmode in varchar2,
134 resultout out NOCOPY varchar2);
135
136 PROCEDURE SET_AMENDMENT_WF_ATTRIBUTES(itemtype in varchar2,
137 itemkey in varchar2,
138 actid in number,
139 funcmode in varchar2,
140 resultout out NOCOPY varchar2);
141
142 FUNCTION isLinePlacedOnApprPO(reqLineId IN NUMBER) RETURN VARCHAR2;
143
144 PROCEDURE amendment_post_merge_actions(itemtype in varchar2,
145 itemkey in varchar2,
146 actid in number,
147 funcmode in varchar2,
148 resultout out NOCOPY varchar2);
149
150 PROCEDURE create_cancel_amendment(p_from_req_header_id in number,
151 p_cancel_Reason in varchar2,
152 x_amendment_header_id out nocopy number,
153 x_return_status OUT NOCOPY VARCHAR2) ;
154
155 PROCEDURE set_amend_lines_cancel(p_req_header_id in number,
156 p_line_id_list in po_tbl_number);
157
158 PROCEDURE create_distributions(
159 x_requisition_line_id IN number,
160 x_requisition_dist_id IN number,
161 x_line_location_id IN number,
162 x_po_release_id IN NUMBER
163 );
164
165 PROCEDURE implement_dist_auto(x_req_line_id IN NUMBER);
166
167 PROCEDURE implement_slin_auto(x_req_line_id IN NUMBER,dest_doc_id IN varchar2);
168
169
170 PROCEDURE compare_for_implement(p_conformed_req_line_id IN NUMBER,
171 p_sequence_num IN OUT NOCOPY NUMBER);
172
173 PROCEDURE compare_table_for_implement(p_table_name VARCHAR2,
174 p_from_req_line_id NUMBER,
175 p_to_req_line_id NUMBER,
176 p_sequence_num NUMBER,
177 p_amend_num IN varchar2);
178
179 PROCEDURE implement_amendment_changes(selected_lines IN PO_TBL_NUMBER,
180 reason IN VARCHAR2,
181 implement_mode IN VARCHAR2,
182 caller IN VARCHAR2,
183 dest_doc_id IN varchar2);
184
185 FUNCTION is_conformedline_on_po(p_conformed_line_id in number) return varchar2;
186
187 FUNCTION is_conformedline_on_sol(p_conformed_line_id in number) return varchar2;
188
189 FUNCTION is_conformedline_exercised(p_conformed_line_id in number) return varchar2;
190
191
192 FUNCTION is_req_liquidatable(l_req_header_id IN NUMBER) RETURN NUMBER;
193
194 PROCEDURE set_amendment_related_attrib(itemtype in varchar2,
195 itemkey in varchar2,
196 actid in number,
197 funcmode in varchar2,
198 resultout out NOCOPY varchar2);
199
200 PROCEDURE getDraftId(p_req_header_id IN NUMBER, p_draft_id OUT NOCOPY NUMBER);
201
202 FUNCTION getLatestAmendmentNum (p_req_header_id IN NUMBER) RETURN VARCHAR2;
203 FUNCTION getLatestAmendmentHdrId (p_req_header_id IN NUMBER) RETURN NUMBER;
204
205 /* <<CLM Partial Funding Code Changes>> */
206 FUNCTION getLastImplFundValue(p_distribution_id IN NUMBER) RETURN NUMBER;
207
208 PROCEDURE SET_CLM_FUNDS_OVERRIDE(itemtype in varchar2,
209 itemkey in varchar2,
210 actid in number,
211 funcmode in varchar2,
212 resultout out NOCOPY varchar2);
213
214 procedure CLM_REQ_MERGE_RESERVE(itemtype in varchar2,
215 itemkey in varchar2,
216 actid in number,
217 funcmode in varchar2,
218 resultout out NOCOPY varchar2);
219
220 /* <<CLM Partial Funding Code Changes>> */
221
222
223 /* UDA related changes */
224 FUNCTION getUDAAttributeName(p_node_name VARCHAR2) RETURN VARCHAR2;
225
226 FUNCTION getUDAAttributeValue(p_node_value VARCHAR2,
227 p_node_name VARCHAR2,
228 p_lavel VARCHAR2,
229 amend_num VARCHAR2,
230 line_num VARCHAR2)
231 RETURN VARCHAR2;
232
233 /* UDA related changes */
234 FUNCTION anySlinPlacedOnPO(l_clin_line_id IN NUMBER) RETURN NUMBER;
235
236 PROCEDURE amendment_post_approval(itemtype in varchar2,
237 itemkey in varchar2,
238 actid in number,
239 funcmode in varchar2,
240 resultout out NOCOPY varchar2);
241
242 PROCEDURE process_cancel_amendments(p_req_header_id IN NUMBER,
243 p_conf_hdr_id IN NUMBER);
244
245 PROCEDURE is_federal_req(p_req_header_id IN number,
246 x_return_status OUT NOCOPY VARCHAR2);
247
248 END por_amendment_pkg;
249