[Home] [Help]
PACKAGE: APPS.OKL_IMS_PVT
Source
1 PACKAGE OKL_IMS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSIMSS.pls 115.3 2002/07/05 23:44:22 sanahuja noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ims_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 org_id NUMBER := OKC_API.G_MISS_NUM,
9 priority NUMBER := OKC_API.G_MISS_NUM,
10 object_version_number NUMBER := OKC_API.G_MISS_NUM,
11 end_date OKL_INVOICE_MSSGS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12 attribute_category OKL_INVOICE_MSSGS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
13 attribute1 OKL_INVOICE_MSSGS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
14 attribute2 OKL_INVOICE_MSSGS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
15 attribute3 OKL_INVOICE_MSSGS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
16 attribute4 OKL_INVOICE_MSSGS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
17 attribute5 OKL_INVOICE_MSSGS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
18 attribute6 OKL_INVOICE_MSSGS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
19 attribute7 OKL_INVOICE_MSSGS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
20 attribute8 OKL_INVOICE_MSSGS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
21 attribute9 OKL_INVOICE_MSSGS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
22 attribute10 OKL_INVOICE_MSSGS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
23 attribute11 OKL_INVOICE_MSSGS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
24 attribute12 OKL_INVOICE_MSSGS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
25 attribute13 OKL_INVOICE_MSSGS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
26 attribute14 OKL_INVOICE_MSSGS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
27 attribute15 OKL_INVOICE_MSSGS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
28 created_by NUMBER := OKC_API.G_MISS_NUM,
29 creation_date OKL_INVOICE_MSSGS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
31 last_update_date OKL_INVOICE_MSSGS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
32 last_update_login NUMBER := OKC_API.G_MISS_NUM,
33 start_date OKL_INVOICE_MSSGS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
34 pkg_name OKL_INVOICE_MSSGS_B.PKG_NAME%TYPE := OKC_API.G_MISS_CHAR,
35 proc_name OKL_INVOICE_MSSGS_B.PROC_NAME%TYPE := OKC_API.G_MISS_CHAR);
36 g_miss_ims_rec ims_rec_type;
37 TYPE ims_tbl_type IS TABLE OF ims_rec_type
38 INDEX BY BINARY_INTEGER;
39 TYPE okl_invoice_mssgs_tl_rec_type IS RECORD (
40 id NUMBER := OKC_API.G_MISS_NUM,
41 language OKL_INVOICE_MSSGS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42 source_lang OKL_INVOICE_MSSGS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43 sfwt_flag OKL_INVOICE_MSSGS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44 name OKL_INVOICE_MSSGS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
45 message_text OKL_INVOICE_MSSGS_TL.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
46 description OKL_INVOICE_MSSGS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
47 created_by NUMBER := OKC_API.G_MISS_NUM,
48 creation_date OKL_INVOICE_MSSGS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
49 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
50 last_update_date OKL_INVOICE_MSSGS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
51 last_update_login NUMBER := OKC_API.G_MISS_NUM);
52 GMissOklInvoiceMssgsTlRec okl_invoice_mssgs_tl_rec_type;
53 TYPE okl_invoice_mssgs_tl_tbl_type IS TABLE OF okl_invoice_mssgs_tl_rec_type
54 INDEX BY BINARY_INTEGER;
55 TYPE imsv_rec_type IS RECORD (
56 id NUMBER := OKC_API.G_MISS_NUM,
57 org_id NUMBER := OKC_API.G_MISS_NUM,
58 object_version_number NUMBER := OKC_API.G_MISS_NUM,
59 sfwt_flag OKL_INVOICE_MSSGS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60 name OKL_INVOICE_MSSGS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
61 message_text OKL_INVOICE_MSSGS_V.MESSAGE_TEXT%TYPE := OKC_API.G_MISS_CHAR,
62 priority NUMBER := OKC_API.G_MISS_NUM,
63 description OKL_INVOICE_MSSGS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
64 end_date OKL_INVOICE_MSSGS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
65 attribute_category OKL_INVOICE_MSSGS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
66 attribute1 OKL_INVOICE_MSSGS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
67 attribute2 OKL_INVOICE_MSSGS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
68 attribute3 OKL_INVOICE_MSSGS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
69 attribute4 OKL_INVOICE_MSSGS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
70 attribute5 OKL_INVOICE_MSSGS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
71 attribute6 OKL_INVOICE_MSSGS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
72 attribute7 OKL_INVOICE_MSSGS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
73 attribute8 OKL_INVOICE_MSSGS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
74 attribute9 OKL_INVOICE_MSSGS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
75 attribute10 OKL_INVOICE_MSSGS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
76 attribute11 OKL_INVOICE_MSSGS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
77 attribute12 OKL_INVOICE_MSSGS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
78 attribute13 OKL_INVOICE_MSSGS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
79 attribute14 OKL_INVOICE_MSSGS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
80 attribute15 OKL_INVOICE_MSSGS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
81 created_by NUMBER := OKC_API.G_MISS_NUM,
82 creation_date OKL_INVOICE_MSSGS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
83 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
84 last_update_date OKL_INVOICE_MSSGS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
85 last_update_login NUMBER := OKC_API.G_MISS_NUM,
86 start_date OKL_INVOICE_MSSGS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
87 pkg_name OKL_INVOICE_MSSGS_V.PKG_NAME%TYPE := OKC_API.G_MISS_CHAR,
88 proc_name OKL_INVOICE_MSSGS_V.PROC_NAME%TYPE := OKC_API.G_MISS_CHAR);
89 g_miss_imsv_rec imsv_rec_type;
90 TYPE imsv_tbl_type IS TABLE OF imsv_rec_type
91 INDEX BY BINARY_INTEGER;
92 ---------------------------------------------------------------------------
93 -- GLOBAL MESSAGE CONSTANTS
94 ---------------------------------------------------------------------------
95 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
96 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
97 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
98 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
99 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
100 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
101 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
102 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
103 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
104 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
105 ---------------------------------------------------------------------------
106 -- GLOBAL VARIABLES
107 ---------------------------------------------------------------------------
108 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IMS_PVT';
109 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
110 ---------------------------------------------------------------------------
111 -- Procedures and Functions
112 ---------------------------------------------------------------------------
113
114 PROCEDURE qc;
115 PROCEDURE change_version;
116 PROCEDURE api_copy;
117 PROCEDURE add_language;
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_imsv_rec IN imsv_rec_type,
125 x_imsv_rec OUT NOCOPY imsv_rec_type);
126
127 PROCEDURE insert_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_imsv_tbl IN imsv_tbl_type,
134 x_imsv_tbl OUT NOCOPY imsv_tbl_type);
135
136 PROCEDURE lock_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_imsv_rec IN imsv_rec_type);
143
144 PROCEDURE lock_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_imsv_tbl IN imsv_tbl_type);
151
152 PROCEDURE update_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_imsv_rec IN imsv_rec_type,
159 x_imsv_rec OUT NOCOPY imsv_rec_type);
160
161 PROCEDURE update_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_imsv_tbl IN imsv_tbl_type,
168 x_imsv_tbl OUT NOCOPY imsv_tbl_type);
169
170 PROCEDURE delete_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_imsv_rec IN imsv_rec_type);
177
178 PROCEDURE delete_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_imsv_tbl IN imsv_tbl_type);
185
186 PROCEDURE validate_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_imsv_rec IN imsv_rec_type);
193
194 PROCEDURE validate_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_imsv_tbl IN imsv_tbl_type);
201
202 END OKL_IMS_PVT;
203