[Home] [Help]
PACKAGE: APPS.OKL_AVL_PVT
Source
1 PACKAGE OKL_AVL_PVT AS
2 /* $Header: OKLSAVLS.pls 120.2 2006/07/11 10:10:46 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE avl_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
9 set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
10 sty_id NUMBER := OKC_API.G_MISS_NUM,
11 try_id NUMBER := OKC_API.G_MISS_NUM,
12 aes_id NUMBER := OKC_API.G_MISS_NUM,
13 syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14 fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
15 fma_id NUMBER := OKC_API.G_MISS_NUM,
16 advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
17 post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
18 version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
19 start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20 object_version_number NUMBER := OKC_API.G_MISS_NUM,
21 memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
22 prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
23 description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
24 factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25 end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
26 accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
27 org_id NUMBER := OKC_API.G_MISS_NUM,
28 attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
29 attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
30 attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
31 attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
32 attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
33 attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
34 attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
35 attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
36 attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
37 attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
38 attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
39 attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
40 attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
41 attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
42 attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
43 attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
44 created_by NUMBER := OKC_API.G_MISS_NUM,
45 creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
46 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
47 last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
48 last_update_login NUMBER := OKC_API.G_MISS_NUM,
49
50 -- Added by HKPATEL for securitization changes
51 inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);
52
53 g_miss_avl_rec avl_rec_type;
54 TYPE avl_tbl_type IS TABLE OF avl_rec_type
55 INDEX BY BINARY_INTEGER;
56
57 TYPE avlv_rec_type IS RECORD (
58 id NUMBER := OKC_API.G_MISS_NUM,
59 object_version_number NUMBER := OKC_API.G_MISS_NUM,
60 try_id NUMBER := OKC_API.G_MISS_NUM,
61 aes_id NUMBER := OKC_API.G_MISS_NUM,
62 sty_id NUMBER := OKC_API.G_MISS_NUM,
63 fma_id NUMBER := OKC_API.G_MISS_NUM,
64 set_of_books_id NUMBER := OKC_API.G_MISS_NUM,
65 fac_code OKL_AE_TEMPLATES.FAC_CODE%TYPE := OKC_API.G_MISS_CHAR,
66 syt_code OKL_AE_TEMPLATES.SYT_CODE%TYPE := OKC_API.G_MISS_CHAR,
67 post_to_gl OKL_AE_TEMPLATES.POST_TO_GL%TYPE := OKC_API.G_MISS_CHAR,
68 advance_arrears OKL_AE_TEMPLATES.ADVANCE_ARREARS%TYPE := OKC_API.G_MISS_CHAR,
69 memo_yn OKL_AE_TEMPLATES.MEMO_YN%TYPE := OKC_API.G_MISS_CHAR,
70 prior_year_yn OKL_AE_TEMPLATES.PRIOR_YEAR_YN%TYPE := OKC_API.G_MISS_CHAR,
71 name OKL_AE_TEMPLATES.NAME%TYPE := OKC_API.G_MISS_CHAR,
72 description OKL_AE_TEMPLATES.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
73 version OKL_AE_TEMPLATES.VERSION%TYPE := OKC_API.G_MISS_CHAR,
74 factoring_synd_flag OKL_AE_TEMPLATES.FACTORING_SYND_FLAG%TYPE := OKC_API.G_MISS_CHAR,
75 start_date OKL_AE_TEMPLATES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
76 end_date OKL_AE_TEMPLATES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
77 accrual_yn OKL_AE_TEMPLATES.ACCRUAL_YN%TYPE := OKC_API.G_MISS_CHAR,
78 attribute_category OKL_AE_TEMPLATES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79 attribute1 OKL_AE_TEMPLATES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80 attribute2 OKL_AE_TEMPLATES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81 attribute3 OKL_AE_TEMPLATES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82 attribute4 OKL_AE_TEMPLATES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83 attribute5 OKL_AE_TEMPLATES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84 attribute6 OKL_AE_TEMPLATES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85 attribute7 OKL_AE_TEMPLATES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86 attribute8 OKL_AE_TEMPLATES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87 attribute9 OKL_AE_TEMPLATES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88 attribute10 OKL_AE_TEMPLATES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89 attribute11 OKL_AE_TEMPLATES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90 attribute12 OKL_AE_TEMPLATES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91 attribute13 OKL_AE_TEMPLATES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92 attribute14 OKL_AE_TEMPLATES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93 attribute15 OKL_AE_TEMPLATES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94 org_id NUMBER := OKC_API.G_MISS_NUM,
95 created_by NUMBER := OKC_API.G_MISS_NUM,
96 creation_date OKL_AE_TEMPLATES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
97 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
98 last_update_date OKL_AE_TEMPLATES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
99 last_update_login NUMBER := OKC_API.G_MISS_NUM,
100
101 -- Added by HKPATEL for securitization changes
102 inv_code OKL_AE_TEMPLATES.INV_CODE%TYPE := OKC_API.G_MISS_CHAR);
103
104 g_miss_avlv_rec avlv_rec_type;
105 TYPE avlv_tbl_type IS TABLE OF avlv_rec_type
106 INDEX BY BINARY_INTEGER;
107 ---------------------------------------------------------------------------
108 -- GLOBAL MESSAGE CONSTANTS
109 ---------------------------------------------------------------------------
110 -- Added 04/27/2001 Robin Edwin for validate attribute
111
112 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
113 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
114 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
115 G_UNQS CONSTANT VARCHAR2(200) := 'OKL_UNIQUE_KEY_VALIDATION_FAILED';
116
117 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
118 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
119 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
120 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
121 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
122 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
123 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
124 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
125 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
126 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
127 ---------------------------------------------------------------------------
128 -- GLOBAL VARIABLES
129 ---------------------------------------------------------------------------
130 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AVL_PVT';
131 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
132 ---------------------------------------------------------------------------
133 -- Procedures and Functions
134 ---------------------------------------------------------------------------
135
136 PROCEDURE qc;
137 PROCEDURE change_version;
138 PROCEDURE api_copy;
139 PROCEDURE insert_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_avlv_rec IN avlv_rec_type,
146 x_avlv_rec OUT NOCOPY avlv_rec_type);
147
148 PROCEDURE insert_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_avlv_tbl IN avlv_tbl_type,
155 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
156
157 PROCEDURE lock_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_avlv_rec IN avlv_rec_type);
164
165 PROCEDURE lock_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_avlv_tbl IN avlv_tbl_type);
172
173 PROCEDURE update_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_avlv_rec IN avlv_rec_type,
180 x_avlv_rec OUT NOCOPY avlv_rec_type);
181
182 PROCEDURE update_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_avlv_tbl IN avlv_tbl_type,
189 x_avlv_tbl OUT NOCOPY avlv_tbl_type);
190
191 PROCEDURE delete_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_avlv_rec IN avlv_rec_type);
198
199 PROCEDURE delete_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_avlv_tbl IN avlv_tbl_type);
206
207 PROCEDURE validate_row(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_avlv_rec IN avlv_rec_type);
214
215 PROCEDURE validate_row(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_avlv_tbl IN avlv_tbl_type);
222
223 END OKL_AVL_PVT;