[Home] [Help]
PACKAGE: APPS.OKL_ITI_PVT
Source
1 Package OKL_ITI_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSITIS.pls 115.6 2002/12/07 18:53:29 avsingh noship $ */
3 -- Badrinath Kuchibholta
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES
6 ---------------------------------------------------------------------------
7 TYPE iti_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM,
9 object_version_number NUMBER := OKC_API.G_MISS_NUM,
10 tas_id NUMBER := OKC_API.G_MISS_NUM,
11 tal_id NUMBER := OKC_API.G_MISS_NUM,
12 kle_id NUMBER := OKC_API.G_MISS_NUM,
13 tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
14 line_number NUMBER := OKC_API.G_MISS_NUM,
15 instance_number_ib OKL_TXL_ITM_INSTS.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
16 object_id1_new OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
17 object_id2_new OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
18 jtot_object_code_new OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
19 object_id1_old OKL_TXL_ITM_INSTS.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
20 object_id2_old OKL_TXL_ITM_INSTS.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
21 jtot_object_code_old OKL_TXL_ITM_INSTS.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
22 inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
23 serial_number OKL_TXL_ITM_INSTS.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
24 mfg_serial_number_yn OKL_TXL_ITM_INSTS.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
25 inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
26 inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
27 attribute_category OKL_TXL_ITM_INSTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
28 attribute1 OKL_TXL_ITM_INSTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
29 attribute2 OKL_TXL_ITM_INSTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
30 attribute3 OKL_TXL_ITM_INSTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
31 attribute4 OKL_TXL_ITM_INSTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
32 attribute5 OKL_TXL_ITM_INSTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
33 attribute6 OKL_TXL_ITM_INSTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
34 attribute7 OKL_TXL_ITM_INSTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
35 attribute8 OKL_TXL_ITM_INSTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
36 attribute9 OKL_TXL_ITM_INSTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
37 attribute10 OKL_TXL_ITM_INSTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
38 attribute11 OKL_TXL_ITM_INSTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
39 attribute12 OKL_TXL_ITM_INSTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
40 attribute13 OKL_TXL_ITM_INSTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
41 attribute14 OKL_TXL_ITM_INSTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
42 attribute15 OKL_TXL_ITM_INSTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
43 created_by NUMBER := OKC_API.G_MISS_NUM,
44 creation_date OKL_TXL_ITM_INSTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
45 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
46 last_update_date OKL_TXL_ITM_INSTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
47 last_update_login NUMBER := OKC_API.G_MISS_NUM,
48 dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
49 --Bug# Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
50 instance_id NUMBER := OKC_API.G_MISS_NUM,
51 selected_for_split_flag OKL_TXL_ITM_INSTS.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52 asd_id NUMBER := OKC_API.G_MISS_NUM);
53 g_miss_iti_rec iti_rec_type;
54 TYPE iti_tbl_type IS TABLE OF iti_rec_type
55 INDEX BY BINARY_INTEGER;
56 TYPE itiv_rec_type IS RECORD (
57 id NUMBER := OKC_API.G_MISS_NUM,
58 object_version_number NUMBER := OKC_API.G_MISS_NUM,
59 tas_id NUMBER := OKC_API.G_MISS_NUM,
60 tal_id NUMBER := OKC_API.G_MISS_NUM,
61 kle_id NUMBER := OKC_API.G_MISS_NUM,
62 tal_type OKL_TXL_ITM_INSTS.TAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63 line_number NUMBER := OKC_API.G_MISS_NUM,
64 instance_number_ib OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE := OKC_API.G_MISS_CHAR,
65 object_id1_new OKL_TXL_ITM_INSTS_V.OBJECT_ID1_NEW%TYPE := OKC_API.G_MISS_CHAR,
66 object_id2_new OKL_TXL_ITM_INSTS_V.OBJECT_ID2_NEW%TYPE := OKC_API.G_MISS_CHAR,
67 jtot_object_code_new OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_NEW%TYPE := OKC_API.G_MISS_CHAR,
68 object_id1_old OKL_TXL_ITM_INSTS_V.OBJECT_ID1_OLD%TYPE := OKC_API.G_MISS_CHAR,
69 object_id2_old OKL_TXL_ITM_INSTS_V.OBJECT_ID2_OLD%TYPE := OKC_API.G_MISS_CHAR,
70 jtot_object_code_old OKL_TXL_ITM_INSTS_V.JTOT_OBJECT_CODE_OLD%TYPE := OKC_API.G_MISS_CHAR,
71 inventory_org_id NUMBER := OKC_API.G_MISS_NUM,
72 serial_number OKL_TXL_ITM_INSTS_V.SERIAL_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
73 mfg_serial_number_yn OKL_TXL_ITM_INSTS_V.MFG_SERIAL_NUMBER_YN%TYPE := OKC_API.G_MISS_CHAR,
74 inventory_item_id NUMBER := OKC_API.G_MISS_NUM,
75 inv_master_org_id NUMBER := OKC_API.G_MISS_NUM,
76 attribute_category OKL_TXL_ITM_INSTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
77 attribute1 OKL_TXL_ITM_INSTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
78 attribute2 OKL_TXL_ITM_INSTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
79 attribute3 OKL_TXL_ITM_INSTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
80 attribute4 OKL_TXL_ITM_INSTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
81 attribute5 OKL_TXL_ITM_INSTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
82 attribute6 OKL_TXL_ITM_INSTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
83 attribute7 OKL_TXL_ITM_INSTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
84 attribute8 OKL_TXL_ITM_INSTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
85 attribute9 OKL_TXL_ITM_INSTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
86 attribute10 OKL_TXL_ITM_INSTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
87 attribute11 OKL_TXL_ITM_INSTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
88 attribute12 OKL_TXL_ITM_INSTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
89 attribute13 OKL_TXL_ITM_INSTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
90 attribute14 OKL_TXL_ITM_INSTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
91 attribute15 OKL_TXL_ITM_INSTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
92 created_by NUMBER := OKC_API.G_MISS_NUM,
93 creation_date OKL_TXL_ITM_INSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
94 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
95 last_update_date OKL_TXL_ITM_INSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96 last_update_login NUMBER := OKC_API.G_MISS_NUM,
97 dnz_cle_id NUMBER := OKC_API.G_MISS_NUM,
98 --Bug#Bug# 2697681 schema change : 11.5.9 enhacement - split asset by serial numbers
99 instance_id NUMBER := OKC_API.G_MISS_NUM,
100 selected_for_split_flag OKL_TXL_ITM_INSTS_V.SELECTED_FOR_SPLIT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
101 asd_id NUMBER := OKC_API.G_MISS_NUM);
102 g_miss_itiv_rec itiv_rec_type;
103 TYPE itiv_tbl_type IS TABLE OF itiv_rec_type
104 INDEX BY BINARY_INTEGER;
105 ---------------------------------------------------------------------------
106 -- GLOBAL MESSAGE CONSTANTS
107 ---------------------------------------------------------------------------
108 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
109 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
110 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
111 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
112 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
113 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
114 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
115 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
116 ---------------------------------------------------------------------------
117 -- GLOBAL VARIABLES
118 ---------------------------------------------------------------------------
119 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ITI_PVT';
120 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
121 ---------------------------------------------------------------------------
122 -- Procedures and Functions
123 ---------------------------------------------------------------------------
124
125 PROCEDURE qc;
126 PROCEDURE change_version;
127 PROCEDURE api_copy;
128 PROCEDURE insert_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_itiv_rec IN itiv_rec_type,
135 x_itiv_rec OUT NOCOPY itiv_rec_type);
136
137 PROCEDURE insert_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_itiv_tbl IN itiv_tbl_type,
144 x_itiv_tbl OUT NOCOPY itiv_tbl_type);
145
146 PROCEDURE lock_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_itiv_rec IN itiv_rec_type);
153
154 PROCEDURE lock_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_itiv_tbl IN itiv_tbl_type);
161
162 PROCEDURE update_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_itiv_rec IN itiv_rec_type,
169 x_itiv_rec OUT NOCOPY itiv_rec_type);
170
171 PROCEDURE update_row(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_itiv_tbl IN itiv_tbl_type,
178 x_itiv_tbl OUT NOCOPY itiv_tbl_type);
179
180 PROCEDURE delete_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_itiv_rec IN itiv_rec_type);
187
188 PROCEDURE delete_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_itiv_tbl IN itiv_tbl_type);
195
196 PROCEDURE validate_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_itiv_rec IN itiv_rec_type);
203
204 PROCEDURE validate_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_itiv_tbl IN itiv_tbl_type);
211
212 END OKL_ITI_PVT;