[Home] [Help]
PACKAGE: APPS.OKS_AVLEXC_PVT
Source
1 Package OKS_AVLEXC_PVT AS
2 /* $Header: OKSSEXCS.pls 120.0 2005/05/25 18:37:54 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE sax_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 sav_id NUMBER := OKC_API.G_MISS_NUM,
9 object1_id1 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
10 object1_id2 OKS_SERV_AVAIL_EXCEPTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
11 jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
12 object_version_number NUMBER := OKC_API.G_MISS_NUM,
13 created_by NUMBER := OKC_API.G_MISS_NUM,
14 creation_date OKS_SERV_AVAIL_EXCEPTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16 last_update_date OKS_SERV_AVAIL_EXCEPTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
18 revision_low OKS_SERV_AVAIL_EXCEPTS.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
19 revision_high OKS_SERV_AVAIL_EXCEPTS.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
20 start_date_active OKS_SERV_AVAIL_EXCEPTS.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
21 end_date_active OKS_SERV_AVAIL_EXCEPTS.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
22 last_update_login NUMBER := OKC_API.G_MISS_NUM,
23 attribute_category OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24 attribute1 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25 attribute2 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26 attribute3 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27 attribute4 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28 attribute5 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29 attribute6 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30 attribute7 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31 attribute8 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32 attribute9 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33 attribute10 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34 attribute11 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35 attribute12 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36 attribute13 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37 attribute14 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38 attribute15 OKS_SERV_AVAIL_EXCEPTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
39 g_miss_sax_rec sax_rec_type;
40 TYPE sax_tbl_type IS TABLE OF sax_rec_type
41 INDEX BY BINARY_INTEGER;
42 TYPE saxv_rec_type IS RECORD (
43 id NUMBER := OKC_API.G_MISS_NUM,
44 sav_id NUMBER := OKC_API.G_MISS_NUM,
45 object1_id1 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
46 object1_id2 OKS_SERV_AVAIL_EXCEPTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
47 jtot_object1_code OKS_SERV_AVAIL_EXCEPTS_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
48 object_version_number NUMBER := OKC_API.G_MISS_NUM,
49 manufacturing_org_id NUMBER := OKC_API.G_MISS_NUM,
50 revision_low OKS_SERV_AVAIL_EXCEPTS_V.REVISION_LOW%TYPE := OKC_API.G_MISS_CHAR,
51 revision_high OKS_SERV_AVAIL_EXCEPTS_V.REVISION_HIGH%TYPE := OKC_API.G_MISS_CHAR,
52 start_date_active OKS_SERV_AVAIL_EXCEPTS_V.START_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
53 end_date_active OKS_SERV_AVAIL_EXCEPTS_V.END_DATE_ACTIVE%TYPE := OKC_API.G_MISS_DATE,
54 attribute_category OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55 attribute1 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
56 attribute2 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57 attribute3 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58 attribute4 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59 attribute5 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60 attribute6 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61 attribute7 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62 attribute8 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63 attribute9 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64 attribute10 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65 attribute11 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66 attribute12 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67 attribute13 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68 attribute14 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69 attribute15 OKS_SERV_AVAIL_EXCEPTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70 created_by NUMBER := OKC_API.G_MISS_NUM,
71 creation_date OKS_SERV_AVAIL_EXCEPTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
72 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
73 last_update_date OKS_SERV_AVAIL_EXCEPTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74 last_update_login NUMBER := OKC_API.G_MISS_NUM);
75 g_miss_saxv_rec saxv_rec_type;
76 TYPE saxv_tbl_type IS TABLE OF saxv_rec_type
77 INDEX BY BINARY_INTEGER;
78 ---------------------------------------------------------------------------
79 -- GLOBAL MESSAGE CONSTANTS
80 ---------------------------------------------------------------------------
81 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
83 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
84 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
85 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
86 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
87 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
88 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
89 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
90 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
91 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
92 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
93 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
94
95 ---------------------------------------------------------------------------
96 -- GLOBAL EXCEPTIONS
97 ---------------------------------------------------------------------------
98 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
99
100
101 ---------------------------------------------------------------------------
102 -- GLOBAL VARIABLES
103 ---------------------------------------------------------------------------
104 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_AVLEXC_PVT';
105 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
106 ---------------------------------------------------------------------------
107 -- Procedures and Functions
108 ---------------------------------------------------------------------------
109
110 PROCEDURE qc;
111 PROCEDURE change_version;
112 PROCEDURE api_copy;
113 PROCEDURE insert_row(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_saxv_rec IN saxv_rec_type,
120 x_saxv_rec OUT NOCOPY saxv_rec_type);
121
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_saxv_tbl IN saxv_tbl_type,
129 x_saxv_tbl OUT NOCOPY saxv_tbl_type);
130
131 PROCEDURE lock_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_saxv_rec IN saxv_rec_type);
138
139 PROCEDURE lock_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_saxv_tbl IN saxv_tbl_type);
146
147 PROCEDURE update_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_saxv_rec IN saxv_rec_type,
154 x_saxv_rec OUT NOCOPY saxv_rec_type);
155
156 PROCEDURE update_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_saxv_tbl IN saxv_tbl_type,
163 x_saxv_tbl OUT NOCOPY saxv_tbl_type);
164
165 PROCEDURE delete_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_saxv_rec IN saxv_rec_type);
172
173 PROCEDURE delete_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_saxv_tbl IN saxv_tbl_type);
180
181 PROCEDURE validate_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_saxv_rec IN saxv_rec_type);
188
189 PROCEDURE validate_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192 x_return_status OUT NOCOPY VARCHAR2,
193 x_msg_count OUT NOCOPY NUMBER,
194 x_msg_data OUT NOCOPY VARCHAR2,
195 p_saxv_tbl IN saxv_tbl_type);
196 PROCEDURE INSERT_ROW_UPG(p_saxv_tbl saxv_tbl_type );
197
198
199 END OKS_AVLEXC_PVT;