[Home] [Help]
PACKAGE: APPS.PON_CONTERMS_UTL_PVT
Source
1 PACKAGE PON_CONTERMS_UTL_PVT as
2 /* $Header: PONCTDPS.pls 120.1 2005/12/05 16:33:07 rrkulkar noship $ */
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 BID CONSTANT varchar2(30) := 'AUCTION_RESPONSE';
12 QUOTE CONSTANT varchar2(30) := 'RFQ_RESPONSE';
13 RESPONSE CONSTANT varchar2(30) := 'RFI_RESPONSE';
14
15 -- corresponding constants for the Sourcing doc types
16 SRC_AUCTION CONSTANT varchar2(30) := 'BUYER_AUCTION';
17 SRC_REQUEST_FOR_QUOTE CONSTANT varchar2(30) := 'REQUEST_FOR_QUOTE';
18 SRC_REQUEST_FOR_INFORMATION CONSTANT varchar2(30) := 'REQUEST_FOR_INFORMATION';
19
20 FUNCTION is_contracts_installed RETURN VARCHAR2;
21
22 FUNCTION get_response_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2;
23
24 FUNCTION get_negotiation_doc_type(p_doc_type_id IN NUMBER) RETURN VARCHAR2;
25
26 FUNCTION is_deviations_enabled( p_document_type IN VARCHAR2, p_document_id IN NUMBER ) RETURN VARCHAR2;
27
28 FUNCTION get_concatenated_address(
29 p_location_id IN NUMBER
30 ) RETURN VARCHAR2;
31
32 PROCEDURE get_auction_header_id(
33 p_contracts_doctype IN VARCHAR2,
34 p_contracts_doc_id IN NUMBER,
35 x_auction_header_id OUT NOCOPY pon_auction_headers_all.auction_header_id%type,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER
39 );
40
41 PROCEDURE activateDeliverables (
42 p_auction_id IN NUMBER,
43 p_new_bid_number IN NUMBER,
44 p_old_bid_number IN NUMBER,
45 x_result OUT NOCOPY VARCHAR2,
46 x_error_code OUT NOCOPY VARCHAR2,
47 x_error_message OUT NOCOPY VARCHAR2
48 );
49
50
51 PROCEDURE updateDeliverables (
52 p_auction_header_id IN NUMBER,
53 p_doc_type_id IN NUMBER,
54 p_close_bidding_date IN DATE,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_return_status OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE cancelDeliverables(
61 p_auction_header_id IN NUMBER,
62 p_doc_type_id IN NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2
66 ) ;
67 PROCEDURE Delete_Doc (
68 p_auction_header_id IN NUMBER,
69 p_doc_type_id IN NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_return_status OUT NOCOPY VARCHAR2
73 );
74
75 PROCEDURE resolveDeliverables (
76 p_auction_header_id IN NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_return_status OUT NOCOPY VARCHAR2
80 )
81 ;
82
83 PROCEDURE copyResponseDoc (
84 p_source_bid_number IN NUMBER,
85 p_target_bid_number IN NUMBER
86 );
87
88
89 PROCEDURE disqualifyDeliverables (
90 p_bid_number IN NUMBER
91 );
92
93 PROCEDURE disableDeliverables(
94 p_auction_number IN NUMBER,
95 p_doc_type_id IN NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_return_status OUT NOCOPY VARCHAR2
99
100 )
101 ;
102
103 FUNCTION contract_terms_exist(p_doc_type IN VARCHAR2,
104 p_doc_id IN NUMBER) RETURN VARCHAR2;
105
106 PROCEDURE is_article_attached(
107 itemtype in varchar2,
108 itemkey in varchar2,
109 actid in number,
110 uncmode in varchar2,
111 resultout out NOCOPY varchar2
112 );
113
114 PROCEDURE is_article_amended(
115 itemtype in varchar2,
116 itemkey in varchar2,
117 actid in number,
118 uncmode in varchar2,
119 resultout out NOCOPY varchar2
120 );
121
122 PROCEDURE is_template_expired(
123 itemtype in varchar2,
124 itemkey in varchar2,
125 actid in number,
126 uncmode in varchar2,
127 resultout out NOCOPY varchar2
128 );
129
130 PROCEDURE is_standard_contract(
131 itemtype in varchar2,
132 itemkey in varchar2,
133 actid in number,
134 uncmode in varchar2,
135 resultout out NOCOPY varchar2
136 );
137
138 PROCEDURE is_deliverable_attached(
139 itemtype in varchar2,
140 itemkey in varchar2,
141 actid in number,
142 uncmode in varchar2,
143 resultout out NOCOPY varchar2
144 );
145
146 PROCEDURE is_deliverable_amended(
147 itemtype in varchar2,
148 itemkey in varchar2,
149 actid in number,
150 uncmode in varchar2,
151 resultout out NOCOPY varchar2
152 );
153
154 PROCEDURE updateDelivOnVendorMerge
155 ( p_from_vendor_id IN NUMBER,
156 p_from_site_id IN NUMBER,
157 p_to_vendor_id IN NUMBER,
158 p_to_site_id IN NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_return_status OUT NOCOPY VARCHAR2
162 );
163
164
165 PROCEDURE updateDelivOnAmendment (
166 p_auction_header_id_orig IN NUMBER,
167 p_auction_header_id_prev IN NUMBER,
168 p_doc_type_id IN NUMBER,
169 p_close_bidding_date IN DATE,
170 x_result OUT NOCOPY VARCHAR2,
171 x_error_code OUT NOCOPY VARCHAR2,
172 x_error_message OUT NOCOPY VARCHAR2
173 );
174
175 FUNCTION isAttachedDocument(
176 p_document_type IN VARCHAR2,
177 p_document_id IN NUMBER)
178 RETURN VARCHAR2;
179
180 FUNCTION isDocumentMergeable(
181 p_document_type IN VARCHAR2,
182 p_document_id IN NUMBER)
183 RETURN VARCHAR2;
184
185 FUNCTION attachedDocumentExists (
186 p_document_type IN VARCHAR2,
187 p_document_id IN NUMBER)
188 RETURN NUMBER;
189
190 FUNCTION GET_LEGAL_ENTITY_ID (
191 p_org_id IN NUMBER)
192 RETURN NUMBER;
193
194 END PON_CONTERMS_UTL_PVT;