[Home] [Help]
PACKAGE: APPS.OKS_PML_PVT
Source
1 PACKAGE OKS_PML_PVT AS
2 /* $Header: OKSSPMLS.pls 120.1 2005/07/15 09:25:16 parkumar noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_PM_STREAM_LEVELS_V Record Spec
7 TYPE pmlv_rec_type IS RECORD (
8 id NUMBER := OKC_API.G_MISS_NUM
9 ,cle_id NUMBER := OKC_API.G_MISS_NUM
10 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
11 ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
12 ,sequence_number NUMBER := OKC_API.G_MISS_NUM
13 ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
14 ,start_date OKS_PM_STREAM_LEVELS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE
15 ,end_date OKS_PM_STREAM_LEVELS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE
16 ,frequency NUMBER := OKC_API.G_MISS_NUM
17 ,frequency_uom OKS_PM_STREAM_LEVELS_V.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
18 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
19 ,offset_uom OKS_PM_STREAM_LEVELS_V.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
20 ,autoschedule_yn OKS_PM_STREAM_LEVELS_V.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
21 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
22 ,program_id NUMBER := OKC_API.G_MISS_NUM
23 ,program_update_date OKS_PM_STREAM_LEVELS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
24 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
25 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
26 ,request_id NUMBER := OKC_API.G_MISS_NUM
27 ,created_by NUMBER := OKC_API.G_MISS_NUM
28 ,creation_date OKS_PM_STREAM_LEVELS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
29 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
30 ,last_update_date OKS_PM_STREAM_LEVELS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
31 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
32 -- R12 Data Model Changes 4485150 Start
33 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
34 ,orig_system_reference1 OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
35 ,orig_system_source_code OKS_PM_STREAM_LEVELS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
36 -- R12 Data Model Changes 4485150 End
37 );
38 G_MISS_pmlv_rec pmlv_rec_type;
39 TYPE pmlv_tbl_type IS TABLE OF pmlv_rec_type
40 INDEX BY BINARY_INTEGER;
41 -- OKS_PM_STREAM_LEVELS Record Spec
42 TYPE pml_rec_type IS RECORD (
43 id NUMBER := OKC_API.G_MISS_NUM
44 ,cle_id NUMBER := OKC_API.G_MISS_NUM
45 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
46 ,activity_line_id NUMBER := OKC_API.G_MISS_NUM
47 ,sequence_number NUMBER := OKC_API.G_MISS_NUM
48 ,number_of_occurences NUMBER := OKC_API.G_MISS_NUM
49 ,start_date OKS_PM_STREAM_LEVELS.START_DATE%TYPE := OKC_API.G_MISS_DATE
50 ,end_date OKS_PM_STREAM_LEVELS.END_DATE%TYPE := OKC_API.G_MISS_DATE
51 ,frequency NUMBER := OKC_API.G_MISS_NUM
52 ,frequency_uom OKS_PM_STREAM_LEVELS.FREQUENCY_UOM%TYPE := OKC_API.G_MISS_CHAR
53 ,offset_duration NUMBER := OKC_API.G_MISS_NUM
54 ,offset_uom OKS_PM_STREAM_LEVELS.OFFSET_UOM%TYPE := OKC_API.G_MISS_CHAR
55 ,autoschedule_yn OKS_PM_STREAM_LEVELS.AUTOSCHEDULE_YN%TYPE := OKC_API.G_MISS_CHAR
56 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
57 ,program_id NUMBER := OKC_API.G_MISS_NUM
58 ,program_update_date OKS_PM_STREAM_LEVELS.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
59 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
60 ,request_id NUMBER := OKC_API.G_MISS_NUM
61 ,created_by NUMBER := OKC_API.G_MISS_NUM
62 ,creation_date OKS_PM_STREAM_LEVELS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64 ,last_update_date OKS_PM_STREAM_LEVELS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66 -- R12 Data Model Changes 4485150 Start
67 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
68 ,orig_system_reference1 OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
69 ,orig_system_source_code OKS_PM_STREAM_LEVELS.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
70 -- R12 Data Model Changes 4485150 End
71 );
72 G_MISS_pml_rec pml_rec_type;
73 TYPE pml_tbl_type IS TABLE OF pml_rec_type
74 INDEX BY BINARY_INTEGER;
75 ---------------------------------------------------------------------------
76 -- GLOBAL MESSAGE CONSTANTS
77 ---------------------------------------------------------------------------
78 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
79 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
80 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
81 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
82 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
83 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
84 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
85 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
86 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
87 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
88 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
89 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
90 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
91
92 ---------------------------------------------------------------------------
93 -- GLOBAL EXCEPTIONS
94 ---------------------------------------------------------------------------
95 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
96
97 ---------------------------------------------------------------------------
98 -- GLOBAL VARIABLES
99 ---------------------------------------------------------------------------
100 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_PML_PVT';
101 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
102 ---------------------------------------------------------------------------
103 -- Procedures and Functions
104 ---------------------------------------------------------------------------
105
106 PROCEDURE qc;
107 PROCEDURE change_version;
108 PROCEDURE api_copy;
109 PROCEDURE insert_row(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_pmlv_rec IN pmlv_rec_type,
116 x_pmlv_rec OUT NOCOPY pmlv_rec_type);
117 PROCEDURE insert_row(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_pmlv_tbl IN pmlv_tbl_type,
124 x_pmlv_tbl OUT NOCOPY pmlv_tbl_type,
125 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
126 PROCEDURE insert_row(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pmlv_tbl IN pmlv_tbl_type,
133 x_pmlv_tbl OUT NOCOPY pmlv_tbl_type);
134 PROCEDURE lock_row(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_pmlv_rec IN pmlv_rec_type);
141 PROCEDURE lock_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_pmlv_tbl IN pmlv_tbl_type,
148 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
149 PROCEDURE lock_row(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_pmlv_tbl IN pmlv_tbl_type);
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_pmlv_rec IN pmlv_rec_type,
163 x_pmlv_rec OUT NOCOPY pmlv_rec_type);
164 PROCEDURE update_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_pmlv_tbl IN pmlv_tbl_type,
171 x_pmlv_tbl OUT NOCOPY pmlv_tbl_type,
172 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
173 PROCEDURE update_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_pmlv_tbl IN pmlv_tbl_type,
180 x_pmlv_tbl OUT NOCOPY pmlv_tbl_type);
181 PROCEDURE delete_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_pmlv_rec IN pmlv_rec_type);
188 PROCEDURE delete_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_pmlv_tbl IN pmlv_tbl_type,
195 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
196 PROCEDURE delete_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pmlv_tbl IN pmlv_tbl_type);
203 PROCEDURE validate_row(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_pmlv_rec IN pmlv_rec_type);
210 PROCEDURE validate_row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_pmlv_tbl IN pmlv_tbl_type,
217 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
218 PROCEDURE validate_row(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_pmlv_tbl IN pmlv_tbl_type);
225 FUNCTION Create_Version(
226 p_id IN NUMBER,
227 p_major_version IN NUMBER) RETURN VARCHAR2;
228
229 FUNCTION restore_version(
230 p_id IN NUMBER,
231 p_major_version IN NUMBER) RETURN VARCHAR2;
232
233
234 END OKS_PML_PVT;