[Home] [Help]
PACKAGE: APPS.OKL_DEAL_ASSET_PVT
Source
1 Package OKL_DEAL_ASSET_PVT AUTHID CURRENT_USER as
2 /* $Header: OKLRDASS.pls 120.3 2010/05/20 09:20:34 rpillay ship $ */
3
4 -------------------------------------------------------------------------------------------------
5 -- COMPOSITE VARIABLES
6 -------------------------------------------------------------------------------------------------
7 TYPE las_rec_type IS RECORD (deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE,
8 inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
9 inventory_org_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
10 inventory_item_name MTL_SYSTEM_ITEMS_TL.DESCRIPTION%TYPE,
11 release_asset_flag BOOLEAN,
12 asset_id FA_ADDITIONS_B.ASSET_ID%TYPE,
13 asset_number FA_ADDITIONS_B.ASSET_NUMBER%TYPE,
14 description FA_ADDITIONS_TL.DESCRIPTION%TYPE,
15 unit_cost OKC_K_LINES_B.PRICE_UNIT%TYPE,
16 units NUMBER,
17 old_units NUMBER,
18 model_number OKL_K_LINES.MODEL_NUMBER%TYPE,
19 manufacturer_name OKL_TXL_ASSETS_B.MANUFACTURER_NAME%TYPE,
20 year_manufactured OKL_TXL_ASSETS_B.YEAR_MANUFACTURED%TYPE,
21 party_site_use_id NUMBER,
22 party_site_name VARCHAR2(2000), --Bug# 9721029
23 fa_location_id OKL_TXL_ASSETS_B.FA_LOCATION_ID%TYPE,
24 fa_location_name VARCHAR2(2000), --Bug# 9721029
25 asset_key_id OKL_TXL_ASSETS_B.ASSET_KEY_ID%TYPE,
26 asset_key_name VARCHAR2(2000), --Bug# 9721029
27 prescribed_asset_yn OKL_K_LINES.PRESCRIBED_ASSET_YN%TYPE,
28 date_delivery_expected OKL_K_LINES.DATE_DELIVERY_EXPECTED%TYPE,
29 date_funding_expected OKL_K_LINES.DATE_FUNDING_EXPECTED%TYPE,
30 residual_percentage OKL_K_LINES.RESIDUAL_PERCENTAGE%TYPE,
31 residual_value OKL_K_LINES.RESIDUAL_VALUE%TYPE,
32 residual_code OKL_K_LINES.RESIDUAL_CODE%TYPE,
33 guranteed_amount OKL_K_LINES.RESIDUAL_GRNTY_AMOUNT%TYPE,
34 rvi_premium OKL_K_LINES.RVI_PREMIUM%TYPE,
35 currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE,
36 dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE,
37 clev_fin_id OKC_K_LINES_B.ID%TYPE,
38 clev_model_id OKC_K_LINES_B.ID%TYPE,
39 clev_fa_id OKC_K_LINES_B.ID%TYPE,
40 clev_ib_id OKC_K_LINES_B.ID%TYPE,
41 -- gboomina added tal_id to populate corp deprn id
42 -- while creating asset and corp book deprn together.
43 tal_id OKL_TXL_ASSETS_B.ID%TYPE,
44 attribute_category OKL_K_LINES.ATTRIBUTE_CATEGORY%TYPE,
45 attribute1 OKL_K_LINES.ATTRIBUTE1%TYPE,
46 attribute2 OKL_K_LINES.ATTRIBUTE2%TYPE,
47 attribute3 OKL_K_LINES.ATTRIBUTE3%TYPE,
48 attribute4 OKL_K_LINES.ATTRIBUTE4%TYPE,
49 attribute5 OKL_K_LINES.ATTRIBUTE5%TYPE,
50 attribute6 OKL_K_LINES.ATTRIBUTE6%TYPE,
51 attribute7 OKL_K_LINES.ATTRIBUTE7%TYPE,
52 attribute8 OKL_K_LINES.ATTRIBUTE8%TYPE,
53 attribute9 OKL_K_LINES.ATTRIBUTE9%TYPE,
54 attribute10 OKL_K_LINES.ATTRIBUTE10%TYPE,
55 attribute11 OKL_K_LINES.ATTRIBUTE11%TYPE,
56 attribute12 OKL_K_LINES.ATTRIBUTE12%TYPE,
57 attribute13 OKL_K_LINES.ATTRIBUTE13%TYPE,
58 attribute14 OKL_K_LINES.ATTRIBUTE14%TYPE,
59 attribute15 OKL_K_LINES.ATTRIBUTE15%TYPE);
60
61 TYPE addon_rec_type IS RECORD (
62 cleb_addon_id OKC_K_LINES_B.ID%TYPE,
63 dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE,
64 price_unit OKC_K_LINES_B.price_unit%TYPE,
65 inventory_item_id MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID%TYPE,
66 inventory_org_id MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID%TYPE,
67 jtot_object1_code OKC_K_ITEMS.jtot_object1_code%TYPE,
68 number_of_items OKC_K_ITEMS.number_of_items%TYPE,
69 manufacturer_name OKL_K_LINES.manufacturer_name%TYPE,
70 model_number OKL_K_LINES.model_number%TYPE,
71 year_of_manufacture OKL_K_LINES.year_of_manufacture%TYPE,
72 vendor_name PO_VENDORS.vendor_name%TYPE,
73 party_role_id OKC_K_PARTY_ROLES_B.cpl_id%TYPE,
74 vendor_id OKC_K_PARTY_ROLES_B.object1_id1%TYPE,
75 object1_id2 OKC_K_PARTY_ROLES_B.object1_id2%TYPE,
76 rle_code OKC_K_PARTY_ROLES_B.rle_code%TYPE,
77 comments OKC_K_LINES_TL.comments%TYPE);
78
79 TYPE addon_tbl_type IS TABLE OF addon_rec_type INDEX BY BINARY_INTEGER;
80
81 TYPE down_payment_rec_type IS RECORD (
82 cleb_fin_id OKC_K_LINES_B.id%TYPE,
83 dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE,
84 asset_number OKC_K_LINES_TL.name%TYPE,
85 asset_cost OKL_K_LINES.oec%TYPE,
86 description OKC_K_LINES_TL.item_description%TYPE,
87 basis FND_LOOKUPS.lookup_code%TYPE,
88 down_payment OKL_K_LINES.capital_reduction%TYPE,
89 down_payment_receiver_code OKL_K_LINES.down_payment_receiver_code%TYPE,
90 capitalize_down_payment_yn OKL_K_LINES.capitalize_down_payment_yn%TYPE);
91
92 TYPE down_payment_tbl_type IS TABLE OF down_payment_rec_type INDEX BY BINARY_INTEGER;
93
94 TYPE tradein_rec_type is record
95 (
96 cleb_fin_id OKC_K_LINES_B.id%TYPE,
97 dnz_chr_id OKC_K_LINES_B.dnz_chr_id%TYPE,
98 asset_number OKC_K_LINES_TL.name%TYPE,
99 asset_cost OKL_K_LINES.oec%TYPE,
100 description OKC_K_LINES_TL.item_description%TYPE,
101 tradein_amount OKL_K_LINES.tradein_amount%TYPE
102 );
103
104 TYPE tradein_tbl_type is table of tradein_rec_type INDEX BY BINARY_INTEGER;
105
106 PROCEDURE process_line_billing_setup(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_rgpv_rec IN OKL_DEAL_TERMS_PVT.billing_setup_rec_type,
113 x_rgpv_rec OUT NOCOPY OKL_DEAL_TERMS_PVT.billing_setup_rec_type);
114
115 PROCEDURE load_line_billing_setup(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_dnz_chr_id IN NUMBER,
122 p_cle_id IN NUMBER,
123 x_billing_setup_rec OUT NOCOPY OKL_DEAL_TERMS_PVT.billing_setup_rec_type);
124
125 PROCEDURE create_assetaddon_line(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_addon_rec IN addon_rec_type,
132 x_addon_rec OUT NOCOPY addon_rec_type);
133
134 PROCEDURE create_assetaddon_line(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_addon_tbl IN addon_tbl_type,
141 x_addon_tbl OUT NOCOPY addon_tbl_type);
142
143 PROCEDURE update_assetaddon_line(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_addon_rec IN addon_rec_type,
150 x_addon_rec OUT NOCOPY addon_rec_type);
151
152 PROCEDURE update_assetaddon_line(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_addon_tbl IN addon_tbl_type,
159 x_addon_tbl OUT NOCOPY addon_tbl_type);
160
161 PROCEDURE create_all_line(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_las_rec IN las_rec_type,
168 x_las_rec OUT NOCOPY las_rec_type);
169
170 PROCEDURE update_all_line(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_las_rec IN las_rec_type,
177 x_las_rec OUT NOCOPY las_rec_type);
178
179 PROCEDURE load_all_line(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_chr_id IN NUMBER,
186 p_clev_fin_id IN NUMBER,
187 x_las_rec OUT NOCOPY las_rec_type);
188
189 FUNCTION addon_ship_to_site_name(
190 p_site_use_id IN NUMBER
191 )
192 RETURN VARCHAR2;
193
194 PROCEDURE allocate_amount_tradein (
195 p_api_version IN NUMBER,
196 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_chr_id IN NUMBER,
201 p_tradein_amount IN NUMBER,
202 p_mode IN VARCHAR2,
203 x_tradein_tbl OUT NOCOPY tradein_tbl_type);
204
205 PROCEDURE allocate_amount_down_payment (
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_chr_id IN NUMBER,
212 p_down_payment IN NUMBER,
213 p_basis IN VARCHAR2,
214 p_mode IN VARCHAR2,
215 x_down_payment_tbl OUT NOCOPY down_payment_tbl_type);
216
217 FUNCTION get_subsidy_amount(
218 p_khr_id IN NUMBER,
219 p_subsidy_id IN NUMBER)
220 RETURN VARCHAR2;
221
222 FUNCTION get_down_payment_amount(
223 p_khr_id IN NUMBER)
224 RETURN VARCHAR2;
225
226 End OKL_DEAL_ASSET_PVT;