[Home] [Help]
PACKAGE: APPS.OKL_ADJ_PVT
Source
1 Package okl_adj_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSADJS.pls 120.3 2007/11/12 09:01:15 dcshanmu ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE adj_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 ccw_id NUMBER := OKC_API.G_MISS_NUM,
9 tcn_id NUMBER := OKC_API.G_MISS_NUM,
10 adjustment_reason_code OKL_TRX_AR_ADJSTS_B.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 apply_date OKL_TRX_AR_ADJSTS_B.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
12 object_version_number OKL_TRX_AR_ADJSTS_B.OBJECT_VERSION_NUMBER%TYPE,
13 gl_date OKL_TRX_AR_ADJSTS_B.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
14 request_id NUMBER := OKC_API.G_MISS_NUM,
15 program_application_id NUMBER := OKC_API.G_MISS_NUM,
16 program_id NUMBER := OKC_API.G_MISS_NUM,
17 program_update_date OKL_TRX_AR_ADJSTS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18 org_id NUMBER := OKC_API.G_MISS_NUM,
19 attribute_category OKL_TRX_AR_ADJSTS_B.ATTRIBUTE_CATEGORY%TYPE,
20 attribute1 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE1%TYPE,
21 attribute2 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE2%TYPE,
22 attribute3 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE3%TYPE,
23 attribute4 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE4%TYPE,
24 attribute5 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE5%TYPE,
25 attribute6 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE6%TYPE,
26 attribute7 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE7%TYPE,
27 attribute8 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE8%TYPE,
28 attribute9 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE9%TYPE,
29 attribute10 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE10%TYPE,
30 attribute11 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE11%TYPE,
31 attribute12 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE12%TYPE,
32 attribute13 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE13%TYPE,
33 attribute14 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE14%TYPE,
34 attribute15 OKL_TRX_AR_ADJSTS_B.ATTRIBUTE15%TYPE,
35 created_by OKL_TRX_AR_ADJSTS_B.CREATED_BY%TYPE,
36 creation_date OKL_TRX_AR_ADJSTS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37 last_updated_by OKL_TRX_AR_ADJSTS_B.LAST_UPDATED_BY%TYPE,
38 last_update_date OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39 last_update_login OKL_TRX_AR_ADJSTS_B.LAST_UPDATE_LOGIN%TYPE,
40 trx_status_code OKL_TRX_AR_ADJSTS_B.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
41 --Bug 6316320 dpsingh start
42 try_id NUMBER := OKL_API.G_MISS_NUM,
43 --Bug 6316320 dpsingh end
44 --gkhuntet start 02-Nov-07
45 TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
46 --gkhuntet end 02-Nov-07
47 );
48 g_miss_adj_rec adj_rec_type;
49 TYPE adj_tbl_type IS TABLE OF adj_rec_type
50 INDEX BY BINARY_INTEGER;
51 TYPE okl_trx_ar_adjsts_tl_rec_type IS RECORD (
52 id NUMBER := OKC_API.G_MISS_NUM,
53 language OKL_TRX_AR_ADJSTS_TL.LANGUAGE%TYPE,
54 source_lang OKL_TRX_AR_ADJSTS_TL.SOURCE_LANG%TYPE,
55 sfwt_flag OKL_TRX_AR_ADJSTS_TL.SFWT_FLAG%TYPE,
56 comments OKL_TRX_AR_ADJSTS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
57 created_by OKL_TRX_AR_ADJSTS_TL.CREATED_BY%TYPE,
58 creation_date OKL_TRX_AR_ADJSTS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
59 last_updated_by OKL_TRX_AR_ADJSTS_TL.LAST_UPDATED_BY%TYPE,
60 last_update_date OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
61 last_update_login OKL_TRX_AR_ADJSTS_TL.LAST_UPDATE_LOGIN%TYPE);
62 GMissOklTrxArAdjstsTlRec okl_trx_ar_adjsts_tl_rec_type;
63 TYPE okl_trx_ar_adjsts_tl_tbl_type IS TABLE OF okl_trx_ar_adjsts_tl_rec_type
64 INDEX BY BINARY_INTEGER;
65 TYPE adjv_rec_type IS RECORD (
66 id NUMBER := OKC_API.G_MISS_NUM,
67 object_version_number OKL_TRX_AR_ADJSTS_V.OBJECT_VERSION_NUMBER%TYPE,
68 sfwt_flag OKL_TRX_AR_ADJSTS_V.SFWT_FLAG%TYPE,
69 trx_status_code OKL_TRX_AR_ADJSTS_V.TRX_STATUS_CODE%TYPE := OKC_API.G_MISS_CHAR,
70 ccw_id NUMBER := OKC_API.G_MISS_NUM,
71 tcn_id NUMBER := OKC_API.G_MISS_NUM,
72 adjustment_reason_code OKL_TRX_AR_ADJSTS_V.ADJUSTMENT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR,
73 apply_date OKL_TRX_AR_ADJSTS_V.APPLY_DATE%TYPE := OKC_API.G_MISS_DATE,
74 gl_date OKL_TRX_AR_ADJSTS_V.GL_DATE%TYPE := OKC_API.G_MISS_DATE,
75 comments OKL_TRX_AR_ADJSTS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
76 attribute_category OKL_TRX_AR_ADJSTS_V.ATTRIBUTE_CATEGORY%TYPE,
77 attribute1 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE1%TYPE,
78 attribute2 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE2%TYPE,
79 attribute3 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE3%TYPE,
80 attribute4 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE4%TYPE,
81 attribute5 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE5%TYPE,
82 attribute6 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE6%TYPE,
83 attribute7 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE7%TYPE,
84 attribute8 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE8%TYPE,
85 attribute9 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE9%TYPE,
86 attribute10 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE10%TYPE,
87 attribute11 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE11%TYPE,
88 attribute12 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE12%TYPE,
89 attribute13 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE13%TYPE,
90 attribute14 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE14%TYPE,
91 attribute15 OKL_TRX_AR_ADJSTS_V.ATTRIBUTE15%TYPE,
92 request_id NUMBER := OKC_API.G_MISS_NUM,
93 program_application_id NUMBER := OKC_API.G_MISS_NUM,
94 program_id NUMBER := OKC_API.G_MISS_NUM,
95 program_update_date OKL_TRX_AR_ADJSTS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
96 org_id NUMBER := OKC_API.G_MISS_NUM,
97 created_by OKL_TRX_AR_ADJSTS_V.CREATED_BY%TYPE,
98 creation_date OKL_TRX_AR_ADJSTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
99 last_updated_by OKL_TRX_AR_ADJSTS_V.LAST_UPDATED_BY%TYPE,
100 last_update_date OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
101 last_update_login OKL_TRX_AR_ADJSTS_V.LAST_UPDATE_LOGIN%TYPE,
102 --Bug 6316320 dpsingh start
103 try_id NUMBER := OKL_API.G_MISS_NUM,
104 --Bug 6316320 dpsingh end
105 --gkhuntet start 02-Nov-07
106 TRANSACTION_DATE OKL_TRX_AR_INVOICES_B.TRANSACTION_DATE%TYPE := Okl_Api.G_MISS_DATE
107 --gkhuntet end 02-Nov-07
108 );
109 g_miss_adjv_rec adjv_rec_type;
110 TYPE adjv_tbl_type IS TABLE OF adjv_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_ADJ_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_adjv_rec IN adjv_rec_type,
145 x_adjv_rec OUT NOCOPY adjv_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_adjv_tbl IN adjv_tbl_type,
154 x_adjv_tbl OUT NOCOPY adjv_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_adjv_rec IN adjv_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_adjv_tbl IN adjv_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_adjv_rec IN adjv_rec_type,
179 x_adjv_rec OUT NOCOPY adjv_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_adjv_tbl IN adjv_tbl_type,
188 x_adjv_tbl OUT NOCOPY adjv_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_adjv_rec IN adjv_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_adjv_tbl IN adjv_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_adjv_rec IN adjv_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_adjv_tbl IN adjv_tbl_type);
221
222 END OKL_ADJ_PVT;