[Home] [Help]
PACKAGE: APPS.OKL_ACV_PVT
Source
1 PACKAGE Okl_Acv_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSACVS.pls 115.1 2002/02/05 12:14:05 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE acv_rec_type IS RECORD (
7 id NUMBER := Okl_Api.G_MISS_NUM,
8 awr_id NUMBER := Okl_Api.G_MISS_NUM,
9 asr_id NUMBER := Okl_Api.G_MISS_NUM,
10 asv_id NUMBER := Okl_Api.G_MISS_NUM,
11 object_version_number NUMBER := Okl_Api.G_MISS_NUM,
12 attribute_category OKL_ANSR_CRTRN_VALS.ATTRIBUTE_CATEGORY%TYPE := Okl_Api.G_MISS_CHAR,
13 attribute1 OKL_ANSR_CRTRN_VALS.ATTRIBUTE1%TYPE := Okl_Api.G_MISS_CHAR,
14 attribute2 OKL_ANSR_CRTRN_VALS.ATTRIBUTE2%TYPE := Okl_Api.G_MISS_CHAR,
15 attribute3 OKL_ANSR_CRTRN_VALS.ATTRIBUTE3%TYPE := Okl_Api.G_MISS_CHAR,
16 attribute4 OKL_ANSR_CRTRN_VALS.ATTRIBUTE4%TYPE := Okl_Api.G_MISS_CHAR,
17 attribute5 OKL_ANSR_CRTRN_VALS.ATTRIBUTE5%TYPE := Okl_Api.G_MISS_CHAR,
18 attribute6 OKL_ANSR_CRTRN_VALS.ATTRIBUTE6%TYPE := Okl_Api.G_MISS_CHAR,
19 attribute7 OKL_ANSR_CRTRN_VALS.ATTRIBUTE7%TYPE := Okl_Api.G_MISS_CHAR,
20 attribute8 OKL_ANSR_CRTRN_VALS.ATTRIBUTE8%TYPE := Okl_Api.G_MISS_CHAR,
21 attribute9 OKL_ANSR_CRTRN_VALS.ATTRIBUTE9%TYPE := Okl_Api.G_MISS_CHAR,
22 attribute10 OKL_ANSR_CRTRN_VALS.ATTRIBUTE10%TYPE := Okl_Api.G_MISS_CHAR,
23 attribute11 OKL_ANSR_CRTRN_VALS.ATTRIBUTE11%TYPE := Okl_Api.G_MISS_CHAR,
24 attribute12 OKL_ANSR_CRTRN_VALS.ATTRIBUTE12%TYPE := Okl_Api.G_MISS_CHAR,
25 attribute13 OKL_ANSR_CRTRN_VALS.ATTRIBUTE13%TYPE := Okl_Api.G_MISS_CHAR,
26 attribute14 OKL_ANSR_CRTRN_VALS.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
27 attribute15 OKL_ANSR_CRTRN_VALS.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
28 created_by NUMBER := okl_api.G_MISS_NUM,
29 creation_date OKL_ANSR_CRTRN_VALS.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
30 last_updated_by NUMBER := okl_api.G_MISS_NUM,
31 last_update_date OKL_ANSR_CRTRN_VALS.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
32 last_update_login NUMBER := okl_api.G_MISS_NUM);
33 g_miss_acv_rec acv_rec_type;
34 TYPE acv_tbl_type IS TABLE OF acv_rec_type
35 INDEX BY BINARY_INTEGER;
36 TYPE acvv_rec_type IS RECORD (
37 id NUMBER := okl_api.G_MISS_NUM,
38 object_version_number NUMBER := okl_api.G_MISS_NUM,
39 awr_id NUMBER := okl_api.G_MISS_NUM,
40 asv_id NUMBER := okl_api.G_MISS_NUM,
41 asr_id NUMBER := okl_api.G_MISS_NUM,
42 attribute_category OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE_CATEGORY%TYPE := okl_api.G_MISS_CHAR,
43 attribute1 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE1%TYPE := okl_api.G_MISS_CHAR,
44 attribute2 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE2%TYPE := okl_api.G_MISS_CHAR,
45 attribute3 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE3%TYPE := okl_api.G_MISS_CHAR,
46 attribute4 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE4%TYPE := okl_api.G_MISS_CHAR,
47 attribute5 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE5%TYPE := okl_api.G_MISS_CHAR,
48 attribute6 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE6%TYPE := okl_api.G_MISS_CHAR,
49 attribute7 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE7%TYPE := okl_api.G_MISS_CHAR,
50 attribute8 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE8%TYPE := okl_api.G_MISS_CHAR,
51 attribute9 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE9%TYPE := okl_api.G_MISS_CHAR,
52 attribute10 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE10%TYPE := okl_api.G_MISS_CHAR,
53 attribute11 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE11%TYPE := okl_api.G_MISS_CHAR,
54 attribute12 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE12%TYPE := okl_api.G_MISS_CHAR,
55 attribute13 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE13%TYPE := okl_api.G_MISS_CHAR,
56 attribute14 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE14%TYPE := okl_api.G_MISS_CHAR,
57 attribute15 OKL_ANSR_CRTRN_VALS_V.ATTRIBUTE15%TYPE := okl_api.G_MISS_CHAR,
58 created_by NUMBER := okl_api.G_MISS_NUM,
59 creation_date OKL_ANSR_CRTRN_VALS_V.CREATION_DATE%TYPE := okl_api.G_MISS_DATE,
60 last_updated_by NUMBER := okl_api.G_MISS_NUM,
61 last_update_date OKL_ANSR_CRTRN_VALS_V.LAST_UPDATE_DATE%TYPE := okl_api.G_MISS_DATE,
62 last_update_login NUMBER := okl_api.G_MISS_NUM);
63 g_miss_acvv_rec acvv_rec_type;
64 TYPE acvv_tbl_type IS TABLE OF acvv_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_ACV_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_ANSR_CRTRN_VALS_V';
96 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
97
98 ---------------------------------------------------------------------------
99 -- validation Procedures and Functions
100 ---------------------------------------------------------------------------
101 --PROCEDURE validate_unique(p_saiv_rec IN saiv_rec_type,
102 -- x_return_status OUT NOCOPY VARCHAR2);
103
104 /****************END ADDITION AFTER TAPI, (05/23/2001)**************/
105
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 okl_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_acvv_rec IN acvv_rec_type,
120 x_acvv_rec OUT NOCOPY acvv_rec_type);
121
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_tbl IN acvv_tbl_type,
129 x_acvv_tbl OUT NOCOPY acvv_tbl_type);
130
131 PROCEDURE lock_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_rec IN acvv_rec_type);
138
139 PROCEDURE lock_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_tbl IN acvv_tbl_type);
146
147 PROCEDURE update_row(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_rec IN acvv_rec_type,
154 x_acvv_rec OUT NOCOPY acvv_rec_type);
155
156 PROCEDURE update_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_tbl IN acvv_tbl_type,
163 x_acvv_tbl OUT NOCOPY acvv_tbl_type);
164
165 PROCEDURE delete_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_rec IN acvv_rec_type);
172
173 PROCEDURE delete_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_tbl IN acvv_tbl_type);
180
181 PROCEDURE validate_row(
182 p_api_version IN NUMBER,
183 p_init_msg_list IN VARCHAR2 DEFAULT okl_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_acvv_rec IN acvv_rec_type);
188
189 PROCEDURE validate_row(
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 DEFAULT Okl_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_acvv_tbl IN acvv_tbl_type);
196
197 END Okl_Acv_Pvt;