[Home] [Help]
PACKAGE: APPS.OKL_MASS_REBOOK_PUB
Source
1 PACKAGE OKL_MASS_REBOOK_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPMRPS.pls 115.5 2003/01/28 22:54:45 dedey noship $*/
3
4 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(1000) := 'OKL_UNEXPECTED_ERROR';
5 G_NOT_VALID_REQUEST CONSTANT VARCHAR2(1000) := 'OKL_LLA_NOT_VALID_RERQUEST';
6 G_INVALID_CRITERIA CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_CRITERIA';
7 G_FORMAT_ERROR CONSTANT VARCHAR2(1000) := 'OKL_LLA_FORMAT_ERROR';
8 G_NO_MATCH_FOUND CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_MATCH_FOUND';
9 G_INVALID_CODE CONSTANT VARCHAR2(1000) := 'OKL_LLA_INVALID_CODE';
10 G_DUPLICATE_REQUEST CONSTANT VARCHAR2(1000) := 'OKL_LLA_DUPLICATE_REQUEST';
11 G_NO_SEL_CONTRACT CONSTANT VARCHAR2(1000) := 'OKL_LLA_NO_SELECTED_CONTRACT';
12
13
14 SUBTYPE mrbv_rec_type IS okl_mass_rebook_pvt.mrbv_rec_type;
15 SUBTYPE mrbv_tbl_type IS okl_mass_rebook_pvt.mrbv_tbl_type;
16
17 SUBTYPE mstv_rec_type IS okl_mass_rebook_pvt.mstv_rec_type;
18 SUBTYPE mstv_tbl_type IS okl_mass_rebook_pvt.mstv_tbl_type;
19
20 subtype tcnv_rec_type IS okl_mass_rebook_pvt.tcnv_rec_type;
21
22 subtype thpv_rec_type IS okl_mass_rebook_pvt.thpv_rec_type;
23 subtype thpv_tbl_type IS okl_mass_rebook_pvt.thpv_tbl_type;
24
25 --
26 -- Order of Criteria Code in Table is important
27 -- It should be as follows, if present
28 --
29 -- CONTRACT_NUMBER, START_DATE, BOOK_TYPE_CODE, DEPRN_METHOD_CODE, DATE_PLACED_IN_SERVICE, ASSET_CATEGORY_ID
30 --
31 TYPE crit_rec_type IS RECORD (
32 LINE_NUMBER NUMBER,
33 CRITERIA_CODE VARCHAR2(30),
34 OPERAND VARCHAR2(150),
35 CRITERIA_VALUE1 VARCHAR2(150),
36 CRITERIA_VALUE2 VARCHAR2(150),
37 SET_VALUE VARCHAR2(150)
38 );
39
40 TYPE crit_tbl_type IS TABLE OF crit_rec_type INDEX BY BINARY_INTEGER;
41
42 SUBTYPE rbk_rec_type IS OKL_MASS_REBOOK_PVT.rbk_rec_type;
43 SUBTYPE rbk_tbl_type IS OKL_MASS_REBOOK_PVT.rbk_tbl_type;
44
45 SUBTYPE strm_lalevl_rec_type IS OKL_MASS_REBOOK_PVT.strm_lalevl_rec_type;
46 SUBTYPE strm_lalevl_tbl_type IS OKL_MASS_REBOOK_PVT.strm_lalevl_tbl_type;
47
48 SUBTYPE strm_trx_tbl_type IS OKL_MASS_REBOOK_PVT.strm_trx_tbl_type;
49
50 PROCEDURE build_and_get_contracts(
51 p_api_version IN NUMBER,
52 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2,
56 p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,
57 p_mrbv_tbl IN mrbv_tbl_type,
58 x_mstv_tbl OUT NOCOPY mstv_tbl_type,
59 x_rbk_count OUT NOCOPY NUMBER
60 );
61
62 PROCEDURE process_mass_rebook(
63 p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE
69 );
70 PROCEDURE apply_mass_rebook(
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_rbk_tbl IN rbk_tbl_type,
77 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
78 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
79 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
80 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
81 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
82 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
83 p_strm_lalevl_tbl IN strm_lalevl_tbl_type
84 );
85
86 PROCEDURE apply_mass_rebook(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_rbk_tbl IN rbk_tbl_type,
93 p_deprn_method_code IN FA_BOOKS.DEPRN_METHOD_CODE%TYPE,
94 p_in_service_date IN FA_BOOKS.DATE_PLACED_IN_SERVICE%TYPE,
95 p_life_in_months IN FA_BOOKS.LIFE_IN_MONTHS%TYPE,
96 p_basic_rate IN FA_BOOKS.BASIC_RATE%TYPE,
97 p_adjusted_rate IN FA_BOOKS.ADJUSTED_RATE%TYPE,
98 p_residual_value IN OKL_K_LINES_V.RESIDUAL_VALUE%TYPE,
99 p_strm_lalevl_tbl IN strm_lalevl_tbl_type,
100 x_stream_trx_tbl OUT NOCOPY strm_trx_tbl_type
101 );
102
103 PROCEDURE update_mass_rbk_contract(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_mstv_tbl IN MSTV_TBL_TYPE,
110 x_mstv_tbl OUT NOCOPY MSTV_TBL_TYPE
111 );
112
113 PROCEDURE mass_rebook_after_yield(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_chr_id IN OKC_K_HEADERS_V.ID%TYPE
120 );
121
122 END OKL_MASS_REBOOK_PUB;