[Home] [Help]
PACKAGE: APPS.PON_CONTERMS_UTL_PVT
Source
1 PACKAGE PON_CONTERMS_UTL_PVT AUTHID CURRENT_USER as
2 /* $Header: PONCTDPS.pls 120.4.12020000.2 2013/03/01 09:50:14 hvutukur ship $ */
3
4 -- package name for logging
5 g_pkg_name CONSTANT VARCHAR2(30) := 'PON_CONTERMS_UTL_PVT';
6
7 -- constants for contracts doc types
8 AUCTION CONSTANT varchar2(30) := 'AUCTION';
9 REQUEST_FOR_QUOTE CONSTANT varchar2(30) := 'RFQ';
10 REQUEST_FOR_INFORMATION CONSTANT varchar2(30) := 'RFI';
11 --<SOL PROJECT>
12 SOLICITATION CONSTANT varchar2(30) := 'SOLICITATION';
13 BID CONSTANT varchar2(30) := 'AUCTION_RESPONSE';
14 QUOTE CONSTANT varchar2(30) := 'RFQ_RESPONSE';
15 RESPONSE CONSTANT varchar2(30) := 'RFI_RESPONSE';
16 OFFER CONSTANT varchar2(30) := 'SOLICITATION_RESPONSE';
17
18 -- corresponding constants for the Sourcing doc types
19 SRC_AUCTION CONSTANT varchar2(30) := 'BUYER_AUCTION';
20 SRC_REQUEST_FOR_QUOTE CONSTANT varchar2(30) := 'REQUEST_FOR_QUOTE';
21 SRC_REQUEST_FOR_INFORMATION CONSTANT varchar2(30) := 'REQUEST_FOR_INFORMATION';
22 SRC_SOLICITATION CONSTANT varchar2(30) := 'SOLICITATION';
23
24 FUNCTION is_contracts_installed RETURN VARCHAR2;
25
26 FUNCTION get_response_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2;
27
28 FUNCTION get_negotiation_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2;
29
30 FUNCTION is_deviations_enabled( p_document_type IN VARCHAR2, p_document_id IN NUMBER ) RETURN VARCHAR2;
31
32 FUNCTION get_concatenated_address(
33 p_location_id IN NUMBER
34 ) RETURN VARCHAR2;
35
36 PROCEDURE get_auction_header_id(
37 p_contracts_doctype IN VARCHAR2,
38 p_contracts_doc_id IN NUMBER,
39 x_auction_header_id OUT NOCOPY pon_auction_headers_all.auction_header_id%type,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_data OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER
43 );
44
45 PROCEDURE activateDeliverables (
46 p_auction_id IN NUMBER,
47 p_new_bid_number IN NUMBER,
48 p_old_bid_number IN NUMBER,
49 x_result OUT NOCOPY VARCHAR2,
50 x_error_code OUT NOCOPY VARCHAR2,
51 x_error_message OUT NOCOPY VARCHAR2
52 );
53
54
55 PROCEDURE updateDeliverables (
56 p_auction_header_id IN NUMBER,
57 p_doc_type_id IN NUMBER,
58 p_close_bidding_date IN DATE,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_return_status OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE cancelDeliverables(
65 p_auction_header_id IN NUMBER,
66 p_doc_type_id IN NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_return_status OUT NOCOPY VARCHAR2
70 ) ;
71 PROCEDURE Delete_Doc (
72 p_auction_header_id IN NUMBER,
73 p_doc_type_id IN NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2
77 );
78
79 PROCEDURE resolveDeliverables (
80 p_auction_header_id IN NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_return_status OUT NOCOPY VARCHAR2
84 )
85 ;
86
87 PROCEDURE copyResponseDoc (
88 p_source_bid_number IN NUMBER,
89 p_target_bid_number IN NUMBER
90 );
91
92
93 PROCEDURE disqualifyDeliverables (
94 p_bid_number IN NUMBER
95 );
96
97 PROCEDURE disableDeliverables(
98 p_auction_number IN NUMBER,
99 p_doc_type_id IN NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_return_status OUT NOCOPY VARCHAR2
103
104 )
105 ;
106
107 FUNCTION contract_terms_exist(p_doc_type IN VARCHAR2,
108 p_doc_id IN NUMBER) RETURN VARCHAR2;
109
110 FUNCTION contract_terms_or_del_exist(p_doc_type IN VARCHAR2,
111 p_doc_id IN NUMBER) RETURN VARCHAR2;
112
113 /*======================================================================
114 FUNCTION : contract_deliverables_exist PUBLIC
115 PARAMETERS:
116 p_doc_type IN document type for contract
117 p_doc_id IN document id
118
119 COMMENT : check if negotiation has deliverables or not
120 ======================================================================*/
121 FUNCTION contract_deliverables_exist(p_doc_type IN VARCHAR2,
122 p_doc_id IN NUMBER) RETURN VARCHAR2;
123
124 PROCEDURE is_article_attached(
125 itemtype in varchar2,
126 itemkey in varchar2,
127 actid in number,
128 uncmode in varchar2,
129 resultout out NOCOPY varchar2
130 );
131
132 PROCEDURE is_article_amended(
133 itemtype in varchar2,
134 itemkey in varchar2,
135 actid in number,
136 uncmode in varchar2,
137 resultout out NOCOPY varchar2
138 );
139
140 PROCEDURE is_template_expired(
141 itemtype in varchar2,
142 itemkey in varchar2,
143 actid in number,
144 uncmode in varchar2,
145 resultout out NOCOPY varchar2
146 );
147
148 PROCEDURE is_standard_contract(
149 itemtype in varchar2,
150 itemkey in varchar2,
151 actid in number,
152 uncmode in varchar2,
153 resultout out NOCOPY varchar2
154 );
155
156 PROCEDURE is_deliverable_attached(
157 itemtype in varchar2,
158 itemkey in varchar2,
159 actid in number,
160 uncmode in varchar2,
161 resultout out NOCOPY varchar2
162 );
163
164 PROCEDURE is_deliverable_amended(
165 itemtype in varchar2,
166 itemkey in varchar2,
167 actid in number,
168 uncmode in varchar2,
169 resultout out NOCOPY varchar2
170 );
171
172 PROCEDURE updateDelivOnVendorMerge
173 ( p_from_vendor_id IN NUMBER,
174 p_from_site_id IN NUMBER,
175 p_to_vendor_id IN NUMBER,
176 p_to_site_id IN NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_return_status OUT NOCOPY VARCHAR2
180 );
181
182
183 PROCEDURE updateDelivOnAmendment (
184 p_auction_header_id_orig IN NUMBER,
185 p_auction_header_id_prev IN NUMBER,
186 p_doc_type_id IN NUMBER,
187 p_close_bidding_date IN DATE,
188 x_result OUT NOCOPY VARCHAR2,
189 x_error_code OUT NOCOPY VARCHAR2,
190 x_error_message OUT NOCOPY VARCHAR2
191 );
192
193 FUNCTION isAttachedDocument(
194 p_document_type IN VARCHAR2,
195 p_document_id IN NUMBER)
196 RETURN VARCHAR2;
197
198 FUNCTION isDocumentMergeable(
199 p_document_type IN VARCHAR2,
200 p_document_id IN NUMBER)
201 RETURN VARCHAR2;
202
203 FUNCTION attachedDocumentExists (
204 p_document_type IN VARCHAR2,
205 p_document_id IN NUMBER)
206 RETURN NUMBER;
207
208 FUNCTION GET_LEGAL_ENTITY_ID (
209 p_org_id IN NUMBER)
210 RETURN NUMBER;
211
212 FUNCTION GET_LEGAL_ENTITY_NAME(
213 p_org_id IN NUMBER)
214 RETURN VARCHAR2;
215
216
217 END PON_CONTERMS_UTL_PVT;