[Home] [Help]
PACKAGE: APPS.OKL_INF_PVT
Source
1 PACKAGE Okl_Inf_Pvt AS
2 /* $Header: OKLSINFS.pls 120.2 2005/10/30 04:42:57 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE inf_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 contract_level_yn OKL_INVOICE_FORMATS_B.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
9 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
10 ilt_id NUMBER := Okl_Api.G_MISS_NUM,
11 org_id NUMBER := Okl_Api.G_MISS_NUM,
12 start_date OKL_INVOICE_FORMATS_B.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
13 end_date OKL_INVOICE_FORMATS_B.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
14 attribute_category OKL_INVOICE_FORMATS_B.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
15 attribute1 OKL_INVOICE_FORMATS_B.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute2 OKL_INVOICE_FORMATS_B.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute3 OKL_INVOICE_FORMATS_B.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute4 OKL_INVOICE_FORMATS_B.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute5 OKL_INVOICE_FORMATS_B.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute6 OKL_INVOICE_FORMATS_B.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute7 OKL_INVOICE_FORMATS_B.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute8 OKL_INVOICE_FORMATS_B.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute9 OKL_INVOICE_FORMATS_B.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute10 OKL_INVOICE_FORMATS_B.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute11 OKL_INVOICE_FORMATS_B.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute12 OKL_INVOICE_FORMATS_B.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute13 OKL_INVOICE_FORMATS_B.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute14 OKL_INVOICE_FORMATS_B.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute15 OKL_INVOICE_FORMATS_B.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
30 created_by NUMBER := Okl_Api.G_MISS_NUM,
31 creation_date OKL_INVOICE_FORMATS_B.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
32 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
33 last_update_date OKL_INVOICE_FORMATS_B.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
34 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
35 g_miss_inf_rec inf_rec_type;
36 TYPE inf_tbl_type IS TABLE OF inf_rec_type
37 INDEX BY BINARY_INTEGER;
38 TYPE OklInvoiceFormatsTlRecType IS RECORD (
39 id NUMBER := Okl_Api.G_MISS_NUM,
40 LANGUAGE OKL_INVOICE_FORMATS_TL.LANGUAGE%TYPE := Okl_Api.G_MISS_CHAR,
41 source_lang OKL_INVOICE_FORMATS_TL.SOURCE_LANG%TYPE := Okl_Api.G_MISS_CHAR,
42 sfwt_flag OKL_INVOICE_FORMATS_TL.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
43 name OKL_INVOICE_FORMATS_TL.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44 description OKL_INVOICE_FORMATS_TL.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
45 created_by NUMBER := Okl_Api.G_MISS_NUM,
46 creation_date OKL_INVOICE_FORMATS_TL.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
47 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
48 last_update_date OKL_INVOICE_FORMATS_TL.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
49 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
50 GMissOklInvoiceFormatsTlRec OklInvoiceFormatsTlRecType;
51 TYPE OklInvoiceFormatsTlTblType IS TABLE OF OklInvoiceFormatsTlRecType
52 INDEX BY BINARY_INTEGER;
53 TYPE infv_rec_type IS RECORD (
54 id NUMBER := Okl_Api.G_MISS_NUM,
55 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
56 ilt_id NUMBER := Okl_Api.G_MISS_NUM,
57 org_id NUMBER := Okl_Api.G_MISS_NUM,
58 sfwt_flag OKL_INVOICE_FORMATS_V.SFWT_FLAG%TYPE := Okl_Api.G_MISS_CHAR,
59 name OKL_INVOICE_FORMATS_V.NAME%TYPE := Okl_Api.G_MISS_CHAR,
60 description OKL_INVOICE_FORMATS_V.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
61 contract_level_yn OKL_INVOICE_FORMATS_V.CONTRACT_LEVEL_YN%TYPE := Okl_Api.G_MISS_CHAR,
62 start_date OKL_INVOICE_FORMATS_V.START_DATE%TYPE := Okl_Api.G_MISS_DATE,
63 end_date OKL_INVOICE_FORMATS_V.END_DATE%TYPE := Okl_Api.G_MISS_DATE,
64 attribute_category OKL_INVOICE_FORMATS_V.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
65 attribute1 OKL_INVOICE_FORMATS_V.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
66 attribute2 OKL_INVOICE_FORMATS_V.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
67 attribute3 OKL_INVOICE_FORMATS_V.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
68 attribute4 OKL_INVOICE_FORMATS_V.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
69 attribute5 OKL_INVOICE_FORMATS_V.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
70 attribute6 OKL_INVOICE_FORMATS_V.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
71 attribute7 OKL_INVOICE_FORMATS_V.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
72 attribute8 OKL_INVOICE_FORMATS_V.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
73 attribute9 OKL_INVOICE_FORMATS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
74 attribute10 OKL_INVOICE_FORMATS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
75 attribute11 OKL_INVOICE_FORMATS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
76 attribute12 OKL_INVOICE_FORMATS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
77 attribute13 OKL_INVOICE_FORMATS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
78 attribute14 OKL_INVOICE_FORMATS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
79 attribute15 OKL_INVOICE_FORMATS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
80 created_by NUMBER := okl_api.G_MISS_NUM,
81 creation_date OKL_INVOICE_FORMATS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
82 last_updated_by NUMBER := okl_api.G_MISS_NUM,
83 last_update_date OKL_INVOICE_FORMATS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
84 last_update_login NUMBER := okl_api.G_MISS_NUM);
85 g_miss_infv_rec infv_rec_type;
86 TYPE infv_tbl_type IS TABLE OF infv_rec_type
87 INDEX BY BINARY_INTEGER;
88 ---------------------------------------------------------------------------
89 -- GLOBAL MESSAGE CONSTANTS
90 ---------------------------------------------------------------------------
91 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
92 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
93 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
94 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
95 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
96 -- G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
97
98 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okc_api.G_REQUIRED_VALUE;
99
100 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
101 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
102 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
103 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
104
105 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
106 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
107 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
108 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
109 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
110 ---------------------------------------------------------------------------
111 -- GLOBAL VARIABLES
112 ---------------------------------------------------------------------------
113 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_INF_PVT';
114 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
115
116 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_INVOICE_FORMATS_V';
117 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
118
119
120 ---------------------------------------------------------------------------
121 -- Procedures and Functions
122 ---------------------------------------------------------------------------
123
124 PROCEDURE qc;
125 PROCEDURE change_version;
126 PROCEDURE api_copy;
127 PROCEDURE add_language;
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_infv_rec IN infv_rec_type,
135 x_infv_rec OUT NOCOPY infv_rec_type);
136
137 PROCEDURE insert_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_infv_tbl IN infv_tbl_type,
144 x_infv_tbl OUT NOCOPY infv_tbl_type);
145
146 PROCEDURE lock_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_infv_rec IN infv_rec_type);
153
154 PROCEDURE lock_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_infv_tbl IN infv_tbl_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_infv_rec IN infv_rec_type,
169 x_infv_rec OUT NOCOPY infv_rec_type);
170
171 PROCEDURE update_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_infv_tbl IN infv_tbl_type,
178 x_infv_tbl OUT NOCOPY infv_tbl_type);
179
180 PROCEDURE delete_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_infv_rec IN infv_rec_type);
187
188 PROCEDURE delete_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_infv_tbl IN infv_tbl_type);
195
196 PROCEDURE validate_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_infv_rec IN infv_rec_type);
203
204 PROCEDURE validate_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_infv_tbl IN infv_tbl_type);
211
212 END Okl_Inf_Pvt;