[Home] [Help]
PACKAGE: APPS.OKL_LLN_PVT
Source
1 PACKAGE Okl_Lln_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSLLNS.pls 115.5 2002/04/16 15:26:27 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE lln_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 sequence_number NUMBER := Okc_Api.G_MISS_NUM,
9 lln_id_parent NUMBER := Okc_Api.G_MISS_NUM,
10 kle_id NUMBER := Okc_Api.G_MISS_NUM,
11 khr_id NUMBER := Okc_Api.G_MISS_NUM,
12 cnr_id NUMBER := Okc_Api.G_MISS_NUM,
13 ilt_id NUMBER := Okc_Api.G_MISS_NUM,
14 line_type OKL_CNSLD_AR_LINES_B.LINE_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
15 amount NUMBER := Okc_Api.G_MISS_NUM,
16 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
17 request_id NUMBER := Okc_Api.G_MISS_NUM,
18 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
19 program_id NUMBER := Okc_Api.G_MISS_NUM,
20 program_update_date OKL_CNSLD_AR_LINES_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
21 org_id NUMBER := Okc_Api.G_MISS_NUM,
22 tax_amount NUMBER := Okc_Api.G_MISS_NUM,
23 attribute_category OKL_CNSLD_AR_LINES_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
24 attribute1 OKL_CNSLD_AR_LINES_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
25 attribute2 OKL_CNSLD_AR_LINES_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
26 attribute3 OKL_CNSLD_AR_LINES_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute4 OKL_CNSLD_AR_LINES_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute5 OKL_CNSLD_AR_LINES_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute6 OKL_CNSLD_AR_LINES_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute7 OKL_CNSLD_AR_LINES_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute8 OKL_CNSLD_AR_LINES_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute9 OKL_CNSLD_AR_LINES_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
33 attribute10 OKL_CNSLD_AR_LINES_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
34 attribute11 OKL_CNSLD_AR_LINES_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
35 attribute12 OKL_CNSLD_AR_LINES_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
36 attribute13 OKL_CNSLD_AR_LINES_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
37 attribute14 OKL_CNSLD_AR_LINES_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
38 attribute15 OKL_CNSLD_AR_LINES_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
39 created_by NUMBER := Okc_Api.G_MISS_NUM,
40 creation_date OKL_CNSLD_AR_LINES_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
41 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
42 last_update_date OKL_CNSLD_AR_LINES_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
43 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
44 g_miss_lln_rec lln_rec_type;
45 TYPE lln_tbl_type IS TABLE OF lln_rec_type
46 INDEX BY BINARY_INTEGER;
47 TYPE okl_cnsld_ar_lines_tl_rec_type IS RECORD (
48 id NUMBER := Okc_Api.G_MISS_NUM,
49 LANGUAGE OKL_CNSLD_AR_LINES_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
50 source_lang OKL_CNSLD_AR_LINES_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
51 sfwt_flag OKL_CNSLD_AR_LINES_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
52 created_by NUMBER := Okc_Api.G_MISS_NUM,
53 creation_date OKL_CNSLD_AR_LINES_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
54 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
55 last_update_date OKL_CNSLD_AR_LINES_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
56 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
57 GMissOklCnsldArLinesTlRec okl_cnsld_ar_lines_tl_rec_type;
58 TYPE okl_cnsld_ar_lines_tl_tbl_type IS TABLE OF okl_cnsld_ar_lines_tl_rec_type
59 INDEX BY BINARY_INTEGER;
60 TYPE llnv_rec_type IS RECORD (
61 id NUMBER := Okc_Api.G_MISS_NUM,
62 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
63 sfwt_flag OKL_CNSLD_AR_LINES_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
64 khr_id NUMBER := Okc_Api.G_MISS_NUM,
65 cnr_id NUMBER := Okc_Api.G_MISS_NUM,
66 kle_id NUMBER := Okc_Api.G_MISS_NUM,
67 lln_id_parent NUMBER := Okc_Api.G_MISS_NUM,
68 ilt_id NUMBER := Okc_Api.G_MISS_NUM,
69 sequence_number NUMBER := Okc_Api.G_MISS_NUM,
70 amount NUMBER := Okc_Api.G_MISS_NUM,
71 tax_amount NUMBER := Okc_Api.G_MISS_NUM,
72 attribute_category OKL_CNSLD_AR_LINES_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
73 attribute1 OKL_CNSLD_AR_LINES_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
74 attribute2 OKL_CNSLD_AR_LINES_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
75 attribute3 OKL_CNSLD_AR_LINES_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
76 attribute4 OKL_CNSLD_AR_LINES_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
77 attribute5 OKL_CNSLD_AR_LINES_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
78 attribute6 OKL_CNSLD_AR_LINES_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
79 attribute7 OKL_CNSLD_AR_LINES_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
80 attribute8 OKL_CNSLD_AR_LINES_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
81 attribute9 OKL_CNSLD_AR_LINES_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
82 attribute10 OKL_CNSLD_AR_LINES_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
83 attribute11 OKL_CNSLD_AR_LINES_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
84 attribute12 OKL_CNSLD_AR_LINES_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
85 attribute13 OKL_CNSLD_AR_LINES_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
86 attribute14 OKL_CNSLD_AR_LINES_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
87 attribute15 OKL_CNSLD_AR_LINES_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
88 line_type OKL_CNSLD_AR_LINES_V.LINE_TYPE%TYPE := Okc_Api.G_MISS_CHAR,
89 request_id NUMBER := Okc_Api.G_MISS_NUM,
90 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
91 program_id NUMBER := Okc_Api.G_MISS_NUM,
92 program_update_date OKL_CNSLD_AR_LINES_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
93 org_id NUMBER := Okc_Api.G_MISS_NUM,
94 created_by NUMBER := Okc_Api.G_MISS_NUM,
95 creation_date OKL_CNSLD_AR_LINES_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
96 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
97 last_update_date OKL_CNSLD_AR_LINES_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
98 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
99 g_miss_llnv_rec llnv_rec_type;
100 TYPE llnv_tbl_type IS TABLE OF llnv_rec_type
101 INDEX BY BINARY_INTEGER;
102 ---------------------------------------------------------------------------
103 -- GLOBAL MESSAGE CONSTANTS
104 ---------------------------------------------------------------------------
105 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
106 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
107 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
108 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
109 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
110 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
111 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
112 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
113 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
114 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
115 ---------------------------------------------------------------------------
116 -- GLOBAL VARIABLES
117 ---------------------------------------------------------------------------
118 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_LLN_PVT';
119 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
120
121 /*************ADDED AFTER TAPI, Sunil T. Mathew (04/19/2001) ****************/
122 --GLOBAL MESSAGES
123 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
124 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
125 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
126 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
127 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
128
129
130 --GLOBAL VARIABLES
131 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_CNSLD_AR_LINES_V';
132 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
133
134
135 ---------------------------------------------------------------------------
136 -- Procedures and Functions
137 ---------------------------------------------------------------------------
138
139 PROCEDURE qc;
140 PROCEDURE change_version;
141 PROCEDURE api_copy;
142 PROCEDURE add_language;
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_llnv_rec IN llnv_rec_type,
150 x_llnv_rec OUT NOCOPY llnv_rec_type);
151
152 PROCEDURE insert_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_llnv_tbl IN llnv_tbl_type,
159 x_llnv_tbl OUT NOCOPY llnv_tbl_type);
160
161 PROCEDURE lock_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_llnv_rec IN llnv_rec_type);
168
169 PROCEDURE lock_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_llnv_tbl IN llnv_tbl_type);
176
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_llnv_rec IN llnv_rec_type,
184 x_llnv_rec OUT NOCOPY llnv_rec_type);
185
186 PROCEDURE update_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_llnv_tbl IN llnv_tbl_type,
193 x_llnv_tbl OUT NOCOPY llnv_tbl_type);
194
195 PROCEDURE delete_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_llnv_rec IN llnv_rec_type);
202
203 PROCEDURE delete_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_llnv_tbl IN llnv_tbl_type);
210
211 PROCEDURE validate_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_llnv_rec IN llnv_rec_type);
218
219 PROCEDURE validate_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_llnv_tbl IN llnv_tbl_type);
226
227 END Okl_Lln_Pvt;