[Home] [Help]
PACKAGE: APPS.OKC_CPL_PVT
Source
1 Package OKC_CPL_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCSCPLS.pls 120.2 2005/08/03 05:39:49 parkumar noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE cpl_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 cpl_id NUMBER := OKC_API.G_MISS_NUM,
9 chr_id NUMBER := OKC_API.G_MISS_NUM,
10 cle_id NUMBER := OKC_API.G_MISS_NUM,
11 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
12 rle_code OKC_K_PARTY_ROLES_B.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
13 object1_id1 OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
14 object1_id2 OKC_K_PARTY_ROLES_B.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
15 jtot_object1_code OKC_K_PARTY_ROLES_B.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
16 object_version_number NUMBER := OKC_API.G_MISS_NUM,
17 created_by NUMBER := OKC_API.G_MISS_NUM,
18 creation_date OKC_K_PARTY_ROLES_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
19 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
20 last_update_date OKC_K_PARTY_ROLES_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
21 code OKC_K_PARTY_ROLES_B.CODE%TYPE := OKC_API.G_MISS_CHAR,
22 facility OKC_K_PARTY_ROLES_B.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
23 minority_group_lookup_code OKC_K_PARTY_ROLES_B.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
24 small_business_flag OKC_K_PARTY_ROLES_B.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
25 women_owned_flag OKC_K_PARTY_ROLES_B.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
26 last_update_login NUMBER := OKC_API.G_MISS_NUM,
27 primary_yn OKC_K_PARTY_ROLES_B.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
28 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
29 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
30 attribute_category OKC_K_PARTY_ROLES_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
31 attribute1 OKC_K_PARTY_ROLES_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
32 attribute2 OKC_K_PARTY_ROLES_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
33 attribute3 OKC_K_PARTY_ROLES_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
34 attribute4 OKC_K_PARTY_ROLES_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
35 attribute5 OKC_K_PARTY_ROLES_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
36 attribute6 OKC_K_PARTY_ROLES_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
37 attribute7 OKC_K_PARTY_ROLES_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
38 attribute8 OKC_K_PARTY_ROLES_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
39 attribute9 OKC_K_PARTY_ROLES_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
40 attribute10 OKC_K_PARTY_ROLES_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
41 attribute11 OKC_K_PARTY_ROLES_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
42 attribute12 OKC_K_PARTY_ROLES_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
43 attribute13 OKC_K_PARTY_ROLES_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
44 attribute14 OKC_K_PARTY_ROLES_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
45 attribute15 OKC_K_PARTY_ROLES_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
46 -- R12 Data Model Changes 4485150 Start
47 orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
48 orig_system_reference1 OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
49 orig_system_source_code OKC_K_PARTY_ROLES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR
50 -- R12 Data Model Changes 4485150 End
51 );
52 g_miss_cpl_rec cpl_rec_type;
53 TYPE cpl_tbl_type IS TABLE OF cpl_rec_type
54 INDEX BY BINARY_INTEGER;
55 TYPE okc_k_party_roles_tl_rec_type IS RECORD (
56 id NUMBER := OKC_API.G_MISS_NUM,
57 language OKC_K_PARTY_ROLES_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
58 source_lang OKC_K_PARTY_ROLES_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
59 sfwt_flag OKC_K_PARTY_ROLES_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60 created_by NUMBER := OKC_API.G_MISS_NUM,
61 creation_date OKC_K_PARTY_ROLES_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63 last_update_date OKC_K_PARTY_ROLES_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64 cognomen OKC_K_PARTY_ROLES_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
65 alias OKC_K_PARTY_ROLES_TL.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
66 last_update_login NUMBER := OKC_API.G_MISS_NUM);
67 GMissOkcKPartyRolesTlRec okc_k_party_roles_tl_rec_type;
68 TYPE okc_k_party_roles_tl_tbl_type IS TABLE OF okc_k_party_roles_tl_rec_type
69 INDEX BY BINARY_INTEGER;
70 TYPE cplv_rec_type IS RECORD (
71 id NUMBER := OKC_API.G_MISS_NUM,
72 object_version_number NUMBER := OKC_API.G_MISS_NUM,
73 sfwt_flag OKC_K_PARTY_ROLES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
77 rle_code OKC_K_PARTY_ROLES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
74 cpl_id NUMBER := OKC_API.G_MISS_NUM,
75 chr_id NUMBER := OKC_API.G_MISS_NUM,
76 cle_id NUMBER := OKC_API.G_MISS_NUM,
78 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
79 object1_id1 OKC_K_PARTY_ROLES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
80 object1_id2 OKC_K_PARTY_ROLES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
81 jtot_object1_code OKC_K_PARTY_ROLES_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
82 cognomen OKC_K_PARTY_ROLES_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
83 code OKC_K_PARTY_ROLES_V.CODE%TYPE := OKC_API.G_MISS_CHAR,
84 facility OKC_K_PARTY_ROLES_V.FACILITY%TYPE := OKC_API.G_MISS_CHAR,
85 minority_group_lookup_code OKC_K_PARTY_ROLES_V.MINORITY_GROUP_LOOKUP_CODE%TYPE := OKC_API.G_MISS_CHAR,
86 small_business_flag OKC_K_PARTY_ROLES_V.SMALL_BUSINESS_FLAG%TYPE := OKC_API.G_MISS_CHAR,
87 women_owned_flag OKC_K_PARTY_ROLES_V.WOMEN_OWNED_FLAG%TYPE := OKC_API.G_MISS_CHAR,
88 alias OKC_K_PARTY_ROLES_V.ALIAS%TYPE := OKC_API.G_MISS_CHAR,
89 primary_yn OKC_K_PARTY_ROLES_V.PRIMARY_YN%TYPE := OKC_API.G_MISS_CHAR,
90 --new columns to replace rules
91 cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
92 bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
93 attribute_category OKC_K_PARTY_ROLES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94 attribute1 OKC_K_PARTY_ROLES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
95 attribute2 OKC_K_PARTY_ROLES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
96 attribute3 OKC_K_PARTY_ROLES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
97 attribute4 OKC_K_PARTY_ROLES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
98 attribute5 OKC_K_PARTY_ROLES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
99 attribute6 OKC_K_PARTY_ROLES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
100 attribute7 OKC_K_PARTY_ROLES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
101 attribute8 OKC_K_PARTY_ROLES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
102 attribute9 OKC_K_PARTY_ROLES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
103 attribute10 OKC_K_PARTY_ROLES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
104 attribute11 OKC_K_PARTY_ROLES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
105 attribute12 OKC_K_PARTY_ROLES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
106 attribute13 OKC_K_PARTY_ROLES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
107 attribute14 OKC_K_PARTY_ROLES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
108 attribute15 OKC_K_PARTY_ROLES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
109 created_by NUMBER := OKC_API.G_MISS_NUM,
110 creation_date OKC_K_PARTY_ROLES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
111 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
112 last_update_date OKC_K_PARTY_ROLES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
113 last_update_login NUMBER := OKC_API.G_MISS_NUM);
114 g_miss_cplv_rec cplv_rec_type;
115 TYPE cplv_tbl_type IS TABLE OF cplv_rec_type
116 INDEX BY BINARY_INTEGER;
117 ---------------------------------------------------------------------------
118 -- GLOBAL MESSAGE CONSTANTS
119 ---------------------------------------------------------------------------
120 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
121 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
122 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
123 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
124 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
125 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
126 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
127 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
128 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
129 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
130 ---------------------------------------------------------------------------
131 -- GLOBAL VARIABLES
132 ---------------------------------------------------------------------------
133 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CPL_PVT';
134 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
135 ---------------------------------------------------------------------------
136 -- Procedures and Functions
137 ---------------------------------------------------------------------------
138
139 PROCEDURE qc;
140 PROCEDURE change_version;
141 PROCEDURE api_copy;
142 PROCEDURE add_language;
143 PROCEDURE insert_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_cplv_rec IN cplv_rec_type,
150 x_cplv_rec OUT NOCOPY cplv_rec_type);
151
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_cplv_tbl IN cplv_tbl_type,
159 x_cplv_tbl OUT NOCOPY cplv_tbl_type);
160
161 PROCEDURE lock_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_cplv_rec IN cplv_rec_type);
168
169 PROCEDURE lock_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_cplv_tbl IN cplv_tbl_type);
176
177 PROCEDURE update_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_cplv_rec IN cplv_rec_type,
184 x_cplv_rec OUT NOCOPY cplv_rec_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_cplv_tbl IN cplv_tbl_type,
193 x_cplv_tbl OUT NOCOPY cplv_tbl_type);
194
195 PROCEDURE delete_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_cplv_rec IN cplv_rec_type);
202
203 PROCEDURE delete_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_cplv_tbl IN cplv_tbl_type);
210
211 PROCEDURE validate_row(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_cplv_rec IN cplv_rec_type);
218
219 PROCEDURE validate_row(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_cplv_tbl IN cplv_tbl_type);
226
227 PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cplv_tbl cplv_tbl_type);
228
229 FUNCTION create_version(
230 p_chr_id IN NUMBER,
231 p_major_version IN NUMBER) RETURN VARCHAR2;
232
233 FUNCTION restore_version(
234 p_chr_id IN NUMBER,
235 p_major_version IN NUMBER) RETURN VARCHAR2;
236
237 END OKC_CPL_PVT;