[Home] [Help]
PACKAGE: APPS.OKS_PMA_PVT
Source
1 PACKAGE OKS_PMA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSSPMAS.pls 120.1 2005/07/15 09:21:16 parkumar noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 -- OKS_PM_ACTIVITIES_V Record Spec
7 TYPE pmav_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_id NUMBER := OKC_API.G_MISS_NUM
12 ,select_yn OKS_PM_ACTIVITIES_V.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
13 ,conf_req_yn OKS_PM_ACTIVITIES_V.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
14 ,sch_exists_yn OKS_PM_ACTIVITIES_V.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
15 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
16 ,program_id NUMBER := OKC_API.G_MISS_NUM
17 ,program_update_date OKS_PM_ACTIVITIES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
19 ,security_group_id NUMBER := OKC_API.G_MISS_NUM
20 ,request_id NUMBER := OKC_API.G_MISS_NUM
21 ,created_by NUMBER := OKC_API.G_MISS_NUM
22 ,creation_date OKS_PM_ACTIVITIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
23 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
24 ,last_update_date OKS_PM_ACTIVITIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
25 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
26 -- R12 Data Model Changes 4485150 Start
27 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
28 ,orig_system_reference1 OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
29 ,orig_system_source_code OKS_PM_ACTIVITIES_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
30 -- R12 Data Model Changes 4485150 End
31 );
32 G_MISS_pmav_rec pmav_rec_type;
33 TYPE pmav_tbl_type IS TABLE OF pmav_rec_type
34 INDEX BY BINARY_INTEGER;
35 -- OKS_PM_ACTIVITIES Record Spec
36 TYPE pma_rec_type IS RECORD (
37 id NUMBER := OKC_API.G_MISS_NUM
38 ,cle_id NUMBER := OKC_API.G_MISS_NUM
39 ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
40 ,activity_id NUMBER := OKC_API.G_MISS_NUM
41 ,select_yn OKS_PM_ACTIVITIES.SELECT_YN%TYPE := OKC_API.G_MISS_CHAR
42 ,conf_req_yn OKS_PM_ACTIVITIES.CONF_REQ_YN%TYPE := OKC_API.G_MISS_CHAR
43 ,sch_exists_yn OKS_PM_ACTIVITIES.SCH_EXISTS_YN%TYPE := OKC_API.G_MISS_CHAR
44 ,program_application_id NUMBER := OKC_API.G_MISS_NUM
45 ,program_id NUMBER := OKC_API.G_MISS_NUM
46 ,program_update_date OKS_PM_ACTIVITIES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
47 ,object_version_number NUMBER := OKC_API.G_MISS_NUM
48 ,request_id NUMBER := OKC_API.G_MISS_NUM
49 ,created_by NUMBER := OKC_API.G_MISS_NUM
50 ,creation_date OKS_PM_ACTIVITIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
51 ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
52 ,last_update_date OKS_PM_ACTIVITIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
53 ,last_update_login NUMBER := OKC_API.G_MISS_NUM
54 -- R12 Data Model Changes 4485150 Start
55 ,orig_system_id1 NUMBER := OKC_API.G_MISS_NUM
56 ,orig_system_reference1 OKS_PM_ACTIVITIES.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR
57 ,orig_system_source_code OKS_PM_ACTIVITIES.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
58 -- R12 Data Model Changes 4485150 End
59 );
60 G_MISS_pma_rec pma_rec_type;
61 TYPE pma_tbl_type IS TABLE OF pma_rec_type
62 INDEX BY BINARY_INTEGER;
63 ---------------------------------------------------------------------------
64 -- GLOBAL MESSAGE CONSTANTS
65 ---------------------------------------------------------------------------
66 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
67 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
68 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
69 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
70 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
71 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
72 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
73 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
74 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
75 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
76 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
77 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
78 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
79
80 ---------------------------------------------------------------------------
81 -- GLOBAL EXCEPTIONS
82 ---------------------------------------------------------------------------
83 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
84
85 ---------------------------------------------------------------------------
86 -- GLOBAL VARIABLES
87 ---------------------------------------------------------------------------
88 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_PMA_PVT';
89 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
90 ---------------------------------------------------------------------------
91 -- Procedures and Functions
92 ---------------------------------------------------------------------------
93
94 PROCEDURE qc;
95 PROCEDURE change_version;
96 PROCEDURE api_copy;
97 PROCEDURE insert_row(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_pmav_rec IN pmav_rec_type,
104 x_pmav_rec OUT NOCOPY pmav_rec_type);
105 PROCEDURE insert_row(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_pmav_tbl IN pmav_tbl_type,
112 x_pmav_tbl OUT NOCOPY pmav_tbl_type,
113 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
114 PROCEDURE insert_row(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_pmav_tbl IN pmav_tbl_type,
121 x_pmav_tbl OUT NOCOPY pmav_tbl_type);
122 PROCEDURE lock_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_pmav_rec IN pmav_rec_type);
129 PROCEDURE lock_row(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_pmav_tbl IN pmav_tbl_type,
136 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
137 PROCEDURE lock_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_pmav_tbl IN pmav_tbl_type);
144 PROCEDURE update_row(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_pmav_rec IN pmav_rec_type,
151 x_pmav_rec OUT NOCOPY pmav_rec_type);
152 PROCEDURE update_row(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_pmav_tbl IN pmav_tbl_type,
159 x_pmav_tbl OUT NOCOPY pmav_tbl_type,
160 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
161 PROCEDURE update_row(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_pmav_tbl IN pmav_tbl_type,
168 x_pmav_tbl OUT NOCOPY pmav_tbl_type);
169 PROCEDURE delete_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_pmav_rec IN pmav_rec_type);
176 PROCEDURE delete_row(
177 p_api_version IN NUMBER,
178 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2,
182 p_pmav_tbl IN pmav_tbl_type,
183 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
184 PROCEDURE delete_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_pmav_tbl IN pmav_tbl_type);
191 PROCEDURE validate_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_pmav_rec IN pmav_rec_type);
198 PROCEDURE validate_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_pmav_tbl IN pmav_tbl_type,
205 px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206 PROCEDURE validate_row(
207 p_api_version IN NUMBER,
208 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209 x_return_status OUT NOCOPY VARCHAR2,
210 x_msg_count OUT NOCOPY NUMBER,
211 x_msg_data OUT NOCOPY VARCHAR2,
212 p_pmav_tbl IN pmav_tbl_type);
213
214 FUNCTION Create_Version(
215 p_id IN NUMBER,
216 p_major_version IN NUMBER) RETURN VARCHAR2;
217
218 FUNCTION restore_version(
219 p_id IN NUMBER,
220 p_major_version IN NUMBER) RETURN VARCHAR2;
221
222 END OKS_PMA_PVT;