[Home] [Help]
PACKAGE: APPS.OKC_SCN_PVT
Source
1 Package OKC_SCN_PVT AS
2 /* $Header: OKCSSCNS.pls 120.0 2005/05/25 19:40:20 appldev noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE scn_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 scn_type OKC_SECTIONS_B.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 sat_code OKC_SECTIONS_B.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11 section_sequence NUMBER := OKC_API.G_MISS_NUM,
12 object_version_number NUMBER := OKC_API.G_MISS_NUM,
13 created_by NUMBER := OKC_API.G_MISS_NUM,
14 creation_date OKC_SECTIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16 last_update_date OKC_SECTIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17 last_update_login NUMBER := OKC_API.G_MISS_NUM,
18 label OKC_SECTIONS_B.LABEL%TYPE := OKC_API.G_MISS_CHAR,
19 scn_id NUMBER := OKC_API.G_MISS_NUM,
20 attribute_category OKC_SECTIONS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
21 attribute1 OKC_SECTIONS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
22 attribute2 OKC_SECTIONS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
23 attribute3 OKC_SECTIONS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
24 attribute4 OKC_SECTIONS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
25 attribute5 OKC_SECTIONS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
26 attribute6 OKC_SECTIONS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
27 attribute7 OKC_SECTIONS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
28 attribute8 OKC_SECTIONS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
29 attribute9 OKC_SECTIONS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
30 attribute10 OKC_SECTIONS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
31 attribute11 OKC_SECTIONS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
32 attribute12 OKC_SECTIONS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
33 attribute13 OKC_SECTIONS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
34 attribute14 OKC_SECTIONS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
35 attribute15 OKC_SECTIONS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
36 g_miss_scn_rec scn_rec_type;
37 TYPE scn_tbl_type IS TABLE OF scn_rec_type
38 INDEX BY BINARY_INTEGER;
39 TYPE okc_sections_tl_rec_type IS RECORD (
40 id NUMBER := OKC_API.G_MISS_NUM,
41 language OKC_SECTIONS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
42 source_lang OKC_SECTIONS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
43 sfwt_flag OKC_SECTIONS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
44 heading OKC_SECTIONS_TL.HEADING%TYPE := OKC_API.G_MISS_CHAR,
45 created_by NUMBER := OKC_API.G_MISS_NUM,
46 creation_date OKC_SECTIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48 last_update_date OKC_SECTIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49 last_update_login NUMBER := OKC_API.G_MISS_NUM);
50 g_miss_okc_sections_tl_rec okc_sections_tl_rec_type;
51 TYPE okc_sections_tl_tbl_type IS TABLE OF okc_sections_tl_rec_type
52 INDEX BY BINARY_INTEGER;
53 TYPE scnv_rec_type IS RECORD (
54 id NUMBER := OKC_API.G_MISS_NUM,
55 scn_type OKC_SECTIONS_V.SCN_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56 chr_id NUMBER := OKC_API.G_MISS_NUM,
57 sat_code OKC_SECTIONS_V.SAT_CODE%TYPE := OKC_API.G_MISS_CHAR,
58 section_sequence NUMBER := OKC_API.G_MISS_NUM,
59 label OKC_SECTIONS_V.LABEL%TYPE := OKC_API.G_MISS_CHAR,
60 heading OKC_SECTIONS_V.HEADING%TYPE := OKC_API.G_MISS_CHAR,
61 scn_id NUMBER := OKC_API.G_MISS_NUM,
62 object_version_number NUMBER := OKC_API.G_MISS_NUM,
63 sfwt_flag OKC_SECTIONS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
64 created_by NUMBER := OKC_API.G_MISS_NUM,
65 creation_date OKC_SECTIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
66 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
67 last_update_date OKC_SECTIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
68 last_update_login NUMBER := OKC_API.G_MISS_NUM,
69 attribute_category OKC_SECTIONS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
70 attribute1 OKC_SECTIONS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
71 attribute2 OKC_SECTIONS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
72 attribute3 OKC_SECTIONS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
73 attribute4 OKC_SECTIONS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
74 attribute5 OKC_SECTIONS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
75 attribute6 OKC_SECTIONS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
76 attribute7 OKC_SECTIONS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
77 attribute8 OKC_SECTIONS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
78 attribute9 OKC_SECTIONS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
79 attribute10 OKC_SECTIONS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
80 attribute11 OKC_SECTIONS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
81 attribute12 OKC_SECTIONS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
82 attribute13 OKC_SECTIONS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
83 attribute14 OKC_SECTIONS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
84 attribute15 OKC_SECTIONS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
85 g_miss_scnv_rec scnv_rec_type;
86 TYPE scnv_tbl_type IS TABLE OF scnv_rec_type
87 INDEX BY BINARY_INTEGER;
88 ---------------------------------------------------------------------------
89 -- GLOBAL MESSAGE CONSTANTS
90 ---------------------------------------------------------------------------
91 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
102 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
103 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
104 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
105 G_EXCEPTION_HALT_VALIDATION exception;
106 G_VIEW CONSTANT VARCHAR2(200) := 'OKC_SECTIONS_V';
107
108 ---------------------------------------------------------------------------
109 -- GLOBAL VARIABLES
110 ---------------------------------------------------------------------------
111 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SCN_PVT';
112 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
113 ---------------------------------------------------------------------------
114 -- Procedures and Functions
115 ---------------------------------------------------------------------------
116
117 PROCEDURE add_language;
118 PROCEDURE insert_row(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_scnv_rec IN scnv_rec_type,
125 x_scnv_rec OUT NOCOPY scnv_rec_type);
126
127 PROCEDURE insert_row(
128 p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_scnv_tbl IN scnv_tbl_type,
134 x_scnv_tbl OUT NOCOPY scnv_tbl_type);
135
136 PROCEDURE lock_row(
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_scnv_rec IN scnv_rec_type);
143
144 PROCEDURE lock_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_scnv_tbl IN scnv_tbl_type);
151
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_scnv_rec IN scnv_rec_type,
159 x_scnv_rec OUT NOCOPY scnv_rec_type);
160
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_scnv_tbl IN scnv_tbl_type,
168 x_scnv_tbl OUT NOCOPY scnv_tbl_type);
169
170 PROCEDURE delete_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_scnv_rec IN scnv_rec_type);
177
178 PROCEDURE delete_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_scnv_tbl IN scnv_tbl_type);
185
186 PROCEDURE validate_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_scnv_rec IN scnv_rec_type);
193
194 PROCEDURE validate_row(
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
197 x_return_status OUT NOCOPY VARCHAR2,
198 x_msg_count OUT NOCOPY NUMBER,
199 x_msg_data OUT NOCOPY VARCHAR2,
200 p_scnv_tbl IN scnv_tbl_type);
201
202 FUNCTION create_version(
203 p_chr_id IN NUMBER,
204 p_major_version IN NUMBER) RETURN VARCHAR2;
205
206 FUNCTION restore_version(
207 p_chr_id IN NUMBER,
208 p_major_version IN NUMBER) RETURN VARCHAR2;
209
210 END OKC_SCN_PVT;