[Home] [Help]
PACKAGE: APPS.OKL_QQH_PVT
Source
1 PACKAGE OKL_QQH_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSQQHS.pls 120.1 2005/12/28 09:30:47 abhsaxen noship $ */
3
4 --------------------
5 -- PACKAGE CONSTANTS
6 --------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_QQH_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(30) := OKL_API.G_APP_NAME;
9 G_API_VERSION CONSTANT NUMBER := 1;
10 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
11 G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
12 G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
13 G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
14 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
15 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
16 G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
17 G_DB_ERROR CONSTANT VARCHAR2(30) := 'OKL_DB_ERROR';
18 G_COL_ERROR CONSTANT VARCHAR2(30) := 'OKL_COL_ERROR';
19 G_OVN_ERROR CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR';
20 G_OVN_ERROR2 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR2';
21 G_OVN_ERROR3 CONSTANT VARCHAR2(30) := 'OKL_OVN_ERROR3';
22 G_PKG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PKG_NAME';
23 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(30) := 'PROG_NAME';
24 G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := 'COL_NAME';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLCODE';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLERRM';
27
28 ------------------
29 -- DATA STRUCTURES
30 ------------------
31
32 -- Do not include WHO columns in the base table record structure
33 TYPE qqh_rec_type IS RECORD (
34 id okl_quick_quotes_b.id%TYPE
35 ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
36 ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
37 ,attribute1 okl_quick_quotes_b.attribute1%TYPE
38 ,attribute2 okl_quick_quotes_b.attribute2%TYPE
39 ,attribute3 okl_quick_quotes_b.attribute3%TYPE
40 ,attribute4 okl_quick_quotes_b.attribute4%TYPE
41 ,attribute5 okl_quick_quotes_b.attribute5%TYPE
42 ,attribute6 okl_quick_quotes_b.attribute6%TYPE
43 ,attribute7 okl_quick_quotes_b.attribute7%TYPE
44 ,attribute8 okl_quick_quotes_b.attribute8%TYPE
45 ,attribute9 okl_quick_quotes_b.attribute9%TYPE
46 ,attribute10 okl_quick_quotes_b.attribute10%TYPE
47 ,attribute11 okl_quick_quotes_b.attribute11%TYPE
48 ,attribute12 okl_quick_quotes_b.attribute12%TYPE
49 ,attribute13 okl_quick_quotes_b.attribute13%TYPE
50 ,attribute14 okl_quick_quotes_b.attribute14%TYPE
51 ,attribute15 okl_quick_quotes_b.attribute15%TYPE
52 ,reference_number okl_quick_quotes_b.reference_number%TYPE
53 ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
54 ,org_id okl_quick_quotes_b.org_id%TYPE
55 ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
56 ,currency_code okl_quick_quotes_b.currency_code%TYPE
57 ,term okl_quick_quotes_b.term%TYPE
58 ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
59 ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
60 ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
61 ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
62 ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
63 ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
64 ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
65 ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
66 ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
67 ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
68 ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
69 ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
70 ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
71 ,target_rate okl_quick_quotes_b.target_rate%TYPE
72 ,target_amount okl_quick_quotes_b.target_amount%TYPE
73 ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
74 ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
75 ,target_periods okl_quick_quotes_b.target_periods%TYPE
76 ,iir okl_quick_quotes_b.iir%TYPE
77 ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
78 ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
79 ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
80 ,pirr okl_quick_quotes_b.pirr%TYPE
81 ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
82 ,airr okl_quick_quotes_b.airr%TYPE
83 ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
84 -- abhsaxen - added - start
85 ,sts_code okl_quick_quotes_b.sts_code%TYPE
86 -- abhsaxen - added - end
87 );
88
89 -- Do not include WHO, LANGUAGE and SFWT_FLAG columns in the _TL record structure
90 TYPE qqhtl_rec_type IS RECORD (
91 id okl_quick_quotes_tl.id%TYPE
92 ,short_description okl_quick_quotes_tl.short_description%TYPE
93 ,description okl_quick_quotes_tl.description%TYPE
94 ,comments okl_quick_quotes_tl.comments%TYPE
95 );
96
97 -- view record structure
98 TYPE qqhv_rec_type IS RECORD (
99 id okl_quick_quotes_b.id%TYPE
100 ,object_version_number okl_quick_quotes_b.object_version_number%TYPE
101 ,attribute_category okl_quick_quotes_b.attribute_category%TYPE
102 ,attribute1 okl_quick_quotes_b.attribute1%TYPE
103 ,attribute2 okl_quick_quotes_b.attribute2%TYPE
104 ,attribute3 okl_quick_quotes_b.attribute3%TYPE
105 ,attribute4 okl_quick_quotes_b.attribute4%TYPE
106 ,attribute5 okl_quick_quotes_b.attribute5%TYPE
107 ,attribute6 okl_quick_quotes_b.attribute6%TYPE
108 ,attribute7 okl_quick_quotes_b.attribute7%TYPE
109 ,attribute8 okl_quick_quotes_b.attribute8%TYPE
110 ,attribute9 okl_quick_quotes_b.attribute9%TYPE
111 ,attribute10 okl_quick_quotes_b.attribute10%TYPE
112 ,attribute11 okl_quick_quotes_b.attribute11%TYPE
113 ,attribute12 okl_quick_quotes_b.attribute12%TYPE
114 ,attribute13 okl_quick_quotes_b.attribute13%TYPE
115 ,attribute14 okl_quick_quotes_b.attribute14%TYPE
116 ,attribute15 okl_quick_quotes_b.attribute15%TYPE
117 ,reference_number okl_quick_quotes_b.reference_number%TYPE
118 ,expected_start_date okl_quick_quotes_b.expected_start_date%TYPE
119 ,org_id okl_quick_quotes_b.org_id%TYPE
120 ,inv_org_id okl_quick_quotes_b.inv_org_id%TYPE
121 ,currency_code okl_quick_quotes_b.currency_code%TYPE
122 ,term okl_quick_quotes_b.term%TYPE
123 ,end_of_term_option_id okl_quick_quotes_b.end_of_term_option_id%TYPE
124 ,pricing_method okl_quick_quotes_b.pricing_method%TYPE
125 ,lease_opportunity_id okl_quick_quotes_b.lease_opportunity_id%TYPE
126 ,originating_vendor_id okl_quick_quotes_b.originating_vendor_id%TYPE
127 ,program_agreement_id okl_quick_quotes_b.program_agreement_id%TYPE
128 ,sales_rep_id okl_quick_quotes_b.sales_rep_id%TYPE
129 ,sales_territory_id okl_quick_quotes_b.sales_territory_id%TYPE
130 ,structured_pricing okl_quick_quotes_b.structured_pricing%TYPE
131 ,line_level_pricing okl_quick_quotes_b.line_level_pricing%TYPE
132 ,rate_template_id okl_quick_quotes_b.rate_template_id%TYPE
133 ,rate_card_id okl_quick_quotes_b.rate_card_id%TYPE
134 ,lease_rate_factor okl_quick_quotes_b.lease_rate_factor%TYPE
135 ,target_rate_type okl_quick_quotes_b.target_rate_type%TYPE
136 ,target_rate okl_quick_quotes_b.target_rate%TYPE
137 ,target_amount okl_quick_quotes_b.target_amount%TYPE
138 ,target_frequency okl_quick_quotes_b.target_frequency%TYPE
139 ,target_arrears okl_quick_quotes_b.target_arrears%TYPE
140 ,target_periods okl_quick_quotes_b.target_periods%TYPE
141 ,iir okl_quick_quotes_b.iir%TYPE
142 ,sub_iir okl_quick_quotes_b.sub_iir%TYPE
143 ,booking_yield okl_quick_quotes_b.booking_yield%TYPE
144 ,sub_booking_yield okl_quick_quotes_b.sub_booking_yield%TYPE
145 ,pirr okl_quick_quotes_b.pirr%TYPE
146 ,sub_pirr okl_quick_quotes_b.sub_pirr%TYPE
147 ,airr okl_quick_quotes_b.airr%TYPE
148 ,sub_airr okl_quick_quotes_b.sub_airr%TYPE
149 ,short_description okl_quick_quotes_tl.short_description%TYPE
150 ,description okl_quick_quotes_tl.description%TYPE
151 ,comments okl_quick_quotes_tl.comments%TYPE
152 -- abhsaxen - added - start
153 ,sts_code okl_quick_quotes_b.sts_code%TYPE
154 -- abhsaxen - added - end
155 );
156
157 TYPE qqhv_tbl_type IS TABLE OF qqhv_rec_type INDEX BY BINARY_INTEGER;
158
159 ----------------
160 -- PROGRAM UNITS
161 ----------------
162 PROCEDURE add_language;
163
164 PROCEDURE insert_row(
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2,
167 x_return_status OUT NOCOPY VARCHAR2,
168 x_msg_count OUT NOCOPY NUMBER,
169 x_msg_data OUT NOCOPY VARCHAR2,
170 p_qqhv_tbl IN qqhv_tbl_type,
171 x_qqhv_tbl OUT NOCOPY qqhv_tbl_type);
172
173 PROCEDURE update_row(
174 p_api_version IN NUMBER,
175 p_init_msg_list IN VARCHAR2,
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179 p_qqhv_tbl IN qqhv_tbl_type,
180 x_qqhv_tbl OUT NOCOPY qqhv_tbl_type);
181
182 PROCEDURE delete_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_qqhv_tbl IN qqhv_tbl_type);
189
190 PROCEDURE insert_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_qqhv_rec IN qqhv_rec_type,
197 x_qqhv_rec OUT NOCOPY qqhv_rec_type);
198
199 PROCEDURE update_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_qqhv_rec IN qqhv_rec_type,
206 x_qqhv_rec OUT NOCOPY qqhv_rec_type);
207
208 PROCEDURE delete_row(
209 p_api_version IN NUMBER,
210 p_init_msg_list IN VARCHAR2,
211 x_return_status OUT NOCOPY VARCHAR2,
212 x_msg_count OUT NOCOPY NUMBER,
213 x_msg_data OUT NOCOPY VARCHAR2,
214 p_qqhv_rec IN qqhv_rec_type);
215
216 END OKL_QQH_PVT;