1 PACKAGE PON_LARGE_AUCTION_UTIL_PKG AUTHID CURRENT_USER AS
2 -- $Header: PONLGUTS.pls 120.6 2006/03/09 13:51:34 liangxia noship $
3
4 BATCH_SIZE CONSTANT NUMBER := 2500;
5
6 g_default_lines_threshold CONSTANT NUMBER := 500;
7
8 -- ======================================================================
9 -- PROCEDURE: DELETE_BID PUBLIC
10 -- PARAMETERS:
11 -- p_auc_header_id IN auction header id of negotiation
12 -- p_bid_number IN bid number to delete
13 --
14 -- COMMENT: Completely deletes a bid from the database
15 -- ======================================================================
16 PROCEDURE delete_bid
17 (
18 p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
19 p_bid_number IN pon_bid_headers.bid_number%TYPE
20 );
21
22 -- ======================================================================
23 -- PROCEDURE : GET_REQUEST_INFO PUBLIC
24 -- PARAMETERS:
25 -- p_request_id IN The request id to check the status of
26 -- x_phase OUT Returned displayable phase
27 -- x_status OUT Returned displayable status
28 -- x_devphase OUT Returned developer phase
29 -- x_dev_status OUT Returned developer status
30 -- x_message OUT Returned message describing extraneous condition
31 --
32 -- COMMENT: Wrapper around call to FND_CONCURRENT.GET_REQUEST_STATUS
33 -- ======================================================================
34 PROCEDURE get_request_info
35 (
36 p_request_id IN fnd_concurrent_requests.request_id%TYPE,
37 x_phase OUT NOCOPY VARCHAR2,
38 x_status OUT NOCOPY VARCHAR2,
39 x_devphase OUT NOCOPY VARCHAR2,
40 x_devstatus OUT NOCOPY VARCHAR2,
41 x_message OUT NOCOPY VARCHAR2
42 );
43
44 -- ======================================================================
45 -- FUNCTION: GET_REQUEST_INTERNAL_STATUS PUBLIC
46 -- PARAMETERS:
47 -- p_request_id IN The request id to check status of
48 --
49 -- RETURN: VARCHAR2 Internal status for concurrent request
50
51 -- COMMENT: Returns and internal status for the concurrent request
52 -- that can be used for comparisons
53 -- ======================================================================
54 FUNCTION get_request_display_status
55 (
56 p_request_id IN fnd_concurrent_requests.request_id%TYPE
57 ) RETURN VARCHAR2;
58
59 -- ======================================================================
60 -- FUNCTION: REQUEST_HAS_ERRORS PUBLIC
61 -- PARAMETERS:
62 -- p_request_id IN The request id to check errors for
63 --
64 -- RETURN: VARCHAR2 Y/N if the request had/didn't have validation errors
65
66 -- COMMENT: Determines if any validation errors associated with p_request_id
67 -- were inserted in pon_interface_errors
68 -- ======================================================================
69 FUNCTION request_has_errors
70 (
71 p_request_id IN pon_interface_errors.request_id%TYPE
72 ) RETURN VARCHAR2;
73
74 -- ======================================================================
75 -- FUNCTION: REQUEST_ERROR_COUNT PUBLIC
76 -- PARAMETERS:
77 -- p_request_id IN The request id to count errors for
78 --
79 -- RETURN: NUMBER the number of errors for the request
80
81 -- COMMENT: Counts the number of validation errors for a request
82 -- ======================================================================
83 FUNCTION request_error_count
84 (
85 p_request_id IN pon_interface_errors.request_id%TYPE
86 ) RETURN NUMBER;
87
88 -- ======================================================================
89 -- FUNCTION: GET_REQUEST_DISPLAY_STATUS PUBLIC
90 -- PARAMETERS:
91 -- p_request_id IN The request id to check status of
92 --
93 -- RETURN: VARCHAR2 Displayable status for concurrent request
94
95 -- COMMENT: Returns a displayable status for the concurrent request
96 -- ======================================================================
97 FUNCTION get_request_internal_status
98 (
99 p_request_id IN fnd_concurrent_requests.request_id%TYPE
100 ) RETURN VARCHAR2;
101
102 -- ======================================================================
103 -- FUNCTION: IS_AUCTION_REQUEST_PENDING PUBLIC
104 -- PARAMETERS:
105 -- p_auc_header_id IN Auction header id for which to check request status
106 --
107 -- RETURN: VARCHAR2 Y/N if the auction has a pending/completed request
108 --
109 -- COMMENT: Determines if a concurrent request associated with the
110 -- the auction is pending or completed
111 -- ======================================================================
112 FUNCTION is_auction_request_pending
113 (
114 p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
115 ) RETURN VARCHAR2;
116
117 -- ======================================================================
118 -- FUNCTION: IS_BID_REQUEST_PENDING PUBLIC
119 -- PARAMETERS:
120 -- p_bid_number IN Bid number for which to check request status
121 --
122 -- RETURN: VARCHAR2 Y/N if the bid has a pending/completed request
123 --
124 -- COMMENT: Determines if a concurrent request associated with the
125 -- the bid is pending or completed
126 -- ======================================================================
127 FUNCTION is_bid_request_pending
128 (
129 p_bid_number IN pon_bid_headers.bid_number%TYPE
130 ) RETURN VARCHAR2;
131
132 -- ======================================================================
133 -- FUNCTION: CANCEL_CONCURRENT_REQUEST PUBLIC
134 -- PARAMETERS:
135 -- p_request_id IN Request id to cancel
136 --
137 -- RETURN: VARCHAR2 null/error msg if successful/unsuccessful
138 --
139 -- COMMENT: Cancels concurrent request p_request_id using FND API:
140 -- FND_CONCURRENT.CANCEL_REQUEST
141 -- ======================================================================
142 FUNCTION cancel_concurrent_request
143 (
144 p_request_id IN fnd_concurrent_requests.request_id%TYPE
145 ) RETURN VARCHAR2;
146
147
148
149 FUNCTION GET_DOCTYPE_SUFFIX(p_auction_id number) RETURN VARCHAR2;
150
151 FUNCTION IS_AUCTION_NOT_UPDATED (p_auction_header_id IN NUMBER,
152 p_last_update_date IN DATE) RETURN BOOLEAN;
153
154
155 PROCEDURE UPDATE_AUCTION_IMPORT_COLS(P_AUCTION_ID IN NUMBER,
156 P_REQUEST_ID IN NUMBER,
157 P_REQUESTED_BY IN NUMBER,
158 P_REQUEST_DATE IN DATE,
159 P_IMPORT_FILE IN VARCHAR2,
160 P_LAST_UPDATE_DATE IN DATE,
161 X_RESULT OUT NOCOPY VARCHAR2,
162 X_ERROR_CODE OUT NOCOPY VARCHAR2,
163 X_ERROR_MESG OUT NOCOPY VARCHAR2);
164
165 PROCEDURE purge_interface_errors_cp
166 (errbuf OUT NOCOPY VARCHAR2,
167 retcode OUT NOCOPY VARCHAR2);
168
169
170 FUNCTION is_super_large_neg(p_auction_header_id IN NUMBER) RETURN BOOLEAN;
171
172 FUNCTION is_large_neg(p_auction_header_id IN NUMBER) RETURN BOOLEAN;
173
174
175 -- ======================================================================
176 -- FUNCTION: IS_AUCTION_COMPLETE PUBLIC
177 -- PARAMETERS:
178 -- p_auc_header_id IN Auction header id for which to check status
179 --
180 -- RETURN: VARCHAR2 Y/N if the auction is incomplete
181 --
182 -- COMMENT: Determines if an auction is complete or not
183 -- It checks the complete flag
184 -- ======================================================================
185 FUNCTION IS_AUCTION_COMPLETE
186 (
187 p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
188 ) RETURN VARCHAR2;
189
190 -- ======================================================================
191 -- FUNCTION: IS_REQUEST_COMPLETE PUBLIC
192 -- PARAMETERS:
193 -- p_auc_header_id IN Auction header id for which to check request
194 -- status
195 --
196 -- RETURN: VARCHAR2 Y/N if the request for the auction is incomplete
197 --
198 -- COMMENT: Determines if the request for the auction
199 -- is completed or not
200 -- ======================================================================
201 FUNCTION IS_REQUEST_COMPLETE
202 (
203 p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE
204 ) RETURN VARCHAR2;
205
206 -- ======================================================================
207 -- PROCEDURE: delete_bid_by_header
208 -- PARAMETERS:
209 -- p_auc_header_id IN auction header id of negotiation
210 -- p_bid_number IN bid number to delete
211 -- P_doc_type IN document type of negotiation
212 --
213 -- COMMENT: Completely deletes a bid from the database including bid_headers
214 -- This procedure is called from online to delete bid complete including
215 -- bid headers.
216 -- ======================================================================
217 PROCEDURE delete_bid_by_header
218 (
219 p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
220 p_bid_number IN pon_bid_headers.bid_number%TYPE,
221 P_doc_type IN varchar2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_data OUT NOCOPY VARCHAR2
225 );
226
227 -- Delete bid header attachment
228 PROCEDURE delete_bid_header_attachment
229 (
230 p_auc_header_id IN pon_bid_headers.auction_header_id%TYPE,
231 p_bid_number IN pon_bid_headers.bid_number%TYPE
232
233 );
234
235 END PON_LARGE_AUCTION_UTIL_PKG;