eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_CREATE_KLE_PVT

Source


1 Package OKL_CREATE_KLE_PVT as
2 /* $Header: OKLRKLLS.pls 120.3 2007/09/19 17:57:31 rbruno ship $ */
3 
4   subtype klev_rec_type is OKL_CONTRACT_PUB.klev_rec_type;
5   subtype klev_tbl_type is OKL_CONTRACT_PUB.klev_tbl_type;
6   subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.clev_rec_type;
7   subtype clev_tbl_type is OKL_OKC_MIGRATION_PVT.clev_tbl_type;
8   subtype cimv_rec_type is OKL_OKC_MIGRATION_PVT.cimv_rec_type;
9   subtype cimv_tbl_type is OKL_OKC_MIGRATION_PVT.cimv_tbl_type;
10   subtype cplv_rec_type is OKL_OKC_MIGRATION_PVT.cplv_rec_type;
11   subtype trxv_rec_type is OKL_TRX_ASSETS_PUB.thpv_rec_type;
12   subtype talv_rec_type is OKL_TXL_ASSETS_PUB.tlpv_rec_type;
13   subtype itiv_rec_type is OKL_TXL_ITM_INSTS_PUB.iipv_rec_type;
14   subtype itiv_tbl_type is OKL_TXL_ITM_INSTS_PUB.iipv_tbl_type;
15   subtype txdv_tbl_type is OKL_TXD_ASSETS_PUB.adpv_tbl_type;
16   subtype txdv_rec_type is OKL_TXD_ASSETS_PUB.adpv_rec_type;
17   G_FIN_LINE_LTY_CODE                     OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
18   G_FIN_LINE_LTY_ID	                  OKC_LINE_STYLES_V.ID%TYPE := 33;
19   G_MODEL_LINE_LTY_CODE                   OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
20   G_MODEL_LINE_LTY_ID                     OKC_LINE_STYLES_V.ID%TYPE := 34;
21   G_ADDON_LINE_LTY_CODE                   OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
22   G_FA_LINE_LTY_CODE                      OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
23   G_FA_LINE_LTY_ID                        OKC_LINE_STYLES_V.ID%TYPE := 42;
24   G_INST_LINE_LTY_CODE                    OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
25   G_INST_LINE_LTY_ID                      OKC_LINE_STYLES_V.ID%TYPE := 43;
26   G_IB_LINE_LTY_CODE                      OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
27   G_IB_LINE_LTY_ID                        OKC_LINE_STYLES_V.ID%TYPE := 45;
28 
29   PROCEDURE Update_fin_cap_cost(
30             p_api_version    IN  NUMBER,
31             p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
32             x_return_status  OUT NOCOPY VARCHAR2,
33             x_msg_count      OUT NOCOPY NUMBER,
34             x_msg_data       OUT NOCOPY VARCHAR2,
35             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
36             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
37             p_clev_rec       IN  clev_rec_type,
38             p_klev_rec       IN  klev_rec_type,
39             x_clev_rec       OUT NOCOPY clev_rec_type,
40             x_klev_rec       OUT NOCOPY klev_rec_type);
41 
42   Procedure Create_add_on_line(
43             p_api_version     IN  NUMBER,
44             p_init_msg_list   IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
45             x_return_status   OUT NOCOPY VARCHAR2,
46             x_msg_count       OUT NOCOPY NUMBER,
47             x_msg_data        OUT NOCOPY VARCHAR2,
48             P_new_yn          IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
49             p_asset_number    IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
50             p_clev_tbl        IN  clev_tbl_type,
51             p_klev_tbl        IN  klev_tbl_type,
52             p_cimv_tbl        IN  cimv_tbl_type,
53             x_clev_tbl        OUT NOCOPY clev_tbl_type,
54             x_klev_tbl        OUT NOCOPY klev_tbl_type,
55             x_fin_clev_rec    OUT NOCOPY clev_rec_type,
56             x_fin_klev_rec    OUT NOCOPY klev_rec_type,
57             x_cimv_tbl        OUT NOCOPY cimv_tbl_type);
58 
59   PROCEDURE update_add_on_line(
60             p_api_version   IN NUMBER,
61             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
62             x_return_status  OUT NOCOPY VARCHAR2,
63             x_msg_count      OUT NOCOPY NUMBER,
64             x_msg_data       OUT NOCOPY VARCHAR2,
65             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
66             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
67             p_clev_tbl       IN  clev_tbl_type,
68             p_klev_tbl       IN  klev_tbl_type,
69             p_cimv_tbl       IN  cimv_tbl_type,
70             x_clev_tbl       OUT NOCOPY clev_tbl_type,
71             x_klev_tbl       OUT NOCOPY klev_tbl_type,
72             x_cimv_tbl       OUT NOCOPY cimv_tbl_type,
73             x_fin_clev_rec   OUT NOCOPY clev_rec_type,
74             x_fin_klev_rec   OUT NOCOPY klev_rec_type);
75 
76   PROCEDURE delete_add_on_line(
77             p_api_version    IN  NUMBER,
78             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
79             x_return_status  OUT NOCOPY VARCHAR2,
80             x_msg_count      OUT NOCOPY NUMBER,
81             x_msg_data       OUT NOCOPY VARCHAR2,
82             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
83             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
84             p_clev_tbl       IN  clev_tbl_type,
85             p_klev_tbl       IN  klev_tbl_type,
86             x_fin_clev_rec   OUT NOCOPY clev_rec_type,
87             x_fin_klev_rec   OUT NOCOPY klev_rec_type);
88 
89   PROCEDURE Create_party_roles_rec(
90             p_api_version    IN  NUMBER,
91             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
92             x_return_status  OUT NOCOPY VARCHAR2,
93             x_msg_count      OUT NOCOPY NUMBER,
94             x_msg_data       OUT NOCOPY VARCHAR2,
95             p_cplv_rec       IN  cplv_rec_type,
96             x_cplv_rec       OUT NOCOPY cplv_rec_type);
97 
98   PROCEDURE Update_party_roles_rec(
99             p_api_version    IN  NUMBER,
100             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
101             x_return_status  OUT NOCOPY VARCHAR2,
102             x_msg_count      OUT NOCOPY NUMBER,
103             x_msg_data       OUT NOCOPY VARCHAR2,
104             p_cplv_rec       IN  cplv_rec_type,
105             x_cplv_rec       OUT NOCOPY cplv_rec_type);
106 
107   PROCEDURE Create_all_line(
108             p_api_version    IN  NUMBER,
109             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
110             x_return_status  OUT NOCOPY VARCHAR2,
111             x_msg_count      OUT NOCOPY NUMBER,
112             x_msg_data       OUT NOCOPY VARCHAR2,
113             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
114             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
115             p_clev_fin_rec   IN  clev_rec_type,
116             p_klev_fin_rec   IN  klev_rec_type,
117             p_cimv_model_rec IN  cimv_rec_type,
118             p_clev_fa_rec    IN  clev_rec_type,
119             p_cimv_fa_rec    IN  cimv_rec_type,
120             p_talv_fa_rec    IN  talv_rec_type,
121             p_itiv_ib_tbl    IN  itiv_tbl_type,
122             x_clev_fin_rec   OUT NOCOPY clev_rec_type,
123             x_clev_model_rec OUT NOCOPY clev_rec_type,
124             x_clev_fa_rec    OUT NOCOPY clev_rec_type,
125             x_clev_ib_rec    OUT NOCOPY clev_rec_type);
126 
127   PROCEDURE Update_all_line(
128             p_api_version    IN  NUMBER,
129             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
130             x_return_status  OUT NOCOPY VARCHAR2,
131             x_msg_count      OUT NOCOPY NUMBER,
132             x_msg_data       OUT NOCOPY VARCHAR2,
133             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
134             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
135             p_clev_fin_rec   IN  clev_rec_type,
136             p_klev_fin_rec   IN  klev_rec_type,
137             p_clev_model_rec IN  clev_rec_type,
138             p_cimv_model_rec IN  cimv_rec_type,
139             p_clev_fa_rec    IN  clev_rec_type,
140             p_cimv_fa_rec    IN  cimv_rec_type,
141             p_talv_fa_rec    IN  talv_rec_type,
142             p_clev_ib_rec    IN  clev_rec_type,
143             p_itiv_ib_rec    IN  itiv_rec_type,
144             x_clev_fin_rec   OUT NOCOPY clev_rec_type,
145             x_clev_model_rec OUT NOCOPY clev_rec_type,
146             x_clev_fa_rec    OUT NOCOPY clev_rec_type,
147             x_clev_ib_rec    OUT NOCOPY clev_rec_type);
148 
149   PROCEDURE create_ints_ib_line(
150             p_api_version    IN  NUMBER,
151             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
152             x_return_status  OUT NOCOPY VARCHAR2,
153             x_msg_count      OUT NOCOPY NUMBER,
154             x_msg_data       OUT NOCOPY VARCHAR2,
155             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
156             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
157             p_current_units  IN  OKL_TXL_ASSETS_V.CURRENT_UNITS%TYPE,
158             p_clev_ib_rec    IN  clev_rec_type,
159             p_itiv_ib_tbl    IN  itiv_tbl_type,
160             x_clev_ib_tbl    OUT NOCOPY clev_tbl_type,
161             x_itiv_ib_tbl    OUT NOCOPY itiv_tbl_type,
162             x_clev_fin_rec   OUT NOCOPY clev_rec_type,
163             x_klev_fin_rec   OUT NOCOPY klev_rec_type,
164             x_cimv_model_rec OUT NOCOPY cimv_rec_type,
165             x_cimv_fa_rec    OUT NOCOPY cimv_rec_type,
166             x_talv_fa_rec    OUT NOCOPY talv_rec_type);
167 
168   PROCEDURE update_ints_ib_line(
169             p_api_version    IN  NUMBER,
170             p_init_msg_list  IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
171             x_return_status  OUT NOCOPY VARCHAR2,
172             x_msg_count      OUT NOCOPY NUMBER,
173             x_msg_data       OUT NOCOPY VARCHAR2,
174             P_new_yn         IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
175             p_asset_number   IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
176             p_top_line_id    IN  OKC_K_LINES_V.ID%TYPE,
177             p_dnz_chr_id     IN  OKC_K_HEADERS_V.ID%TYPE,
178             p_itiv_ib_tbl    IN  itiv_tbl_type,
179             x_clev_ib_tbl    OUT NOCOPY clev_tbl_type,
180             x_itiv_ib_tbl    OUT NOCOPY itiv_tbl_type);
181 
182   PROCEDURE delete_ints_ib_line(
183             p_api_version         IN  NUMBER,
184             p_init_msg_list       IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
185             x_return_status       OUT NOCOPY VARCHAR2,
186             x_msg_count           OUT NOCOPY NUMBER,
187             x_msg_data            OUT NOCOPY VARCHAR2,
188             P_new_yn              IN  OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,
189             p_asset_number        IN  OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
190             p_clev_ib_tbl         IN  clev_tbl_type,
191             x_clev_fin_rec        OUT NOCOPY clev_rec_type,
192             x_klev_fin_rec        OUT NOCOPY klev_rec_type,
193             x_cimv_model_rec      OUT NOCOPY cimv_rec_type,
194             x_cimv_fa_rec         OUT NOCOPY cimv_rec_type,
195             x_talv_fa_rec         OUT NOCOPY talv_rec_type);
196 
197   PROCEDURE Create_asset_line_details(
198             p_api_version    IN  NUMBER,
199             p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
200             x_return_status  OUT NOCOPY VARCHAR2,
201             x_msg_count      OUT NOCOPY NUMBER,
202             x_msg_data       OUT NOCOPY VARCHAR2,
203             p_txdv_tbl       IN  txdv_tbl_type,
204             x_txdv_tbl       OUT NOCOPY txdv_tbl_type);
205 
206   PROCEDURE update_asset_line_details(
207             p_api_version    IN  NUMBER,
208             p_init_msg_list  IN  VARCHAR2 DEFAULT OKL_API.G_FALSE,
209             x_return_status  OUT NOCOPY VARCHAR2,
210             x_msg_count      OUT NOCOPY NUMBER,
211             x_msg_data       OUT NOCOPY VARCHAR2,
212             p_txdv_tbl       IN  txdv_tbl_type,
213             x_txdv_tbl       OUT NOCOPY txdv_tbl_type);
214 
215  --rbruno bug 6185552 start
216     PROCEDURE get_nbv(p_api_version     IN  NUMBER,
217                     p_init_msg_list   IN  VARCHAR2,
218                     x_return_status   OUT NOCOPY VARCHAR2,
219                     x_msg_count       OUT NOCOPY NUMBER,
220                     x_msg_data        OUT NOCOPY VARCHAR2,
221                     p_asset_id        IN  NUMBER,
222                     p_book_type_code  IN  VARCHAR2,
223                     p_chr_id          IN  NUMBER,
224                     p_release_date    IN  DATE,
225                     x_nbv             OUT NOCOPY Number);
226  --rbruno bug 6185552 end
227 
228 End OKL_CREATE_KLE_PVT;