[Home] [Help]
PACKAGE: APPS.OKL_ITEM_RESIDUALS_PVT
Source
1 PACKAGE OKL_ITEM_RESIDUALS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRIRSS.pls 120.0 2005/07/07 22:12:07 smadhava noship $ */
3 -- Header record type
4 SUBTYPE okl_irhv_rec is okl_irh_pvt.okl_irhv_rec;
5 -- Version record type
6 SUBTYPE okl_icpv_rec is okl_icp_pvt.icpv_rec_type;
7 -- Lines record type
8 SUBTYPE okl_irv_tbl is okl_irv_pvt.okl_irv_tbl;
9
10 SUBTYPE okl_lrs_id_tbl is OKL_LEASE_RATE_SETS_PVT.OKL_NUMBER_TABLE;
11
12 TYPE lrs_ref_rec IS RECORD (
13 id OKL_LS_RT_FCTR_SETS_V.ID%TYPE,
14 NAME OKL_LS_RT_FCTR_SETS_V.NAME%TYPE,
15 version OKL_FE_RATE_SET_VERSIONS_V.VERSION_NUMBER%TYPE,
16 object_version_number OKL_FE_RATE_SET_VERSIONS_V.OBJECT_VERSION_NUMBER%TYPE );
17
18 TYPE lrs_ref_tbl IS TABLE OF lrs_ref_rec
19 INDEX BY BINARY_INTEGER;
20
21
22 -- Global Constants
23 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ITEM_RESIDUALS_PVT';
24 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
25 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
26 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
27 G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';
28 G_PROG_NAME_TOKEN CONSTANT VARCHAR2(9) := 'PROG_NAME';
29 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
30
31 G_CAT_ITEM CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_CAT_ITEM;
32 G_CAT_ITEM_CAT CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_CAT_ITEM_CAT;
33 G_CAT_RES_CAT CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_CAT_RES_CAT;
34
35 G_RESD_PERCENTAGE CONSTANT VARCHAR2(30) := OKL_IRH_PVT.G_RESD_PERCENTAGE;
36
37 G_STS_ACTIVE CONSTANT VARCHAR2(30) := 'ACTIVE';
38 G_STS_UNDER_REV CONSTANT VARCHAR2(30) := 'UNDER_REVISION';
39 G_STS_NEW CONSTANT VARCHAR2(30) := 'NEW';
40 G_STS_SUBMITTED CONSTANT VARCHAR2(30) := 'SUBMITTED';
41
42 PROCEDURE get_effective_date(
43 p_api_version IN NUMBER
44 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_item_resdl_ver_id IN NUMBER
49 , x_calc_date OUT NOCOPY DATE
50 );
51 PROCEDURE create_irs (
52 p_api_version IN NUMBER
53 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
54 , x_return_status OUT NOCOPY VARCHAR2
55 , x_msg_count OUT NOCOPY NUMBER
56 , x_msg_data OUT NOCOPY VARCHAR2
57 , p_irhv_rec IN okl_irhv_rec
58 , p_icpv_rec IN okl_icpv_rec
59 , p_irv_tbl IN okl_irv_tbl
60 , x_irhv_rec OUT NOCOPY okl_irhv_rec
61 , x_icpv_rec OUT NOCOPY okl_icpv_rec
62 );
63
64 PROCEDURE update_version_irs (
65 p_api_version IN NUMBER
66 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
67 , x_return_status OUT NOCOPY VARCHAR2
68 , x_msg_count OUT NOCOPY NUMBER
69 , x_msg_data OUT NOCOPY VARCHAR2
70 , p_irhv_rec IN okl_irhv_rec
71 , p_icpv_rec IN okl_icpv_rec
72 , p_irv_tbl IN okl_irv_tbl
73 , x_irhv_rec OUT NOCOPY okl_irhv_rec
74 , x_icpv_rec OUT NOCOPY okl_icpv_rec
75 );
76 procedure create_version_irs (
77 p_api_version IN NUMBER
78 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_irhv_rec IN okl_irhv_rec
83 , p_icpv_rec IN okl_icpv_rec
84 , p_irv_tbl IN okl_irv_tbl
85 , x_irhv_rec OUT NOCOPY okl_irhv_rec
86 , x_icpv_rec OUT NOCOPY okl_icpv_rec
87 );
88
89 PROCEDURE change_LRS_sts (
90 p_api_version IN NUMBER
91 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_confirm_yn IN VARCHAR2
96 , p_icpv_rec IN okl_icpv_rec
97 , x_lrs_list OUT NOCOPY lrs_ref_tbl
98 , x_change_sts OUT NOCOPY VARCHAR2
99 );
100 PROCEDURE activate_item_residual(
101 p_api_version IN NUMBER
102 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
103 , x_return_status OUT NOCOPY VARCHAR2
104 , x_msg_count OUT NOCOPY NUMBER
105 , x_msg_data OUT NOCOPY VARCHAR2
106 , p_item_resdl_version_id IN NUMBER
107 );
108
109 PROCEDURE remove_terms(
110 p_api_version IN NUMBER
111 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
112 , x_return_status OUT NOCOPY VARCHAR2
113 , x_msg_count OUT NOCOPY NUMBER
114 , x_msg_data OUT NOCOPY VARCHAR2
115 , p_irv_tbl IN okl_irv_tbl);
116 PROCEDURE create_irs_submit (
117 p_api_version IN NUMBER
118 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
119 , x_return_status OUT NOCOPY VARCHAR2
120 , x_msg_count OUT NOCOPY NUMBER
121 , x_msg_data OUT NOCOPY VARCHAR2
122 , p_irhv_rec IN okl_irhv_rec
123 , p_icpv_rec IN okl_icpv_rec
124 , p_irv_tbl IN okl_irv_tbl
125 , x_irhv_rec OUT NOCOPY okl_irhv_rec
126 , x_icpv_rec OUT NOCOPY okl_icpv_rec
127 );
128 PROCEDURE update_version_irs_submit (
129 p_api_version IN NUMBER
130 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
131 , x_return_status OUT NOCOPY VARCHAR2
132 , x_msg_count OUT NOCOPY NUMBER
133 , x_msg_data OUT NOCOPY VARCHAR2
134 , p_irhv_rec IN okl_irhv_rec
135 , p_icpv_rec IN okl_icpv_rec
136 , p_irv_tbl IN okl_irv_tbl
137 , x_irhv_rec OUT NOCOPY okl_irhv_rec
138 , x_icpv_rec OUT NOCOPY okl_icpv_rec
139 );
140 PROCEDURE create_version_irs_submit (
141 p_api_version IN NUMBER
142 , p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
143 , x_return_status OUT NOCOPY VARCHAR2
144 , x_msg_count OUT NOCOPY NUMBER
145 , x_msg_data OUT NOCOPY VARCHAR2
146 , p_irhv_rec IN okl_irhv_rec
147 , p_icpv_rec IN okl_icpv_rec
148 , p_irv_tbl IN okl_irv_tbl
149 , x_irhv_rec OUT NOCOPY okl_irhv_rec
150 , x_icpv_rec OUT NOCOPY okl_icpv_rec
151 );
152 PROCEDURE submit_item_residual(
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_itm_rsdl_version_id IN OKL_ITM_CAT_RV_PRCS_V.ID%TYPE
159 );
160 END OKL_ITEM_RESIDUALS_PVT;