[Home] [Help]
PACKAGE: APPS.OKL_ICP_PVT
Source
1 PACKAGE OKL_ICP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSICPS.pls 120.3 2005/07/07 22:12:51 smadhava noship $ */
3
4 -----------------------------------------------------------------------------
5 -- PACKAGE CONSTANTS
6 -----------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ICP_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
11 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
12 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
13 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(7) := 'SQLCODE';
15 G_SQLERRM_TOKEN CONSTANT VARCHAR2(7) := 'SQLERRM';
16 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
18 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
19 G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
20 G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
21 G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
22
23 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
24 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
25 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
26 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
27 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
28 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
29 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
30 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
31 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
32 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
33 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
34
35 ---------------------------------------------------------------------------
36 -- DATA STRUCTURES
37 ---------------------------------------------------------------------------
38 -- OKL_ITM_CAT_RV_PRCS_V Record Spec
39 TYPE icpv_rec_type IS RECORD (
40 id NUMBER
41 ,object_version_number NUMBER
42 ,cat_id1 NUMBER
43 ,cat_id2 OKL_ITM_CAT_RV_PRCS_V.CAT_ID2%TYPE
44 ,term_in_months NUMBER
45 ,residual_value_percent NUMBER
46 ,item_residual_id OKL_ITM_CAT_RV_PRCS_V.ITEM_RESIDUAL_ID%TYPE
47 ,sts_code OKL_ITM_CAT_RV_PRCS_V.STS_CODE%TYPE
48 ,version_number OKL_ITM_CAT_RV_PRCS_V.VERSION_NUMBER%TYPE
49 ,start_date OKL_ITM_CAT_RV_PRCS_V.START_DATE%TYPE
50 ,end_date OKL_ITM_CAT_RV_PRCS_V.END_DATE%TYPE
51 ,created_by NUMBER
52 ,creation_date OKL_ITM_CAT_RV_PRCS_V.CREATION_DATE%TYPE
53 ,last_updated_by NUMBER
54 ,last_update_date OKL_ITM_CAT_RV_PRCS_V.LAST_UPDATE_DATE%TYPE
55 ,last_update_login NUMBER
56 ,attribute_category OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE_CATEGORY%TYPE
57 ,attribute1 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE1%TYPE
58 ,attribute2 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE2%TYPE
59 ,attribute3 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE3%TYPE
60 ,attribute4 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE4%TYPE
61 ,attribute5 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE5%TYPE
62 ,attribute6 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE6%TYPE
63 ,attribute7 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE7%TYPE
64 ,attribute8 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE8%TYPE
65 ,attribute9 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE9%TYPE
66 ,attribute10 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE10%TYPE
67 ,attribute11 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE11%TYPE
68 ,attribute12 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE12%TYPE
69 ,attribute13 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE13%TYPE
70 ,attribute14 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE14%TYPE
71 ,attribute15 OKL_ITM_CAT_RV_PRCS_V.ATTRIBUTE15%TYPE);
72
73 TYPE icpv_tbl_type IS TABLE OF icpv_rec_type INDEX BY BINARY_INTEGER;
74
75 -- OKL_ITM_CAT_RV_PRCS Record Spec
76 TYPE icp_rec_type IS RECORD (
77 id NUMBER
78 ,object_version_number NUMBER
79 ,cat_id1 NUMBER
80 ,cat_id2 OKL_ITM_CAT_RV_PRCS.CAT_ID2%TYPE
81 ,term_in_months NUMBER
82 ,residual_value_percent NUMBER
83 ,start_date OKL_ITM_CAT_RV_PRCS.START_DATE%TYPE
84 ,end_date OKL_ITM_CAT_RV_PRCS.END_DATE%TYPE
85 ,created_by NUMBER
86 ,creation_date OKL_ITM_CAT_RV_PRCS.CREATION_DATE%TYPE
87 ,last_updated_by NUMBER
88 ,last_update_date OKL_ITM_CAT_RV_PRCS.LAST_UPDATE_DATE%TYPE
89 ,last_update_login NUMBER
90 ,attribute_category OKL_ITM_CAT_RV_PRCS.ATTRIBUTE_CATEGORY%TYPE
91 ,attribute1 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE1%TYPE
92 ,attribute2 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE2%TYPE
93 ,attribute3 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE3%TYPE
94 ,attribute4 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE4%TYPE
95 ,attribute5 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE5%TYPE
96 ,attribute6 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE6%TYPE
97 ,attribute7 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE7%TYPE
98 ,attribute8 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE8%TYPE
99 ,attribute9 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE9%TYPE
100 ,attribute10 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE10%TYPE
101 ,attribute11 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE11%TYPE
102 ,attribute12 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE12%TYPE
103 ,attribute13 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE13%TYPE
104 ,attribute14 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE14%TYPE
105 ,attribute15 OKL_ITM_CAT_RV_PRCS.ATTRIBUTE15%TYPE);
106
107 TYPE icp_tbl_type IS TABLE OF icp_rec_type INDEX BY BINARY_INTEGER;
108
109 ---------------------------------------------------------------------------
110 -- PROGRAM UNITS
111 ---------------------------------------------------------------------------
112 PROCEDURE insert_row(
113 p_api_version IN NUMBER,
114 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115 x_return_status OUT NOCOPY VARCHAR2,
116 x_msg_count OUT NOCOPY NUMBER,
117 x_msg_data OUT NOCOPY VARCHAR2,
118 p_icpv_rec IN icpv_rec_type,
119 x_icpv_rec OUT NOCOPY icpv_rec_type);
120
121 PROCEDURE insert_row(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_icpv_tbl IN icpv_tbl_type,
128 x_icpv_tbl OUT NOCOPY icpv_tbl_type);
129
130 PROCEDURE lock_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_icpv_rec IN icpv_rec_type);
137
138 PROCEDURE lock_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_icpv_tbl IN icpv_tbl_type);
145
146 PROCEDURE update_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_icpv_rec IN icpv_rec_type,
153 x_icpv_rec OUT NOCOPY icpv_rec_type);
154
155 PROCEDURE update_row(
156 p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161 p_icpv_tbl IN icpv_tbl_type,
162 x_icpv_tbl OUT NOCOPY icpv_tbl_type);
163
164 PROCEDURE delete_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_icpv_rec IN icpv_rec_type);
171
172 PROCEDURE delete_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_icpv_tbl IN icpv_tbl_type);
179
180 PROCEDURE validate_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_icpv_rec IN icpv_rec_type);
187
188 PROCEDURE validate_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_icpv_tbl IN icpv_tbl_type);
195
196 END OKL_ICP_PVT;