[Home] [Help]
PACKAGE: APPS.OKL_AJL_PVT
Source
1 Package OKL_AJL_PVT AS
2 /* $Header: OKLSAJLS.pls 120.2 2007/08/10 12:00:01 dpsingh ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ajl_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 adj_id NUMBER := OKC_API.G_MISS_NUM,
9 til_id NUMBER := OKC_API.G_MISS_NUM,
10 tld_id NUMBER := OKC_API.G_MISS_NUM,
11 psl_id NUMBER := OKC_API.G_MISS_NUM,
12 code_combination_id NUMBER := OKC_API.G_MISS_NUM,
13 object_version_number OKL_TXL_ADJSTS_LNS_B.OBJECT_VERSION_NUMBER%TYPE,
14 amount NUMBER := OKC_API.G_MISS_NUM,
15 check_approval_limit_yn OKL_TXL_ADJSTS_LNS_B.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
16 receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
17 request_id NUMBER := OKC_API.G_MISS_NUM,
18 program_application_id NUMBER := OKC_API.G_MISS_NUM,
19 program_id NUMBER := OKC_API.G_MISS_NUM,
20 program_update_date OKL_TXL_ADJSTS_LNS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21 org_id NUMBER := OKC_API.G_MISS_NUM,
22 attribute_category OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE_CATEGORY%TYPE,
23 attribute1 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE1%TYPE,
24 attribute2 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE2%TYPE,
25 attribute3 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE3%TYPE,
26 attribute4 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE4%TYPE,
27 attribute5 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE5%TYPE,
28 attribute6 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE6%TYPE,
29 attribute7 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE7%TYPE,
30 attribute8 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE8%TYPE,
31 attribute9 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE9%TYPE,
32 attribute10 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE10%TYPE,
33 attribute11 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE11%TYPE,
34 attribute12 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE12%TYPE,
35 attribute13 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE13%TYPE,
36 attribute14 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE14%TYPE,
37 attribute15 OKL_TXL_ADJSTS_LNS_B.ATTRIBUTE15%TYPE,
38 created_by OKL_TXL_ADJSTS_LNS_B.CREATED_BY%TYPE,
39 creation_date OKL_TXL_ADJSTS_LNS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40 last_updated_by OKL_TXL_ADJSTS_LNS_B.LAST_UPDATED_BY%TYPE,
41 last_update_date OKL_TXL_ADJSTS_LNS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
42 last_update_login OKL_TXL_ADJSTS_LNS_B.LAST_UPDATE_LOGIN%TYPE,
43 --Bug 6316320 dpsingh start
44 khr_id NUMBER := OKL_API.G_MISS_NUM,
45 sty_id NUMBER := OKL_API.G_MISS_NUM,
46 kle_id NUMBER := OKL_API.G_MISS_NUM
47 --Bug 6316320 dpsingh end
48 );
49 g_miss_ajl_rec ajl_rec_type;
50 TYPE ajl_tbl_type IS TABLE OF ajl_rec_type
51 INDEX BY BINARY_INTEGER;
52 TYPE okl_txl_adjsts_lns_tl_rec_type IS RECORD (
53 id NUMBER := OKC_API.G_MISS_NUM,
54 language OKL_TXL_ADJSTS_LNS_TL.LANGUAGE%TYPE,
55 source_lang OKL_TXL_ADJSTS_LNS_TL.SOURCE_LANG%TYPE,
56 sfwt_flag OKL_TXL_ADJSTS_LNS_TL.SFWT_FLAG%TYPE,
57 created_by OKL_TXL_ADJSTS_LNS_TL.CREATED_BY%TYPE,
58 creation_date OKL_TXL_ADJSTS_LNS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59 last_updated_by OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATED_BY%TYPE,
60 last_update_date OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61 last_update_login OKL_TXL_ADJSTS_LNS_TL.LAST_UPDATE_LOGIN%TYPE);
62 GMissOklTxlAdjstsLnsTlRec okl_txl_adjsts_lns_tl_rec_type;
63 TYPE okl_txl_adjsts_lns_tl_tbl_type IS TABLE OF okl_txl_adjsts_lns_tl_rec_type
64 INDEX BY BINARY_INTEGER;
65 TYPE ajlv_rec_type IS RECORD (
66 id NUMBER := OKC_API.G_MISS_NUM,
67 object_version_number OKL_TXL_ADJSTS_LNS_V.OBJECT_VERSION_NUMBER%TYPE,
68 sfwt_flag OKL_TXL_ADJSTS_LNS_V.SFWT_FLAG%TYPE,
69 adj_id NUMBER := OKC_API.G_MISS_NUM,
70 til_id NUMBER := OKC_API.G_MISS_NUM,
71 tld_id NUMBER := OKC_API.G_MISS_NUM,
72 code_combination_id NUMBER := OKC_API.G_MISS_NUM,
73 psl_id NUMBER := OKC_API.G_MISS_NUM,
74 amount NUMBER := OKC_API.G_MISS_NUM,
75 check_approval_limit_yn OKL_TXL_ADJSTS_LNS_V.CHECK_APPROVAL_LIMIT_YN%TYPE := OKC_API.G_MISS_CHAR,
76 receivables_adjustment_id NUMBER := OKC_API.G_MISS_NUM,
77 attribute_category OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE_CATEGORY%TYPE,
78 attribute1 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE1%TYPE,
79 attribute2 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE2%TYPE,
80 attribute3 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE3%TYPE,
81 attribute4 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE4%TYPE,
82 attribute5 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE5%TYPE,
83 attribute6 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE6%TYPE,
84 attribute7 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE7%TYPE,
85 attribute8 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE8%TYPE,
86 attribute9 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE9%TYPE,
87 attribute10 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE10%TYPE,
88 attribute11 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE11%TYPE,
89 attribute12 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE12%TYPE,
90 attribute13 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE13%TYPE,
91 attribute14 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE14%TYPE,
92 attribute15 OKL_TXL_ADJSTS_LNS_V.ATTRIBUTE15%TYPE,
93 request_id NUMBER := OKC_API.G_MISS_NUM,
94 program_application_id NUMBER := OKC_API.G_MISS_NUM,
95 program_id NUMBER := OKC_API.G_MISS_NUM,
96 program_update_date OKL_TXL_ADJSTS_LNS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
97 org_id NUMBER := OKC_API.G_MISS_NUM,
98 created_by OKL_TXL_ADJSTS_LNS_V.CREATED_BY%TYPE,
99 creation_date OKL_TXL_ADJSTS_LNS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
100 last_updated_by OKL_TXL_ADJSTS_LNS_V.LAST_UPDATED_BY%TYPE,
101 last_update_date OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
102 last_update_login OKL_TXL_ADJSTS_LNS_V.LAST_UPDATE_LOGIN%TYPE,
103 --Bug 6316320 dpsingh start
104 khr_id NUMBER := OKL_API.G_MISS_NUM,
105 sty_id NUMBER := OKL_API.G_MISS_NUM,
106 kle_id NUMBER := OKL_API.G_MISS_NUM
107 --Bug 6316320 dpsingh end
108 );
109 g_miss_ajlv_rec ajlv_rec_type;
110 TYPE ajlv_tbl_type IS TABLE OF ajlv_rec_type
111 INDEX BY BINARY_INTEGER;
112 ---------------------------------------------------------------------------
113 -- GLOBAL MESSAGE CONSTANTS
114 ---------------------------------------------------------------------------
115 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
116 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
117 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
118 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
119 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
120 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
121 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
122 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
123 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
124 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
125 ---------------------------------------------------------------------------
126 -- GLOBAL VARIABLES
127 ---------------------------------------------------------------------------
128 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AJL_PVT';
129 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
130 ---------------------------------------------------------------------------
131 -- Procedures and Functions
132 ---------------------------------------------------------------------------
133
134 PROCEDURE qc;
135 PROCEDURE change_version;
136 PROCEDURE api_copy;
137 PROCEDURE add_language;
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_ajlv_rec IN ajlv_rec_type,
145 x_ajlv_rec OUT NOCOPY ajlv_rec_type);
146
147 PROCEDURE insert_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_ajlv_tbl IN ajlv_tbl_type,
154 x_ajlv_tbl OUT NOCOPY ajlv_tbl_type);
155
156 PROCEDURE lock_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ajlv_rec IN ajlv_rec_type);
163
164 PROCEDURE lock_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_ajlv_tbl IN ajlv_tbl_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_ajlv_rec IN ajlv_rec_type,
179 x_ajlv_rec OUT NOCOPY ajlv_rec_type);
180
181 PROCEDURE update_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_ajlv_tbl IN ajlv_tbl_type,
188 x_ajlv_tbl OUT NOCOPY ajlv_tbl_type);
189
190 PROCEDURE delete_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ajlv_rec IN ajlv_rec_type);
197
198 PROCEDURE delete_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_ajlv_tbl IN ajlv_tbl_type);
205
206 PROCEDURE validate_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_ajlv_rec IN ajlv_rec_type);
213
214 PROCEDURE validate_row(
215 p_api_version IN NUMBER,
216 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_msg_count OUT NOCOPY NUMBER,
219 x_msg_data OUT NOCOPY VARCHAR2,
220 p_ajlv_tbl IN ajlv_tbl_type);
221
222 END OKL_AJL_PVT;