[Home] [Help]
PACKAGE: APPS.OKL_ACD_PVT
Source
1 Package OKL_ACD_PVT AS
2 /* $Header: OKLSACDS.pls 120.2 2006/07/11 10:07:36 dkagrawa noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE acd_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 date_report OKL_ASSET_CNDTNS.DATE_REPORT%TYPE := OKC_API.G_MISS_DATE,
9 cdn_code OKL_ASSET_CNDTNS.CDN_CODE%TYPE := OKC_API.G_MISS_CHAR,
10 clm_id NUMBER := OKC_API.G_MISS_NUM,
11 isp_id NUMBER := OKC_API.G_MISS_NUM,
12 iln_id NUMBER := OKC_API.G_MISS_NUM,
13 kle_id NUMBER := OKC_API.G_MISS_NUM,
14 object_version_number NUMBER := OKC_API.G_MISS_NUM,
15 org_id NUMBER := OKC_API.G_MISS_NUM,
16 request_id NUMBER := OKC_API.G_MISS_NUM,
17 program_application_id NUMBER := OKC_API.G_MISS_NUM,
18 program_id NUMBER := OKC_API.G_MISS_NUM,
19 program_update_date OKL_ASSET_CNDTNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20 attribute_category OKL_ASSET_CNDTNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21 attribute1 OKL_ASSET_CNDTNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22 attribute2 OKL_ASSET_CNDTNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23 attribute3 OKL_ASSET_CNDTNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24 attribute4 OKL_ASSET_CNDTNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25 attribute5 OKL_ASSET_CNDTNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26 attribute6 OKL_ASSET_CNDTNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27 attribute7 OKL_ASSET_CNDTNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28 attribute8 OKL_ASSET_CNDTNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29 attribute9 OKL_ASSET_CNDTNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30 attribute10 OKL_ASSET_CNDTNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31 attribute11 OKL_ASSET_CNDTNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32 attribute12 OKL_ASSET_CNDTNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33 attribute13 OKL_ASSET_CNDTNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34 attribute14 OKL_ASSET_CNDTNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35 attribute15 OKL_ASSET_CNDTNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
36 created_by NUMBER := OKC_API.G_MISS_NUM,
37 creation_date OKL_ASSET_CNDTNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
38 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
39 last_update_date OKL_ASSET_CNDTNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
40 last_update_login NUMBER := OKC_API.G_MISS_NUM);
41 g_miss_acd_rec acd_rec_type;
42 TYPE acd_tbl_type IS TABLE OF acd_rec_type
43 INDEX BY BINARY_INTEGER;
44 TYPE acdv_rec_type IS RECORD (
45 id NUMBER := OKC_API.G_MISS_NUM,
46 object_version_number NUMBER := OKC_API.G_MISS_NUM,
47 cdn_code OKL_ASSET_CNDTNS.CDN_CODE%TYPE := OKC_API.G_MISS_CHAR,
48 iln_id NUMBER := OKC_API.G_MISS_NUM,
49 isp_id NUMBER := OKC_API.G_MISS_NUM,
50 clm_id NUMBER := OKC_API.G_MISS_NUM,
51 kle_id NUMBER := OKC_API.G_MISS_NUM,
52 date_report OKL_ASSET_CNDTNS.DATE_REPORT%TYPE := OKC_API.G_MISS_DATE,
53 attribute_category OKL_ASSET_CNDTNS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
54 attribute1 OKL_ASSET_CNDTNS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
55 attribute2 OKL_ASSET_CNDTNS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
56 attribute3 OKL_ASSET_CNDTNS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
57 attribute4 OKL_ASSET_CNDTNS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
58 attribute5 OKL_ASSET_CNDTNS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
59 attribute6 OKL_ASSET_CNDTNS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
60 attribute7 OKL_ASSET_CNDTNS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
61 attribute8 OKL_ASSET_CNDTNS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
62 attribute9 OKL_ASSET_CNDTNS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
63 attribute10 OKL_ASSET_CNDTNS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
64 attribute11 OKL_ASSET_CNDTNS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
65 attribute12 OKL_ASSET_CNDTNS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
66 attribute13 OKL_ASSET_CNDTNS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
67 attribute14 OKL_ASSET_CNDTNS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
68 attribute15 OKL_ASSET_CNDTNS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
69 org_id NUMBER := OKC_API.G_MISS_NUM,
70 request_id NUMBER := OKC_API.G_MISS_NUM,
71 program_application_id NUMBER := OKC_API.G_MISS_NUM,
72 program_id NUMBER := OKC_API.G_MISS_NUM,
73 program_update_date OKL_ASSET_CNDTNS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74 created_by NUMBER := OKC_API.G_MISS_NUM,
75 creation_date OKL_ASSET_CNDTNS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
76 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
77 last_update_date OKL_ASSET_CNDTNS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
78 last_update_login NUMBER := OKC_API.G_MISS_NUM);
79 g_miss_acdv_rec acdv_rec_type;
80 TYPE acdv_tbl_type IS TABLE OF acdv_rec_type
81 INDEX BY BINARY_INTEGER;
82 ---------------------------------------------------------------------------
83 -- GLOBAL MESSAGE CONSTANTS
84 ---------------------------------------------------------------------------
85 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
86 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
87 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
88 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
89 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
90 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
91 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
92 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
93 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
94 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
95 ---------------------------------------------------------------------------
96 -- GLOBAL VARIABLES
97 ---------------------------------------------------------------------------
98 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACD_PVT';
99 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
100 ---------------------------------------------------------------------------
101 -- Procedures and Functions
102 ---------------------------------------------------------------------------
103
104 PROCEDURE qc;
105 PROCEDURE change_version;
106 PROCEDURE api_copy;
107 PROCEDURE insert_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_acdv_rec IN acdv_rec_type,
114 x_acdv_rec OUT NOCOPY acdv_rec_type);
115
116 PROCEDURE insert_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_acdv_tbl IN acdv_tbl_type,
123 x_acdv_tbl OUT NOCOPY acdv_tbl_type);
124
125 PROCEDURE lock_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_acdv_rec IN acdv_rec_type);
132
133 PROCEDURE lock_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_acdv_tbl IN acdv_tbl_type);
140
141 PROCEDURE update_row(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144 x_return_status OUT NOCOPY VARCHAR2,
145 x_msg_count OUT NOCOPY NUMBER,
146 x_msg_data OUT NOCOPY VARCHAR2,
147 p_acdv_rec IN acdv_rec_type,
148 x_acdv_rec OUT NOCOPY acdv_rec_type);
149
150 PROCEDURE update_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_acdv_tbl IN acdv_tbl_type,
157 x_acdv_tbl OUT NOCOPY acdv_tbl_type);
158
159 PROCEDURE delete_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_acdv_rec IN acdv_rec_type);
166
167 PROCEDURE delete_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_acdv_tbl IN acdv_tbl_type);
174
175 PROCEDURE validate_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_acdv_rec IN acdv_rec_type);
182
183 PROCEDURE validate_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_acdv_tbl IN acdv_tbl_type);
190
191 END OKL_ACD_PVT;