[Home] [Help]
PACKAGE: APPS.OKL_CAH_PVT
Source
1 PACKAGE Okl_Cah_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSCAHS.pls 120.2 2006/07/11 10:11:28 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 /* -- history tables not supported -- 04 APR 2002
7 TYPE okl_csh_allct_srchs_h_rec_type IS RECORD (
8 id NUMBER := Okl_Api.G_MISS_NUM,
9 major_version NUMBER := Okl_Api.G_MISS_NUM,
10 name OKL_CSH_ALLCT_SRCHS_H.NAME%TYPE := Okl_Api.G_MISS_CHAR,
11 sequence_number NUMBER := Okl_Api.G_MISS_NUM,
12 cash_search_type OKL_CSH_ALLCT_SRCHS_H.CASH_SEARCH_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
13 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
14 description OKL_CSH_ALLCT_SRCHS_H.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
15 attribute_category OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute1 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute2 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute3 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute4 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute5 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute6 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute7 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute8 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute9 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute10 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute11 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
27 attribute12 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
28 attribute13 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
29 attribute14 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
30 attribute15 OKL_CSH_ALLCT_SRCHS_H.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
31 created_by NUMBER := Okl_Api.G_MISS_NUM,
32 creation_date OKL_CSH_ALLCT_SRCHS_H.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
33 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
34 last_update_date OKL_CSH_ALLCT_SRCHS_H.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
35 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
36 GMissOklCshAllctSrchsHRec okl_csh_allct_srchs_h_rec_type;
37 TYPE okl_csh_allct_srchs_h_tbl_type IS TABLE OF okl_csh_allct_srchs_h_rec_type
38 INDEX BY BINARY_INTEGER;
39 */ -- history tables not supported -- 04 APR 2002
40
41 TYPE cah_rec_type IS RECORD (
42 id NUMBER := Okl_Api.G_MISS_NUM,
43 name OKL_CSH_ALLCT_SRCHS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
44 sequence_number NUMBER := Okl_Api.G_MISS_NUM,
45 cash_search_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
46 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
47 description OKL_CSH_ALLCT_SRCHS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
48 attribute_category OKL_CSH_ALLCT_SRCHS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
49 attribute1 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
50 attribute2 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
51 attribute3 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
52 attribute4 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
53 attribute5 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
54 attribute6 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
55 attribute7 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
56 attribute8 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
57 attribute9 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
58 attribute10 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
59 attribute11 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
60 attribute12 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
61 attribute13 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
62 attribute14 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
63 attribute15 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
64 org_id OKL_CSH_ALLCT_SRCHS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
65 created_by NUMBER := Okl_Api.G_MISS_NUM,
66 creation_date OKL_CSH_ALLCT_SRCHS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
67 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
68 last_update_date OKL_CSH_ALLCT_SRCHS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
69 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
70 g_miss_cah_rec cah_rec_type;
71 TYPE cah_tbl_type IS TABLE OF cah_rec_type
72 INDEX BY BINARY_INTEGER;
73 TYPE cahv_rec_type IS RECORD (
74 id NUMBER := Okl_Api.G_MISS_NUM,
75 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
76 name OKL_CSH_ALLCT_SRCHS.NAME%TYPE := Okl_Api.G_MISS_CHAR,
77 description OKL_CSH_ALLCT_SRCHS.DESCRIPTION%TYPE := Okl_Api.G_MISS_CHAR,
78 sequence_number NUMBER := Okl_Api.G_MISS_NUM,
79 attribute_category OKL_CSH_ALLCT_SRCHS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
80 attribute1 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
81 attribute2 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
82 attribute3 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
83 attribute4 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
84 attribute5 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
85 attribute6 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
86 attribute7 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
87 attribute8 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
88 attribute9 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
89 attribute10 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
90 attribute11 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
91 attribute12 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
92 attribute13 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
93 attribute14 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE14%TYPE := Okl_Api.G_MISS_CHAR,
94 attribute15 OKL_CSH_ALLCT_SRCHS.ATTRIBUTE15%TYPE := Okl_Api.G_MISS_CHAR,
95 org_id OKL_CSH_ALLCT_SRCHS.ORG_ID%TYPE := Okl_Api.G_MISS_NUM,
96 cash_search_type OKL_CSH_ALLCT_SRCHS.CASH_SEARCH_TYPE%TYPE := Okl_Api.G_MISS_CHAR,
97 created_by NUMBER := Okl_Api.G_MISS_NUM,
98 creation_date OKL_CSH_ALLCT_SRCHS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
99 last_updated_by NUMBER := Okl_Api.G_MISS_NUM,
100 last_update_date OKL_CSH_ALLCT_SRCHS.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
101 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
102 g_miss_cahv_rec cahv_rec_type;
103 TYPE cahv_tbl_type IS TABLE OF cahv_rec_type
104 INDEX BY BINARY_INTEGER;
105
106 ---------------------------------------------------------------------------
107 -- GLOBAL MESSAGE CONSTANTS
108 ---------------------------------------------------------------------------
109 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
110 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
111 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
112 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
113 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
114 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
115 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
116 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
117 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
118 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
119 ---------------------------------------------------------------------------
120 -- GLOBAL VARIABLES
121 ---------------------------------------------------------------------------
122 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CAH_PVT';
123 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
124 ---------------------------------------------------------------------------
125 -- ADDED AFTER TAPI 04/17/2001
126 ---------------------------------------------------------------------------
127 ---------------------------------------------------------------------------
128 -- GLOBAL MESSAGES
129 ---------------------------------------------------------------------------
130 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
131 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
132 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
133 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
134
135 ---------------------------------------------------------------------------
136 -- GLOBAL VARIABLES
137 ---------------------------------------------------------------------------
138 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_TRX_AR_INVOICES_V';
139 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
140
141 ---------------------------------------------------------------------------
142 -- Procedures and Functions
143 ---------------------------------------------------------------------------
144
145 PROCEDURE qc;
146 PROCEDURE change_version;
147 PROCEDURE api_copy;
148 PROCEDURE insert_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_cahv_rec IN cahv_rec_type,
155 x_cahv_rec OUT NOCOPY cahv_rec_type);
156
157 PROCEDURE insert_row(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_cahv_tbl IN cahv_tbl_type,
164 x_cahv_tbl OUT NOCOPY cahv_tbl_type);
165
166 PROCEDURE lock_row(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_cahv_rec IN cahv_rec_type);
173
174 PROCEDURE lock_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_cahv_tbl IN cahv_tbl_type);
181
182 PROCEDURE update_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_cahv_rec IN cahv_rec_type,
189 x_cahv_rec OUT NOCOPY cahv_rec_type);
190
191 PROCEDURE update_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_cahv_tbl IN cahv_tbl_type,
198 x_cahv_tbl OUT NOCOPY cahv_tbl_type);
199
200 PROCEDURE delete_row(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_cahv_rec IN cahv_rec_type);
207
208 PROCEDURE delete_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_cahv_tbl IN cahv_tbl_type);
215
216 PROCEDURE validate_row(
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
219 x_return_status OUT NOCOPY VARCHAR2,
220 x_msg_count OUT NOCOPY NUMBER,
221 x_msg_data OUT NOCOPY VARCHAR2,
222 p_cahv_rec IN cahv_rec_type);
223
224 PROCEDURE validate_row(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_cahv_tbl IN cahv_tbl_type);
231
232 END Okl_Cah_Pvt;