1 PACKAGE PON_COPY_UDAS_GRP AUTHID CURRENT_USER AS
2 /* $Header: PONUDACPY.pls 120.5.12020000.2 2013/02/09 08:22:08 hvutukur ship $ */
3
4
5
6 -- Primary Key for Auction Header
7 g_auc_header_pkey_col VARCHAR2(25) := 'AUCTION_HEADER_ID';
8
9 --Line Number
10 g_auc_line_number VARCHAR2(15) := 'LINE_NUMBER';
11
12 --Bid Number
13 g_bid_number_pkey_col CONSTANT VARCHAR2(15) := 'BID_NUMBER';
14
15 g_req_header_pkey_col CONSTANT VARCHAR2(25) := 'REQUISITION_HEADER_ID';
16 g_req_line_pkey_col CONSTANT VARCHAR2(20) := 'REQUISITION_LINE_ID';
17
18 g_po_draft_pkey_col CONSTANT VARCHAR2(15) := 'DRAFT_ID';
19 g_po_line_pkey_col CONSTANT VARCHAR2(15) := 'PO_LINE_ID';
20 g_po_header_pkey_col CONSTANT VARCHAR2(15) := 'PO_HEADER_ID';
21 g_po_shipment_pkey_col CONSTANT VARCHAR2(16) := 'LINE_LOCATION_ID';
22
23 -- Start of comments
24 -- API name : COPY_HEADER_UDAS
25 --
26 -- Type : Group
27 --
28 -- Pre-reqs : Negotiation with the given auction_header_id and target auction_header_id
29 -- (p_source_auction_header_id) must exists in the database
30 --
31 -- Function : Copy UDA from one Header to other
32 --
33 -- Parameters:
34
35 -- IN : p_source_auction_header_id NUMBER
36 --
37 --
38 -- IN : p_target_auction_header_id NUMBER
39 --
40 --
41 --
42 -- End of comments
43
44
45 PROCEDURE COPY_HEADER_UDAS(
46 p_source_auction_header_id IN NUMBER,
47 p_target_auction_header_id IN NUMBER,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53
54 PROCEDURE get_attribute_groups(p_uda_template_id IN NUMBER,
55 x_attr_group_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
56 );
57 -- API name : COPY_LINE_UDAS
58 --
59 -- Type : Group
60 --
61 -- Pre-reqs : Negotiation with the given auction_header_id and target auction_header_id
62 -- (p_source_auction_header_id) must exists in the database.
63 -- Line_Number should also exists
64 --
65 -- Function : Copy UDA of one Line to other Line
66 --
67 -- Parameters:
68
69 -- IN : p_source_auction_header_id NUMBER
70 --
71 --
72 -- IN : p_target_auction_header_id NUMBER
73 --
74 -- IN : p_line_number NUMBER
75 --
76 --
77 --
78
79 PROCEDURE COPY_LINE_UDAS(
80 p_source_auction_header_id IN NUMBER,
81 p_target_auction_header_id IN NUMBER,
82 p_line_number IN NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2
86 );
87
88
89
90
91
92
93 -- API name : COPY_LINE_UDAS
94 --
95 -- Type : Group
96 --
97 -- Function : Copy UDA of one Line to other Line but target and source line numbers differ
98 --
99 -- Parameters:
100 -- IN : p_source_auction_header_id Source Auction Header Id
101 -- IN : p_target_auction_header_id Target Auction Header Id
102 -- IN : p_source_line_number Source Line Number
103 -- IN : p_target_line_number Target Line Number
104 --
105
106 PROCEDURE COPY_LINE_UDAS(
107 p_source_auction_header_id IN NUMBER,
108 p_target_auction_header_id IN NUMBER,
109 p_source_line_number IN NUMBER,
110 p_target_line_number IN NUMBER,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2
114 );
115
116
117 -- API name : FETCH_BID_LINES_COPY_UDA
118 --
119 -- Type : Group
120 --
121 -- Pre-reqs : Negotiation with p_auction_header_id should exist in database.
122 -- Bid with p_bid_number should exist in the database.
123 --
124 -- Function : Queries all lines to be copied as below :
125 -- 1. If a line is newly created or updated in auction, then uda's should be copied from auction line
126 -- 2. If a line is not modified, then bid line should be copied from existing bid line.
127 -- Copies the UDA's from auction/bid line to new bid line.
128 --
129 -- Parameters:
130
131 -- IN : p_source_auction_header_id NUMBER
132 --
133 --
134 -- IN : p_target_auction_header_id NUMBER
135 --
136 -- IN : p_line_number NUMBER
137 --
138 --
139 PROCEDURE FETCH_BID_LINES_COPY_UDA(p_auction_header_id IN NUMBER,
140 p_bid_number IN NUMBER,
141 p_source_bid_num IN NUMBER,
142 p_bid_template_id IN NUMBER,
143 p_batch_start IN NUMBER,
144 p_batch_end IN NUMBER,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2);
148
149
150
151
152 --============================================================================
153 -- COPY UDA FROM REQ HEADER TO SOLICITATION HEADER
154 -- INVOKED DURING AUTO CREATE OF REQUISITION TO SOLICITATION
155 -- PARAMS
156 -- P_AUCTION_HEADER_ID Auction Header Id
157 -- P_REQ_HEADER_ID Requisition Header Id
158 -- P_SRC_TEMPLATE_ID Source Template Id
159 -- P_DEST_TEMPLATE_ID Destination Template Id
160 -- X_RETURN_STATUS
161 -- X_MSG_COUNT
162 -- X_MSG_DATA
163 --==============================================================================
164
165 PROCEDURE COPY_UDA_DATA(p_src_pkey IN PO_TBL_NUMBER,
166 p_tar_pkey IN PO_TBL_NUMBER,
167 p_src_template_id IN NUMBER,
168 p_tar_template_id IN NUMBER,
169 p_src_doc_level IN VARCHAR2,
170 p_tar_doc_level IN VARCHAR2,
171 p_src_doc_type IN VARCHAR2,
172 p_tar_doc_type IN VARCHAR2,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2);
176
177
178 --============================================================================
179 -- COPY UDA FROM REQ HEADER TO SOLICITATION HEADER
180 -- INVOKED DURING AUTO CREATE OF REQUISITION TO SOLICITATION
181 -- PARAMS
182 -- P_AUCTION_HEADER_ID Auction Header Id
183 -- P_REQ_HEADER_ID Requisition Header Id
184 -- P_SRC_TEMPLATE_ID Source Template Id
185 -- P_DEST_TEMPLATE_ID Destination Template Id
186 -- X_RETURN_STATUS
187 -- X_MSG_COUNT
188 -- X_MSG_DATA
189 --==============================================================================
190
191
192 PROCEDURE COPY_REQ_HEADER_UDA(p_auction_header_id IN NUMBER,
193 p_req_header_id IN NUMBER,
194 p_src_template_id IN NUMBER,
195 p_dest_template_id IN NUMBER,
196 x_return_status OUT NOCOPY VARCHAR2,
197 x_msg_count OUT NOCOPY NUMBER,
198 x_msg_data OUT NOCOPY VARCHAR2);
199
200 PROCEDURE COPY_REQ_LINE_UDA(p_auction_header_id IN NUMBER,
201 p_auction_line_number IN NUMBER,
202 p_req_line_id IN NUMBER,
203 p_src_template_id IN NUMBER,
204 p_dest_template_id IN NUMBER,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2);
208
209 PROCEDURE COPY_PO_LINE_UDA(p_bid_header_id IN NUMBER,
210 p_bid_line_number IN NUMBER,
211 p_po_line_id IN NUMBER,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2);
215
216 --Forward Declaration
217 PROCEDURE PROCESS_ADDRESSES(p_src_pkey IN PO_TBL_NUMBER,
218 p_tar_pkey IN PO_TBL_NUMBER,
219 p_src_template_id IN NUMBER,
220 p_tar_template_id IN NUMBER,
221 p_src_doc_type IN VARCHAR2,
222 p_excl_addr_types IN PO_TBL_VARCHAR50,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2);
226
227 /* Bug 10052785 - Start */
228 /* Following procedure copies the UDA data from Solicitation to Offer. */
229
230 PROCEDURE COPY_BID_LINE_UDA(p_auction_header_id IN NUMBER,
231 p_bid_number IN NUMBER,
232 p_source_bid_number IN NUMBER,
233 p_line_number IN NUMBER,
234 p_auction_template_id IN NUMBER,
235 p_bid_template_id IN NUMBER,
236 p_copyfrom IN VARCHAR2,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2);
240
241 /* Bug 10052785 - End */
242
243 END PON_COPY_UDAS_GRP;