[Home] [Help]
PACKAGE: APPS.OKL_ILT_PVT
Source
1 PACKAGE Okl_Ilt_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSILTS.pls 115.3 2002/02/12 14:31:39 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ilt_rec_type IS RECORD (
7 id NUMBER := okl_api.G_MISS_NUM,
8 ity_id NUMBER := okl_api.G_MISS_NUM,
9 object_version_number NUMBER := okl_api.G_MISS_NUM,
10 sequence_number NUMBER := okl_api.G_MISS_NUM,
11 attribute_category OKL_INVC_LINE_TYPES_B.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
12 attribute1 OKL_INVC_LINE_TYPES_B.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
13 attribute2 OKL_INVC_LINE_TYPES_B.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
14 attribute3 OKL_INVC_LINE_TYPES_B.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
15 attribute4 OKL_INVC_LINE_TYPES_B.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
16 attribute5 OKL_INVC_LINE_TYPES_B.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
17 attribute6 OKL_INVC_LINE_TYPES_B.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
18 attribute7 OKL_INVC_LINE_TYPES_B.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
19 attribute8 OKL_INVC_LINE_TYPES_B.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
20 attribute9 OKL_INVC_LINE_TYPES_B.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
21 attribute10 OKL_INVC_LINE_TYPES_B.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
22 attribute11 OKL_INVC_LINE_TYPES_B.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
23 attribute12 OKL_INVC_LINE_TYPES_B.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
24 attribute13 OKL_INVC_LINE_TYPES_B.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
25 attribute14 OKL_INVC_LINE_TYPES_B.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
26 attribute15 OKL_INVC_LINE_TYPES_B.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
27 created_by NUMBER := okl_api.G_MISS_NUM,
28 creation_date OKL_INVC_LINE_TYPES_B.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
29 last_updated_by NUMBER := okl_api.G_MISS_NUM,
30 last_update_date OKL_INVC_LINE_TYPES_B.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
31 last_update_login NUMBER := okl_api.G_MISS_NUM);
32 g_miss_ilt_rec ilt_rec_type;
33 TYPE ilt_tbl_type IS TABLE OF ilt_rec_type
34 INDEX BY BINARY_INTEGER;
35 TYPE OklInvcLineTypesTlRecType IS RECORD (
36 id NUMBER := okl_api.G_MISS_NUM,
37 LANGUAGE OKL_INVC_LINE_TYPES_TL.LANGUAGE%TYPE := okl_api.G_MISS_CHAR,
38 source_lang OKL_INVC_LINE_TYPES_TL.SOURCE_LANG%TYPE := okl_api.G_MISS_CHAR,
39 sfwt_flag OKL_INVC_LINE_TYPES_TL.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
40 name OKL_INVC_LINE_TYPES_TL.NAME%TYPE := okl_api.G_MISS_CHAR,
41 description OKL_INVC_LINE_TYPES_TL.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
42 created_by NUMBER := okl_api.G_MISS_NUM,
43 creation_date OKL_INVC_LINE_TYPES_TL.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
44 last_updated_by NUMBER := okl_api.G_MISS_NUM,
45 last_update_date OKL_INVC_LINE_TYPES_TL.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
46 last_update_login NUMBER := okl_api.G_MISS_NUM);
47 GMissOklInvcLineTypesTlRec OklInvcLineTypesTlRecType;
48 TYPE OklInvcLineTypesTlTblType IS TABLE OF OklInvcLineTypesTlRecType
49 INDEX BY BINARY_INTEGER;
50 TYPE iltv_rec_type IS RECORD (
51 id NUMBER := okl_api.G_MISS_NUM,
52 object_version_number NUMBER := okl_api.G_MISS_NUM,
53 sfwt_flag OKL_INVC_LINE_TYPES_V.SFWT_FLAG%TYPE := okl_api.G_MISS_CHAR,
54 ity_id NUMBER := okl_api.G_MISS_NUM,
55 sequence_number NUMBER := okl_api.G_MISS_NUM,
56 name OKL_INVC_LINE_TYPES_V.NAME%TYPE := okl_api.G_MISS_CHAR,
57 description OKL_INVC_LINE_TYPES_V.DESCRIPTION%TYPE := okl_api.G_MISS_CHAR,
58 attribute_category OKL_INVC_LINE_TYPES_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
59 attribute1 OKL_INVC_LINE_TYPES_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
60 attribute2 OKL_INVC_LINE_TYPES_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
61 attribute3 OKL_INVC_LINE_TYPES_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
62 attribute4 OKL_INVC_LINE_TYPES_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
63 attribute5 OKL_INVC_LINE_TYPES_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
64 attribute6 OKL_INVC_LINE_TYPES_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
65 attribute7 OKL_INVC_LINE_TYPES_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
66 attribute8 OKL_INVC_LINE_TYPES_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
67 attribute9 OKL_INVC_LINE_TYPES_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
68 attribute10 OKL_INVC_LINE_TYPES_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
69 attribute11 OKL_INVC_LINE_TYPES_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
70 attribute12 OKL_INVC_LINE_TYPES_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
71 attribute13 OKL_INVC_LINE_TYPES_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
72 attribute14 OKL_INVC_LINE_TYPES_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
73 attribute15 OKL_INVC_LINE_TYPES_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
74 created_by NUMBER := okl_api.G_MISS_NUM,
75 creation_date OKL_INVC_LINE_TYPES_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
76 last_updated_by NUMBER := okl_api.G_MISS_NUM,
77 last_update_date OKL_INVC_LINE_TYPES_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
78 last_update_login NUMBER := okl_api.G_MISS_NUM);
79 g_miss_iltv_rec iltv_rec_type;
80 TYPE iltv_tbl_type IS TABLE OF iltv_rec_type
81 INDEX BY BINARY_INTEGER;
82 ---------------------------------------------------------------------------
83 -- GLOBAL MESSAGE CONSTANTS
84 ---------------------------------------------------------------------------
85 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
86 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
87 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
88 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
89 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
90 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
91 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
92 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
93 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
94 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
95
96 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
97 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
98 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
99 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
100 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
101 ---------------------------------------------------------------------------
102 -- GLOBAL VARIABLES
103 ---------------------------------------------------------------------------
104 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ILT_PVT';
105 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
106
107 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_XTD_SELL_INVS_V';
108 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
109
110
111 ---------------------------------------------------------------------------
112 -- Procedures and Functions
113 ---------------------------------------------------------------------------
114
115 PROCEDURE qc;
116 PROCEDURE change_version;
117 PROCEDURE api_copy;
118 PROCEDURE add_language;
119 PROCEDURE insert_row(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_iltv_rec IN iltv_rec_type,
126 x_iltv_rec OUT NOCOPY iltv_rec_type);
127
128 PROCEDURE insert_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_iltv_tbl IN iltv_tbl_type,
135 x_iltv_tbl OUT NOCOPY iltv_tbl_type);
136
137 PROCEDURE lock_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_iltv_rec IN iltv_rec_type);
144
145 PROCEDURE lock_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_iltv_tbl IN iltv_tbl_type);
152
153 PROCEDURE update_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_iltv_rec IN iltv_rec_type,
160 x_iltv_rec OUT NOCOPY iltv_rec_type);
161
162 PROCEDURE update_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_iltv_tbl IN iltv_tbl_type,
169 x_iltv_tbl OUT NOCOPY iltv_tbl_type);
170
171 PROCEDURE delete_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_iltv_rec IN iltv_rec_type);
178
179 PROCEDURE delete_row(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_iltv_tbl IN iltv_tbl_type);
186
187 PROCEDURE validate_row(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_iltv_rec IN iltv_rec_type);
194
195 PROCEDURE validate_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_iltv_tbl IN iltv_tbl_type);
202
203 END Okl_Ilt_Pvt;