1 PACKAGE OKC_CDRL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVCDRLS.pls 120.0.12020000.7 2013/03/26 08:51:54 skavutha noship $ */
3
4
5
6 TYPE exhibit_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
7 TYPE deliverable_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
8
9
10 PROCEDURE copy_cdrl_for_exhibit
11 (
12 p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
14 p_commit IN VARCHAR2:=FND_API.G_FALSE,
15
16
17 p_doc_type IN VARCHAR2,
18 p_doc_id IN NUMBER,
19 p_doc_version IN NUMBER DEFAULT NULL,
20 p_mode IN VARCHAR2 DEFAULT NULL,
21
22
23 p_src_exhibit IN VARCHAR2,
24
25 p_target_exhibit IN VARCHAR2,
26
27
28 x_msg_data OUT NOCOPY VARCHAR2,
29 x_msg_count OUT NOCOPY NUMBER,
30 x_return_status OUT NOCOPY VARCHAR2
31
32 );
33
34 PROCEDURE delete_cdrl_for_exhibits
35 (
36 p_api_version IN NUMBER,
37 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
38 p_commit IN VARCHAR2:=FND_API.G_FALSE,
39
40 p_doc_type IN VARCHAR2,
41 p_doc_id IN NUMBER,
42 p_doc_version IN NUMBER DEFAULT NULL,
43 p_mode IN VARCHAR2 DEFAULT NULL,
44
45 p_exhibit_tbl IN exhibit_tbl_type,
46
47
48 x_msg_data OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_return_status OUT NOCOPY VARCHAR2
51 );
52
53 PROCEDURE create_exhibit_for_cdrl
54 (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
57 p_commit IN VARCHAR2:=FND_API.G_FALSE,
58
59 p_doc_class IN VARCHAR2 DEFAULT NULL,
60 p_doc_type IN VARCHAR2,
61 p_doc_id IN NUMBER,
62 p_doc_version IN NUMBER DEFAULT NULL,
63
64 p_mode IN VARCHAR2 DEFAULT NULL,
65
66 p_exhibit_code IN VARCHAR2,
67 p_exhibit_desc IN VARCHAR2,
68
69
70
71 x_msg_data OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2
74 );
75
76 PROCEDURE
77 delete_exhibit_for_cdrl
78 (
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
81 p_commit IN VARCHAR2:=FND_API.G_FALSE,
82
83 p_doc_class IN VARCHAR2 DEFAULT NULL,
84
85 p_doc_type IN VARCHAR2,
86 p_doc_id IN NUMBER,
87 p_doc_version IN NUMBER DEFAULT NULL,
88
89 p_mode IN VARCHAR2 DEFAULT NULL,
90 p_exhibit_code IN VARCHAR2,
91
92 x_msg_data OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_return_status OUT NOCOPY VARCHAR2,
95 p_validate_before_delete IN VARCHAR2 DEFAULT 'Y',
96 p_deliverable_id IN NUMBER DEFAULT NULL
97 ) ;
98
99
100 PROCEDURE ins_exb_and_get_dataItemNum (
101
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
104 p_commit IN VARCHAR2:=FND_API.G_FALSE,
105
106 p_doc_class IN VARCHAR2,
107
108 p_doc_type IN VARCHAR2,
109 p_doc_id IN NUMBER,
110 p_doc_version IN NUMBER DEFAULT NULL,
111
112 p_mode IN VARCHAR2 DEFAULT NULL,
113
114 p_old_exhibit_code IN VARCHAR2,
115 p_new_exhibit_code IN VARCHAR2,
116
117
118 x_data_item_number OUT NOCOPY VARCHAR2,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_return_status OUT NOCOPY VARCHAR2,
122 p_deliverable_id IN NUMBER DEFAULT NULL
123
124
125 );
126
127
128 FUNCTION ELIN_TO_DECIMAL(linNum VARCHAR2)
129 RETURN NUMBER;
130
131 FUNCTION DECIMAL_TO_ELIN(elin_dec NUMBER) RETURN VARCHAR2;
132
133 FUNCTION GET_NEXT_CDRL_NUM(
134 p_document_type in VARCHAR2
135 , p_Document_ID IN NUMBER
136 , p_exhibit_code IN VARCHAR2) return VARCHAR2;
137
138
139 /*PROCEDURE copy_exhibits (
140
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
143 p_commit IN VARCHAR2:=FND_API.G_FALSE,
144
145 p_doc_class IN VARCHAR2,
146 p_doc_type IN VARCHAR2,
147 p_doc_id IN NUMBER,
148 p_doc_version IN NUMBER,
149 p_mode IN VARCHAR2 DEFAULT NULL,
150
151 p_copy_cdrl IN VARCHAR2 DEFAULT 'Y',
152
153 p_exhibit_tbl IN exhibit_tbl_type,
154
155 x_msg_data OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_return_status OUT NOCOPY VARCHAR2
158
159
160
161 ); */
162
163
164
165 PROCEDURE specify_exhibits_for_cdrls
166 (
167
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
170 p_commit IN VARCHAR2:=FND_API.G_FALSE,
171
172
173 p_cdrl_tbl IN deliverable_tbl_type,
174 p_exhibit_code IN VARCHAR2,
175
176 p_doc_class IN VARCHAR2,
177 p_doc_type IN VARCHAR2,
178 p_doc_id IN NUMBER,
179 p_doc_version IN NUMBER,
180
181 p_mode IN VARCHAR2 DEFAULT NULL,
182
183 x_msg_data OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_return_status OUT NOCOPY VARCHAR2
186
187
188 );
189
190 PROCEDURE delete_doc_exhibits (
191
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
194 p_commit IN VARCHAR2:=FND_API.G_FALSE,
195
196 p_doc_class IN VARCHAR2 DEFAULT NULL,
197
198 p_doc_type IN VARCHAR2,
199 p_doc_id IN NUMBER,
200
201 p_doc_version IN NUMBER DEFAULT NULL,
202
203 p_mode IN VARCHAR2 DEFAULT NULL,
204
205 p_retain_lock_deliverables_yn IN VARCHAR2 DEFAULT 'N',
206
207 x_msg_data OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_return_status OUT NOCOPY VARCHAR2
210 ) ;
211
212 FUNCTION has_Cdrls(
213 p_document_type IN VARCHAR2,
214 p_document_id IN NUMBER,
215 p_doc_version IN NUMBER DEFAULT NULL
216
217 ) RETURN VARCHAR2;
218
219 PROCEDURE RETAIN_CDRLS_FOR_EXHIBITS (
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
222 p_commit IN VARCHAR2:=FND_API.G_FALSE,
223
224 p_doc_type IN VARCHAR2,
225 p_doc_id IN NUMBER,
226 p_doc_version IN NUMBER DEFAULT NULL,
227 p_mode IN VARCHAR2 DEFAULT NULL,
228
229 p_exhibit_tbl IN exhibit_tbl_type,
230
231
232 x_msg_data OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_return_status OUT NOCOPY VARCHAR2
235
236
237 );
238
239 /*
240 function to create new deliverable id and then copy the UDA values from source to destination
241 and return the new deliverable id
242 */
243 FUNCTION get_new_deliverable_id(p_old_deliverable_id NUMBER) RETURN NUMBER;
244 END OKC_CDRL_PVT;