[Home] [Help]
PACKAGE: APPS.OKC_TCU_PVT
Source
1 Package OKC_TCU_PVT AS
2 /* $Header: OKCSTCUS.pls 120.0 2005/05/25 23:10:54 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 ---------------------------------------------------------------------------
7 -- GLOBAL DATASTRUCTURES
8 ---------------------------------------------------------------------------
9 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13 --G_UNQS CONSTANT VARCHAR2(200) := 'OKC_VALUES_NOT_UNIQUE';
14 G_UNQS1 CONSTANT VARCHAR2(200) := 'OKC_TCE_UOM_CODE_NOT_UNIQUE';
15 G_UNQS2 CONSTANT VARCHAR2(200) := 'OKC_QTY_UOM_CODE_NOT_UNIQUE';
16 G_RETURN_STATUS VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
18 G_RECORD_STATUS VARCHAR2(1) := OKC_API.G_MISS_CHAR;
19 G_QUANTITY NUMBER := OKC_API.G_MISS_NUM;
20 TYPE tcu_rec_type IS RECORD (
21 tce_code OKC_TIME_CODE_UNITS_B.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
22 uom_code OKC_TIME_CODE_UNITS_B.uom_code%TYPE := OKC_API.G_MISS_CHAR,
23 quantity NUMBER := OKC_API.G_MISS_NUM,
24 active_flag OKC_TIME_CODE_UNITS_B.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25 object_version_number NUMBER := OKC_API.G_MISS_NUM,
26 created_by NUMBER := OKC_API.G_MISS_NUM,
27 creation_date OKC_TIME_CODE_UNITS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29 last_update_date OKC_TIME_CODE_UNITS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30 last_update_login NUMBER := OKC_API.G_MISS_NUM,
31 attribute_category OKC_TIME_CODE_UNITS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
32 attribute1 OKC_TIME_CODE_UNITS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
33 attribute2 OKC_TIME_CODE_UNITS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
34 attribute3 OKC_TIME_CODE_UNITS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
35 attribute4 OKC_TIME_CODE_UNITS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
36 attribute5 OKC_TIME_CODE_UNITS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
37 attribute6 OKC_TIME_CODE_UNITS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
38 attribute7 OKC_TIME_CODE_UNITS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
39 attribute8 OKC_TIME_CODE_UNITS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
40 attribute9 OKC_TIME_CODE_UNITS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
41 attribute10 OKC_TIME_CODE_UNITS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
42 attribute11 OKC_TIME_CODE_UNITS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
43 attribute12 OKC_TIME_CODE_UNITS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
44 attribute13 OKC_TIME_CODE_UNITS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
45 attribute14 OKC_TIME_CODE_UNITS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
46 attribute15 OKC_TIME_CODE_UNITS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
47 g_miss_tcu_rec tcu_rec_type;
48 TYPE tcu_tbl_type IS TABLE OF tcu_rec_type
49 INDEX BY BINARY_INTEGER;
50 TYPE OkcTimeCodeUnitsTlRecType IS RECORD (
51 uom_code OKC_TIME_CODE_UNITS_TL.uom_code%TYPE := OKC_API.G_MISS_CHAR,
52 tce_code OKC_TIME_CODE_UNITS_TL.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
53 language OKC_TIME_CODE_UNITS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
54 source_lang OKC_TIME_CODE_UNITS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
55 sfwt_flag OKC_TIME_CODE_UNITS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
56 short_description OKC_TIME_CODE_UNITS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
57 description OKC_TIME_CODE_UNITS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
58 comments OKC_TIME_CODE_UNITS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
59 created_by NUMBER := OKC_API.G_MISS_NUM,
60 creation_date OKC_TIME_CODE_UNITS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
61 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
62 last_update_date OKC_TIME_CODE_UNITS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
63 last_update_login NUMBER := OKC_API.G_MISS_NUM);
64 GMissOkcTimeCodeUnitsTlRec OkcTimeCodeUnitsTlRecType;
65 TYPE OkcTimeCodeUnitsTlTblType IS TABLE OF OkcTimeCodeUnitsTlRecType
66 INDEX BY BINARY_INTEGER;
67 TYPE tcuv_rec_type IS RECORD (
68 uom_code OKC_TIME_CODE_UNITS_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
69 tce_code OKC_TIME_CODE_UNITS_V.TCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
70 object_version_number NUMBER := OKC_API.G_MISS_NUM,
71 sfwt_flag OKC_TIME_CODE_UNITS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
72 quantity NUMBER := OKC_API.G_MISS_NUM,
73 active_flag OKC_TIME_CODE_UNITS_V.ACTIVE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
74 short_description OKC_TIME_CODE_UNITS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
75 description OKC_TIME_CODE_UNITS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
76 comments OKC_TIME_CODE_UNITS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
77 attribute_category OKC_TIME_CODE_UNITS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
78 attribute1 OKC_TIME_CODE_UNITS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
79 attribute2 OKC_TIME_CODE_UNITS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
80 attribute3 OKC_TIME_CODE_UNITS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
81 attribute4 OKC_TIME_CODE_UNITS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
82 attribute5 OKC_TIME_CODE_UNITS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
83 attribute6 OKC_TIME_CODE_UNITS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
84 attribute7 OKC_TIME_CODE_UNITS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
85 attribute8 OKC_TIME_CODE_UNITS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
86 attribute9 OKC_TIME_CODE_UNITS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
87 attribute10 OKC_TIME_CODE_UNITS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
88 attribute11 OKC_TIME_CODE_UNITS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
89 attribute12 OKC_TIME_CODE_UNITS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
90 attribute13 OKC_TIME_CODE_UNITS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
91 attribute14 OKC_TIME_CODE_UNITS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
92 attribute15 OKC_TIME_CODE_UNITS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
93 created_by NUMBER := OKC_API.G_MISS_NUM,
94 creation_date OKC_TIME_CODE_UNITS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
95 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
96 last_update_date OKC_TIME_CODE_UNITS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97 last_update_login NUMBER := OKC_API.G_MISS_NUM);
98 g_miss_tcuv_rec tcuv_rec_type;
99 TYPE tcuv_tbl_type IS TABLE OF tcuv_rec_type
100 INDEX BY BINARY_INTEGER;
101 ---------------------------------------------------------------------------
102 -- GLOBAL MESSAGE CONSTANTS
103 ---------------------------------------------------------------------------
104 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
105 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
106 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
107 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
108 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
109 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
110 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
111 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
112 G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(30) := 'COL_NAME1';
113 G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(30) := 'COL_NAME2';
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) := 'OKC_TCU_PVT';
120 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
121 ---------------------------------------------------------------------------
122 -- Procedures and Functions
123 ---------------------------------------------------------------------------
124
125 PROCEDURE qc;
126 PROCEDURE change_version;
127 PROCEDURE api_copy;
128 PROCEDURE add_language;
129 PROCEDURE insert_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_tcuv_rec IN tcuv_rec_type,
136 x_tcuv_rec OUT NOCOPY tcuv_rec_type);
137
138 PROCEDURE insert_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_tcuv_tbl IN tcuv_tbl_type,
145 x_tcuv_tbl OUT NOCOPY tcuv_tbl_type);
146
147 PROCEDURE lock_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_tcuv_rec IN tcuv_rec_type);
154
155 PROCEDURE lock_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_tcuv_tbl IN tcuv_tbl_type);
162
163 PROCEDURE update_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_tcuv_rec IN tcuv_rec_type,
170 x_tcuv_rec OUT NOCOPY tcuv_rec_type);
171
172 PROCEDURE update_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_tcuv_tbl IN tcuv_tbl_type,
179 x_tcuv_tbl OUT NOCOPY tcuv_tbl_type);
180
181 PROCEDURE delete_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_tcuv_rec IN tcuv_rec_type);
188
189 PROCEDURE delete_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_tcuv_tbl IN tcuv_tbl_type);
196
197 PROCEDURE validate_row(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_tcuv_rec IN tcuv_rec_type);
204
205 PROCEDURE validate_row(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_tcuv_tbl IN tcuv_tbl_type);
212
213 END OKC_TCU_PVT;