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