[Home] [Help]
PACKAGE: APPS.OKL_SPP_PVT
Source
1 Package OKL_SPP_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSSPPS.pls 115.2 2002/02/15 18:20:31 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE spp_rec_type IS RECORD (
7 id NUMBER := OKC_API.G_MISS_NUM,
8 object_version_number NUMBER := OKC_API.G_MISS_NUM,
9 name OKL_SIF_PRICE_PARMS.NAME%TYPE := OKC_API.G_MISS_CHAR,
10 version OKL_SIF_PRICE_PARMS.VERSION%TYPE := OKC_API.G_MISS_CHAR,
11 date_start OKL_SIF_PRICE_PARMS.DATE_START%TYPE := OKC_API.G_MISS_DATE,
12 date_end OKL_SIF_PRICE_PARMS.DATE_END%TYPE := OKC_API.G_MISS_DATE,
13 description OKL_SIF_PRICE_PARMS.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
14 sps_code OKL_SIF_PRICE_PARMS.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
15 dyp_code OKL_SIF_PRICE_PARMS.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
16 array_yn OKL_SIF_PRICE_PARMS.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
17 xml_tag OKL_SIF_PRICE_PARMS.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
18 attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
19 attribute1 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
20 attribute2 OKL_SIF_PRICE_PARMS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
21 attribute3 OKL_SIF_PRICE_PARMS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
22 attribute4 OKL_SIF_PRICE_PARMS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
23 attribute5 OKL_SIF_PRICE_PARMS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
24 attribute6 OKL_SIF_PRICE_PARMS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
25 attribute7 OKL_SIF_PRICE_PARMS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
26 attribute8 OKL_SIF_PRICE_PARMS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
27 attribute9 OKL_SIF_PRICE_PARMS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
28 attribute10 OKL_SIF_PRICE_PARMS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
29 attribute11 OKL_SIF_PRICE_PARMS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
30 attribute12 OKL_SIF_PRICE_PARMS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
31 attribute13 OKL_SIF_PRICE_PARMS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
32 attribute14 OKL_SIF_PRICE_PARMS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
33 attribute15 OKL_SIF_PRICE_PARMS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
34 created_by NUMBER := OKC_API.G_MISS_NUM,
35 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36 creation_date OKL_SIF_PRICE_PARMS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37 last_update_date OKL_SIF_PRICE_PARMS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
38 last_update_login NUMBER := OKC_API.G_MISS_NUM);
39 g_miss_spp_rec spp_rec_type;
40 TYPE spp_tbl_type IS TABLE OF spp_rec_type
41 INDEX BY BINARY_INTEGER;
42 TYPE sppv_rec_type IS RECORD (
43 id NUMBER := OKC_API.G_MISS_NUM,
44 object_version_number NUMBER := OKC_API.G_MISS_NUM,
45 name OKL_SIF_PRICE_PARMS_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
46 version OKL_SIF_PRICE_PARMS_V.VERSION%TYPE := OKC_API.G_MISS_CHAR,
47 date_start OKL_SIF_PRICE_PARMS_V.DATE_START%TYPE := OKC_API.G_MISS_DATE,
48 date_end OKL_SIF_PRICE_PARMS_V.DATE_END%TYPE := OKC_API.G_MISS_DATE,
49 description OKL_SIF_PRICE_PARMS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
50 sps_code OKL_SIF_PRICE_PARMS_V.SPS_CODE%TYPE := OKC_API.G_MISS_CHAR,
51 dyp_code OKL_SIF_PRICE_PARMS_V.DYP_CODE%TYPE := OKC_API.G_MISS_CHAR,
52 array_yn OKL_SIF_PRICE_PARMS_V.ARRAY_YN%TYPE := OKC_API.G_MISS_CHAR,
53 xml_tag OKL_SIF_PRICE_PARMS_V.XML_TAG%TYPE := OKC_API.G_MISS_CHAR,
54 attribute_category OKL_SIF_PRICE_PARMS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
55 attribute1 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
56 attribute2 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
57 attribute3 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
58 attribute4 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
59 attribute5 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
60 attribute6 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
61 attribute7 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
62 attribute8 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
63 attribute9 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
64 attribute10 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
65 attribute11 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
66 attribute12 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
67 attribute13 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
68 attribute14 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
69 attribute15 OKL_SIF_PRICE_PARMS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
70 created_by NUMBER := OKC_API.G_MISS_NUM,
71 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
72 creation_date OKL_SIF_PRICE_PARMS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
73 last_update_date OKL_SIF_PRICE_PARMS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
74 last_update_login NUMBER := OKC_API.G_MISS_NUM);
75 g_miss_sppv_rec sppv_rec_type;
76 TYPE sppv_tbl_type IS TABLE OF sppv_rec_type
77 INDEX BY BINARY_INTEGER;
78 ---------------------------------------------------------------------------
79 -- GLOBAL MESSAGE CONSTANTS
80 ---------------------------------------------------------------------------
81 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
82 G_OKC_APP CONSTANT VARCHAR2(200) := Okc_Api.G_APP_NAME;
83 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
84 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
85 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
86 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
87 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
88 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
89 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
90 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
91 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
92 -- START CHANGE : akjain -- 05/07/2001
93 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM','Unexpected Error'
94 G_OKL_UNQS CONSTANT VARCHAR2(200) := 'OKL_PRICE_PARM_NOT_UNIQUE';
95 G_OKL_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
96 G_OKL_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
97 G_OKL_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
98 G_OKL_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'NO PARENT RECORD';
99
100 ---------------------------------------------------------------------------
101 -- GLOBAL VARIABLES
102 ---------------------------------------------------------------------------
103 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPP_PVT';
104 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
105
106 -- Added Exception for Halt_validation
107 --------------------------------------------------------------------------------
108 -- ERRORS AND EXCEPTIONS
109 --------------------------------------------------------------------------------
110 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
111 -- END change : mvasudev
112
113 ---------------------------------------------------------------------------
114 -- Procedures and Functions
115 ---------------------------------------------------------------------------
116
117 PROCEDURE qc;
118 PROCEDURE change_version;
119 PROCEDURE api_copy;
120 PROCEDURE insert_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_sppv_rec IN sppv_rec_type,
127 x_sppv_rec OUT NOCOPY sppv_rec_type);
128
129 PROCEDURE insert_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_sppv_tbl IN sppv_tbl_type,
136 x_sppv_tbl OUT NOCOPY sppv_tbl_type);
137
138 PROCEDURE lock_row(
139 p_api_version IN NUMBER,
140 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144 p_sppv_rec IN sppv_rec_type);
145
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_sppv_tbl IN sppv_tbl_type);
153
154 PROCEDURE update_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_sppv_rec IN sppv_rec_type,
161 x_sppv_rec OUT NOCOPY sppv_rec_type);
162
163 PROCEDURE update_row(
164 p_api_version IN NUMBER,
165 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 x_return_status OUT NOCOPY VARCHAR2,
167 x_msg_count OUT NOCOPY NUMBER,
168 x_msg_data OUT NOCOPY VARCHAR2,
169 p_sppv_tbl IN sppv_tbl_type,
170 x_sppv_tbl OUT NOCOPY sppv_tbl_type);
171
172 PROCEDURE delete_row(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_sppv_rec IN sppv_rec_type);
179
180 PROCEDURE delete_row(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_sppv_tbl IN sppv_tbl_type);
187
188 PROCEDURE validate_row(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_sppv_rec IN sppv_rec_type);
195
196 PROCEDURE validate_row(
197 p_api_version IN NUMBER,
198 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_sppv_tbl IN sppv_tbl_type);
203
204 END OKL_SPP_PVT;