[Home] [Help]
PACKAGE: APPS.OKL_SUBSIDY_PVT
Source
1 PACKAGE OKL_SUBSIDY_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCSUBS.pls 115.0 2003/09/19 22:43:50 avsingh noship $ */
3
4 -- simple entity object subtype definitions
5 subtype subv_rec_type is OKL_SUB_PVT.subv_rec_type;
6 subtype subv_tbl_type is OKL_SUB_PVT.subv_tbl_type;
7 subtype sucv_rec_type is OKL_SUC_PVT.sucv_rec_type;
8 subtype sucv_tbl_type is OKL_SUC_PVT.sucv_tbl_type;
9
10 ---------------------------------------------------------------------------
11 -- GLOBAL MESSAGE CONSTANTS
12 ---------------------------------------------------------------------------
13 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
14 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
15 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
16 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
17 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
18 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
19 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
20 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
21 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
22 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
23 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPERCASE_REQUIRED';
27 G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
28
29 ------------------------------------------------------------------------------------
30 -- GLOBAL EXCEPTION
31 ---------------------------------------------------------------------------
32 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
33
34 -- GLOBAL VARIABLES
35 ---------------------------------------------------------------------------
36 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SUBSIDY_PVT';
37 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
38 ---------------------------------------------------------------------------
39
40 PROCEDURE create_subsidy(
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_subv_rec IN subv_rec_type,
47 x_subv_rec OUT NOCOPY subv_rec_type);
48
49 PROCEDURE create_subsidy(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_subv_tbl IN subv_tbl_type,
56 x_subv_tbl OUT NOCOPY subv_tbl_type);
57
58
59 PROCEDURE update_subsidy(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_subv_rec IN subv_rec_type,
66 x_subv_rec OUT NOCOPY subv_rec_type);
67
68 PROCEDURE update_subsidy(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_subv_tbl IN subv_tbl_type,
75 x_subv_tbl OUT NOCOPY subv_tbl_type);
76
77 PROCEDURE delete_subsidy(
78 p_api_version IN NUMBER,
79 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_subv_rec IN subv_rec_type);
84
85 PROCEDURE delete_subsidy(
86 p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_subv_tbl IN subv_tbl_type);
92
93 PROCEDURE lock_subsidy(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_subv_rec IN subv_rec_type);
100
101 PROCEDURE lock_subsidy(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_subv_tbl IN subv_tbl_type);
108
109
110 PROCEDURE validate_subsidy(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_subv_rec IN subv_rec_type);
117
118 PROCEDURE validate_subsidy(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_subv_tbl IN subv_tbl_type);
125
126 PROCEDURE create_subsidy_criteria(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_sucv_rec IN sucv_rec_type,
133 x_sucv_rec OUT NOCOPY sucv_rec_type);
134
135 PROCEDURE create_subsidy_criteria(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_sucv_tbl IN sucv_tbl_type,
142 x_sucv_tbl OUT NOCOPY sucv_tbl_type);
143
144
145 PROCEDURE update_subsidy_criteria(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_sucv_rec IN sucv_rec_type,
152 x_sucv_rec OUT NOCOPY sucv_rec_type);
153
154 PROCEDURE update_subsidy_criteria(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_sucv_tbl IN sucv_tbl_type,
161 x_sucv_tbl OUT NOCOPY sucv_tbl_type);
162
163 PROCEDURE delete_subsidy_criteria(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_sucv_rec IN sucv_rec_type);
170
171 PROCEDURE delete_subsidy_criteria(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
174 x_return_status OUT NOCOPY VARCHAR2,
175 x_msg_count OUT NOCOPY NUMBER,
176 x_msg_data OUT NOCOPY VARCHAR2,
177 p_sucv_tbl IN sucv_tbl_type);
178
179 PROCEDURE lock_subsidy_criteria(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_sucv_rec IN sucv_rec_type);
186
187 PROCEDURE lock_subsidy_criteria(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_sucv_tbl IN sucv_tbl_type);
194
195
196 PROCEDURE validate_subsidy_criteria(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_sucv_rec IN sucv_rec_type);
203
204 PROCEDURE validate_subsidy_criteria(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_sucv_tbl IN sucv_tbl_type);
211
212 PROCEDURE add_language;
213
214 END OKL_SUBSIDY_PVT;