[Home] [Help]
PACKAGE: APPS.OKL_IEN_PVT
Source
1 PACKAGE OKL_IEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSIENS.pls 115.5 2002/03/03 13:54:57 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE ien_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 country_id OKL_INS_EXCLUSIONS_B.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
9 date_from OKL_INS_EXCLUSIONS_B.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
10 coll_code NUMBER := OKC_API.G_MISS_NUM,
11 object_version_number OKL_INS_EXCLUSIONS_B.OBJECT_VERSION_NUMBER%TYPE,
12 sic_code OKL_INS_EXCLUSIONS_B.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
13 date_to OKL_INS_EXCLUSIONS_B.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
14 --comments OKL_INS_EXCLUSIONS_B.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
15 attribute_category OKL_INS_EXCLUSIONS_B.ATTRIBUTE_CATEGORY%TYPE,
16 attribute1 OKL_INS_EXCLUSIONS_B.ATTRIBUTE1%TYPE,
17 attribute2 OKL_INS_EXCLUSIONS_B.ATTRIBUTE2%TYPE,
18 attribute3 OKL_INS_EXCLUSIONS_B.ATTRIBUTE3%TYPE,
19 attribute4 OKL_INS_EXCLUSIONS_B.ATTRIBUTE4%TYPE,
20 attribute5 OKL_INS_EXCLUSIONS_B.ATTRIBUTE5%TYPE,
21 attribute6 OKL_INS_EXCLUSIONS_B.ATTRIBUTE6%TYPE,
22 attribute7 OKL_INS_EXCLUSIONS_B.ATTRIBUTE7%TYPE,
23 attribute8 OKL_INS_EXCLUSIONS_B.ATTRIBUTE8%TYPE,
24 attribute9 OKL_INS_EXCLUSIONS_B.ATTRIBUTE9%TYPE,
25 attribute10 OKL_INS_EXCLUSIONS_B.ATTRIBUTE10%TYPE,
26 attribute11 OKL_INS_EXCLUSIONS_B.ATTRIBUTE11%TYPE,
27 attribute12 OKL_INS_EXCLUSIONS_B.ATTRIBUTE12%TYPE,
28 attribute13 OKL_INS_EXCLUSIONS_B.ATTRIBUTE13%TYPE,
29 attribute14 OKL_INS_EXCLUSIONS_B.ATTRIBUTE14%TYPE,
30 attribute15 OKL_INS_EXCLUSIONS_B.ATTRIBUTE15%TYPE,
31 created_by NUMBER := OKC_API.G_MISS_NUM,
32 creation_date OKL_INS_EXCLUSIONS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
33 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
34 last_update_date OKL_INS_EXCLUSIONS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
35 last_update_login NUMBER := OKC_API.G_MISS_NUM);
36 g_miss_ien_rec ien_rec_type;
37 TYPE ien_tbl_type IS TABLE OF ien_rec_type
38 INDEX BY BINARY_INTEGER;
39 TYPE okl_ins_exclusions_tl_rec_type IS RECORD (
40 id NUMBER := OKC_API.G_MISS_NUM,
41 LANGUAGE OKL_INS_EXCLUSIONS_TL.LANGUAGE%TYPE,
42 source_lang OKL_INS_EXCLUSIONS_TL.SOURCE_LANG%TYPE,
43 sfwt_flag OKL_INS_EXCLUSIONS_TL.SFWT_FLAG%TYPE,
44 comments OKL_INS_EXCLUSIONS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
45 created_by NUMBER := OKC_API.G_MISS_NUM,
46 creation_date OKL_INS_EXCLUSIONS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
47 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
48 last_update_date OKL_INS_EXCLUSIONS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
49 last_update_login NUMBER := OKC_API.G_MISS_NUM
50 );
51 GMissOklInsExclusionsTlRec okl_ins_exclusions_tl_rec_type;
52 TYPE okl_ins_exclusions_tl_tbl_type IS TABLE OF okl_ins_exclusions_tl_rec_type
53 INDEX BY BINARY_INTEGER;
54 TYPE ienv_rec_type IS RECORD (
55 id NUMBER := OKC_API.G_MISS_NUM,
56 object_version_number OKL_INS_EXCLUSIONS_V.OBJECT_VERSION_NUMBER%TYPE,
57 sfwt_flag OKL_INS_EXCLUSIONS_V.SFWT_FLAG%TYPE,
58 country_id OKL_INS_EXCLUSIONS_V.COUNTRY_ID%TYPE := OKC_API.G_MISS_CHAR,
59 coll_code NUMBER := OKC_API.G_MISS_NUM,
60 attribute_category OKL_INS_EXCLUSIONS_V.ATTRIBUTE_CATEGORY%TYPE,
61 attribute1 OKL_INS_EXCLUSIONS_V.ATTRIBUTE1%TYPE,
62 attribute2 OKL_INS_EXCLUSIONS_V.ATTRIBUTE2%TYPE,
63 attribute3 OKL_INS_EXCLUSIONS_V.ATTRIBUTE3%TYPE,
64 attribute4 OKL_INS_EXCLUSIONS_V.ATTRIBUTE4%TYPE,
65 attribute5 OKL_INS_EXCLUSIONS_V.ATTRIBUTE5%TYPE,
66 attribute6 OKL_INS_EXCLUSIONS_V.ATTRIBUTE6%TYPE,
67 attribute7 OKL_INS_EXCLUSIONS_V.ATTRIBUTE7%TYPE,
68 attribute8 OKL_INS_EXCLUSIONS_V.ATTRIBUTE8%TYPE,
69 attribute9 OKL_INS_EXCLUSIONS_V.ATTRIBUTE9%TYPE,
70 attribute10 OKL_INS_EXCLUSIONS_V.ATTRIBUTE10%TYPE,
71 attribute11 OKL_INS_EXCLUSIONS_V.ATTRIBUTE11%TYPE,
72 attribute12 OKL_INS_EXCLUSIONS_V.ATTRIBUTE12%TYPE,
73 attribute13 OKL_INS_EXCLUSIONS_V.ATTRIBUTE13%TYPE,
74 attribute14 OKL_INS_EXCLUSIONS_V.ATTRIBUTE14%TYPE,
75 attribute15 OKL_INS_EXCLUSIONS_V.ATTRIBUTE15%TYPE,
76 date_from OKL_INS_EXCLUSIONS_V.DATE_FROM%TYPE := OKC_API.G_MISS_DATE,
77 sic_code OKL_INS_EXCLUSIONS_V.SIC_CODE%TYPE := OKC_API.G_MISS_CHAR,
78 date_to OKL_INS_EXCLUSIONS_V.DATE_TO%TYPE := OKC_API.G_MISS_DATE,
79 comments OKL_INS_EXCLUSIONS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
80 created_by NUMBER := OKC_API.G_MISS_NUM,
81 creation_date OKL_INS_EXCLUSIONS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
82 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
83 last_update_date OKL_INS_EXCLUSIONS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
84 last_update_login NUMBER := OKC_API.G_MISS_NUM
85 );
86 g_miss_ienv_rec ienv_rec_type;
87 TYPE ienv_tbl_type IS TABLE OF ienv_rec_type
88 INDEX BY BINARY_INTEGER;
89 ---------------------------------------------------------------------------
90 -- GLOBAL MESSAGE CONSTANTS
91 ---------------------------------------------------------------------------
92 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
93 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
94 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
95 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
96 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
97 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
98 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
99 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
100 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
101 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
102 ---------------------------------------------------------------------------
103 -- GLOBAL VARIABLES
104 ---------------------------------------------------------------------------
105 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_IEN_PVT';
106 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKL';
107 -------------------------------------------------------------------------------
108 --Post change to TAPI code
109 -------------------------------------------------------------------------------
110 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
111 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
112 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
113 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
114 g_no_parent_record CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
115 ---------------------------------------------------------------------------
116 ---------------------------------------------------------------------------
117 -- Procedures and Functions
118 ---------------------------------------------------------------------------
119 PROCEDURE qc;
120 PROCEDURE change_version;
121 PROCEDURE api_copy;
122 PROCEDURE add_language;
123 PROCEDURE insert_row(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_ienv_rec IN ienv_rec_type,
130 x_ienv_rec OUT NOCOPY ienv_rec_type);
131 PROCEDURE insert_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_ienv_tbl IN ienv_tbl_type,
138 x_ienv_tbl OUT NOCOPY ienv_tbl_type);
139 PROCEDURE lock_row(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_ienv_rec IN ienv_rec_type);
146 PROCEDURE lock_row(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2,
152 p_ienv_tbl IN ienv_tbl_type);
153 PROCEDURE update_row(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_ienv_rec IN ienv_rec_type,
160 x_ienv_rec OUT NOCOPY ienv_rec_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_ienv_tbl IN ienv_tbl_type,
168 x_ienv_tbl OUT NOCOPY ienv_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_ienv_rec IN ienv_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_ienv_tbl IN ienv_tbl_type);
183 PROCEDURE validate_row(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_ienv_rec IN ienv_rec_type);
190 PROCEDURE validate_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_ienv_tbl IN ienv_tbl_type);
197 END Okl_Ien_Pvt;