[Home] [Help]
PACKAGE: APPS.OKL_AWR_PVT
Source
1 PACKAGE Okl_Awr_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSAWRS.pls 115.1 2002/02/05 12:15:02 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE awr_rec_type IS RECORD (
7 id NUMBER := okl_api.G_MISS_NUM,
8 ant_id NUMBER := okl_api.G_MISS_NUM,
9 rul_id NUMBER := okl_api.G_MISS_NUM,
10 sort_sequence NUMBER := okl_api.G_MISS_NUM,
11 object_version_number NUMBER := okl_api.G_MISS_NUM,
12 attribute_category OKL_ANSWERS.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
13 attribute1 OKL_ANSWERS.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
14 attribute2 OKL_ANSWERS.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
15 attribute3 OKL_ANSWERS.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
16 attribute4 OKL_ANSWERS.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
17 attribute5 OKL_ANSWERS.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
18 attribute6 OKL_ANSWERS.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
19 attribute7 OKL_ANSWERS.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
20 attribute8 OKL_ANSWERS.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
21 attribute9 OKL_ANSWERS.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
22 attribute10 OKL_ANSWERS.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
23 attribute11 OKL_ANSWERS.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
24 attribute12 OKL_ANSWERS.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
25 attribute13 OKL_ANSWERS.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
26 attribute14 OKL_ANSWERS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27 attribute15 OKL_ANSWERS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28 created_by NUMBER := Okl_Api.G_MISS_NUM,
29 creation_date OKL_ANSWERS.CREATION_DATE%TYPE := Okl_Api.G_MISS_DATE,
30 last_updated_by NUMBER := okl_api.G_MISS_NUM,
31 last_update_date OKL_ANSWERS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32 last_update_login NUMBER := okl_api.G_MISS_NUM);
33 g_miss_awr_rec awr_rec_type;
34 TYPE awr_tbl_type IS TABLE OF awr_rec_type
35 INDEX BY BINARY_INTEGER;
36 TYPE awrv_rec_type IS RECORD (
37 id NUMBER := okl_api.G_MISS_NUM,
38 object_version_number NUMBER := okl_api.G_MISS_NUM,
39 ant_id NUMBER := okl_api.G_MISS_NUM,
40 rul_id NUMBER := okl_api.G_MISS_NUM,
41 sort_sequence NUMBER := okl_api.G_MISS_NUM,
42 attribute_category OKL_ANSWERS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43 attribute1 OKL_ANSWERS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44 attribute2 OKL_ANSWERS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45 attribute3 OKL_ANSWERS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46 attribute4 OKL_ANSWERS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47 attribute5 OKL_ANSWERS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48 attribute6 OKL_ANSWERS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49 attribute7 OKL_ANSWERS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50 attribute8 OKL_ANSWERS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51 attribute9 OKL_ANSWERS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52 attribute10 OKL_ANSWERS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53 attribute11 OKL_ANSWERS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54 attribute12 OKL_ANSWERS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55 attribute13 OKL_ANSWERS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56 attribute14 OKL_ANSWERS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57 attribute15 OKL_ANSWERS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58 created_by NUMBER := okl_api.G_MISS_NUM,
59 creation_date OKL_ANSWERS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60 last_updated_by NUMBER := okl_api.G_MISS_NUM,
61 last_update_date OKL_ANSWERS_V.LAST_UPDATE_DATE%TYPE := Okl_Api.G_MISS_DATE,
62 last_update_login NUMBER := Okl_Api.G_MISS_NUM);
63 g_miss_awrv_rec awrv_rec_type;
64 TYPE awrv_tbl_type IS TABLE OF awrv_rec_type
65 INDEX BY BINARY_INTEGER;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 G_FND_APP CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
70 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := okl_api.G_FORM_UNABLE_TO_RESERVE_REC;
71 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_DELETED;
72 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := okl_api.G_FORM_RECORD_CHANGED;
73 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := okl_api.G_RECORD_LOGICALLY_DELETED;
74 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := okl_api.G_REQUIRED_VALUE;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
76 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_COL_NAME_TOKEN;
77 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_PARENT_TABLE_TOKEN;
78 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := okl_api.G_CHILD_TABLE_TOKEN;
79 ---------------------------------------------------------------------------
80 -- GLOBAL VARIABLES
81 ---------------------------------------------------------------------------
82 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AWR_PVT';
83 G_APP_NAME CONSTANT VARCHAR2(3) := okl_api.G_APP_NAME;
84
85 /******************ADDED AFTER TAPI, (05/23/2001) ****************/
86 --GLOBAL MESSAGES
87 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
88 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
89 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
90 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
91 G_NOT_SAME CONSTANT VARCHAR2(200) := 'OKL_CANNOT_BE_SAME';
92
93
94 --GLOBAL VARIABLES
95 G_VIEW CONSTANT VARCHAR2(30) := 'OKL_ANSWERS_V';
96 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
97
98 /****************END ADDITION AFTER TAPI, (05/23/2001)**************/
99
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 okl_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_awrv_rec IN awrv_rec_type,
114 x_awrv_rec OUT NOCOPY awrv_rec_type);
115
116 PROCEDURE insert_row(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_tbl IN awrv_tbl_type,
123 x_awrv_tbl OUT NOCOPY awrv_tbl_type);
124
125 PROCEDURE lock_row(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_rec IN awrv_rec_type);
132
133 PROCEDURE lock_row(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_tbl IN awrv_tbl_type);
140
141 PROCEDURE update_row(
142 p_api_version IN NUMBER,
143 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_rec IN awrv_rec_type,
148 x_awrv_rec OUT NOCOPY awrv_rec_type);
149
150 PROCEDURE update_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_tbl IN awrv_tbl_type,
157 x_awrv_tbl OUT NOCOPY awrv_tbl_type);
158
159 PROCEDURE delete_row(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_rec IN awrv_rec_type);
166
167 PROCEDURE delete_row(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_tbl IN awrv_tbl_type);
174
175 PROCEDURE validate_row(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_awrv_rec IN awrv_rec_type);
182
183 PROCEDURE validate_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_awrv_tbl IN awrv_tbl_type);
190
191 END Okl_Awr_Pvt;