[Home] [Help]
PACKAGE: APPS.OKC_PDF_PVT
Source
1 Package OKC_PDF_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSPDFS.pls 120.0 2005/06/01 22:56:14 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE okc_process_defs_tl_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 language OKC_PROCESS_DEFS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
9 source_lang OKC_PROCESS_DEFS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
10 sfwt_flag OKC_PROCESS_DEFS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
11 name OKC_PROCESS_DEFS_TL.NAME%TYPE := OKC_API.G_MISS_CHAR,
12 description OKC_PROCESS_DEFS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
13 short_description OKC_PROCESS_DEFS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14 comments OKC_PROCESS_DEFS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15 created_by NUMBER := OKC_API.G_MISS_NUM,
16 creation_date OKC_PROCESS_DEFS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18 last_update_date OKC_PROCESS_DEFS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19 last_update_login NUMBER := OKC_API.G_MISS_NUM);
20 g_miss_okc_process_defs_tl_rec okc_process_defs_tl_rec_type;
21 TYPE okc_process_defs_tl_tbl_type IS TABLE OF okc_process_defs_tl_rec_type
22 INDEX BY BINARY_INTEGER;
23 TYPE pdf_rec_type IS RECORD (
24 id NUMBER := OKC_API.G_MISS_NUM,
25 pdf_type OKC_PROCESS_DEFS_B.PDF_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26 object_version_number NUMBER := OKC_API.G_MISS_NUM,
27 created_by NUMBER := OKC_API.G_MISS_NUM,
28 usage OKC_PROCESS_DEFS_B.USAGE%TYPE := OKC_API.G_MISS_CHAR,
29 creation_date OKC_PROCESS_DEFS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
30 begin_date OKC_PROCESS_DEFS_B.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
31 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32 last_update_date OKC_PROCESS_DEFS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33 wf_name OKC_PROCESS_DEFS_B.WF_NAME%TYPE := OKC_API.G_MISS_CHAR,
34 wf_process_name OKC_PROCESS_DEFS_B.WF_PROCESS_NAME%TYPE := OKC_API.G_MISS_CHAR,
35 procedure_name OKC_PROCESS_DEFS_B.PROCEDURE_NAME%TYPE := OKC_API.G_MISS_CHAR,
36 package_name OKC_PROCESS_DEFS_B.PACKAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
37 last_update_login NUMBER := OKC_API.G_MISS_NUM,
38 end_date OKC_PROCESS_DEFS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
39 attribute_category OKC_PROCESS_DEFS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
40 attribute1 OKC_PROCESS_DEFS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
41 attribute2 OKC_PROCESS_DEFS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
42 attribute3 OKC_PROCESS_DEFS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
43 attribute4 OKC_PROCESS_DEFS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
44 attribute5 OKC_PROCESS_DEFS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
45 attribute6 OKC_PROCESS_DEFS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
46 attribute7 OKC_PROCESS_DEFS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
47 attribute8 OKC_PROCESS_DEFS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
48 attribute9 OKC_PROCESS_DEFS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
49 attribute10 OKC_PROCESS_DEFS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
50 attribute11 OKC_PROCESS_DEFS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
51 attribute12 OKC_PROCESS_DEFS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
52 attribute13 OKC_PROCESS_DEFS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
53 attribute14 OKC_PROCESS_DEFS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
54 attribute15 OKC_PROCESS_DEFS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
55 application_id NUMBER := OKC_API.G_MISS_NUM,
56 seeded_flag OKC_PROCESS_DEFS_B.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
57 message_name OKC_PROCESS_DEFS_B.MESSAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
58 script_name OKC_PROCESS_DEFS_B.SCRIPT_NAME%TYPE := OKC_API.G_MISS_CHAR);
59 g_miss_pdf_rec pdf_rec_type;
60 TYPE pdf_tbl_type IS TABLE OF pdf_rec_type
61 INDEX BY BINARY_INTEGER;
62 TYPE pdfv_rec_type IS RECORD (
63 id NUMBER := OKC_API.G_MISS_NUM,
64 object_version_number NUMBER := OKC_API.G_MISS_NUM,
65 sfwt_flag OKC_PROCESS_DEFS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
66 description OKC_PROCESS_DEFS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
67 short_description OKC_PROCESS_DEFS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
68 comments OKC_PROCESS_DEFS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
69 usage OKC_PROCESS_DEFS_V.USAGE%TYPE := OKC_API.G_MISS_CHAR,
70 name OKC_PROCESS_DEFS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
71 wf_name OKC_PROCESS_DEFS_V.WF_NAME%TYPE := OKC_API.G_MISS_CHAR,
72 wf_process_name OKC_PROCESS_DEFS_V.WF_PROCESS_NAME%TYPE := OKC_API.G_MISS_CHAR,
73 procedure_name OKC_PROCESS_DEFS_V.PROCEDURE_NAME%TYPE := OKC_API.G_MISS_CHAR,
74 package_name OKC_PROCESS_DEFS_V.PACKAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
75 pdf_type OKC_PROCESS_DEFS_V.PDF_TYPE%TYPE := OKC_API.G_MISS_CHAR,
76 application_id NUMBER := OKC_API.G_MISS_NUM,
77 seeded_flag OKC_PROCESS_DEFS_V.SEEDED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
78 attribute_category OKC_PROCESS_DEFS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
79 attribute1 OKC_PROCESS_DEFS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
80 attribute2 OKC_PROCESS_DEFS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
81 attribute3 OKC_PROCESS_DEFS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
82 attribute4 OKC_PROCESS_DEFS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
83 attribute5 OKC_PROCESS_DEFS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
84 attribute6 OKC_PROCESS_DEFS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
85 attribute7 OKC_PROCESS_DEFS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
86 attribute8 OKC_PROCESS_DEFS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
87 attribute9 OKC_PROCESS_DEFS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
88 attribute10 OKC_PROCESS_DEFS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
89 attribute11 OKC_PROCESS_DEFS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
90 attribute12 OKC_PROCESS_DEFS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
91 attribute13 OKC_PROCESS_DEFS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
92 attribute14 OKC_PROCESS_DEFS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
93 attribute15 OKC_PROCESS_DEFS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
94 created_by NUMBER := OKC_API.G_MISS_NUM,
95 begin_date OKC_PROCESS_DEFS_V.BEGIN_DATE%TYPE := OKC_API.G_MISS_DATE,
96 end_date OKC_PROCESS_DEFS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
97 creation_date OKC_PROCESS_DEFS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
98 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
99 last_update_date OKC_PROCESS_DEFS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
100 last_update_login NUMBER := OKC_API.G_MISS_NUM,
101 message_name OKC_PROCESS_DEFS_V.MESSAGE_NAME%TYPE := OKC_API.G_MISS_CHAR,
102 script_name OKC_PROCESS_DEFS_V.SCRIPT_NAME%TYPE := OKC_API.G_MISS_CHAR);
103 g_miss_pdfv_rec pdfv_rec_type;
104 TYPE pdfv_tbl_type IS TABLE OF pdfv_rec_type
105 INDEX BY BINARY_INTEGER;
106 ---------------------------------------------------------------------------
107 -- GLOBAL MESSAGE CONSTANTS
108 ---------------------------------------------------------------------------
109 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
110 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
111 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
112 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
113 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
114 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
115 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
116 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
117 G_COL_NAME_TOKEN1 CONSTANT VARCHAR2(200) := 'COL_NAME1';
118 G_COL_NAME_TOKEN2 CONSTANT VARCHAR2(200) := 'COL_NAME2';
119 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
120 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
121 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
122 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
123 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
124 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
125 --G_UNQS CONSTANT VARCHAR2(200) := 'OKC_VALUES_NOT_UNIQUE';
126 G_UNQS1 CONSTANT VARCHAR2(200) := 'OKC_PKG_PROC_NOT_UNIQUE';
127 G_UNQS2 CONSTANT VARCHAR2(200) := 'OKC_WF_NAME_PROCESS_NOT_UNIQUE';
128 G_ARC_VIOLATED CONSTANT VARCHAR2(200) := 'OKC_ARC_VIOLATED';
129 G_ARC_MANDATORY CONSTANT VARCHAR2(200) := 'OKC_ARC_MANDATORY';
130 G_INVALID_END_DATE CONSTANT VARCHAR2(200) := 'OKC_INVALID_END_DATE';
131 G_COL_NAME1 CONSTANT VARCHAR2(200) := 'OKC_COL_NAME1';
132 G_COL_NAME2 CONSTANT VARCHAR2(200) := 'OKC_COL_NAME2';
133 ---------------------------------------------------------------------------
134 -- GLOBAL VARIABLES
135 ---------------------------------------------------------------------------
136 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PDF_PVT';
137 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
138 G_VIEW CONSTANT VARCHAR2(200) := 'OKC_PROCESS_DEFS_V';
139 ---------------------------------------------------------------------------
140 -- GLOBAL EXCEPTION
141 ---------------------------------------------------------------------------
142 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
143
144 ---------------------------------------------------------------------------
145 -- Procedures and Functions
146 ---------------------------------------------------------------------------
147
148 PROCEDURE qc;
149 PROCEDURE change_version;
150 PROCEDURE api_copy;
151 PROCEDURE add_language;
152 PROCEDURE insert_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_pdfv_rec IN pdfv_rec_type,
159 x_pdfv_rec OUT NOCOPY pdfv_rec_type);
160
161 PROCEDURE insert_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_pdfv_tbl IN pdfv_tbl_type,
168 x_pdfv_tbl OUT NOCOPY pdfv_tbl_type);
169
170 PROCEDURE lock_row(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_pdfv_rec IN pdfv_rec_type);
177
178 PROCEDURE lock_row(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_pdfv_tbl IN pdfv_tbl_type);
185
186 PROCEDURE update_row(
187 p_api_version IN NUMBER,
188 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 x_return_status OUT NOCOPY VARCHAR2,
190 x_msg_count OUT NOCOPY NUMBER,
191 x_msg_data OUT NOCOPY VARCHAR2,
192 p_pdfv_rec IN pdfv_rec_type,
193 x_pdfv_rec OUT NOCOPY pdfv_rec_type);
194
195 PROCEDURE update_row(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_pdfv_tbl IN pdfv_tbl_type,
202 x_pdfv_tbl OUT NOCOPY pdfv_tbl_type);
203
204 PROCEDURE delete_row(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_pdfv_rec IN pdfv_rec_type);
211
212 PROCEDURE delete_row(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_pdfv_tbl IN pdfv_tbl_type);
219
220 PROCEDURE validate_row(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_pdfv_rec IN pdfv_rec_type);
227
228 PROCEDURE validate_row(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
231 x_return_status OUT NOCOPY VARCHAR2,
232 x_msg_count OUT NOCOPY NUMBER,
233 x_msg_data OUT NOCOPY VARCHAR2,
234 p_pdfv_tbl IN pdfv_tbl_type);
235
236 END OKC_PDF_PVT;