1 PACKAGE okl_fe_std_rate_tmpl_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRSRTS.pls 120.0 2005/07/07 10:43:04 viselvar noship $ */
3
4 -- record structures used in the package
5
6 SUBTYPE okl_srtv_rec IS okl_srt_pvt.okl_srtv_rec; -- standard rate template header record
7
8 SUBTYPE okl_srv_rec IS okl_srv_pvt.okl_srv_rec; -- standard rate template version record
9
10 SUBTYPE okl_ech_rec IS okl_ech_pvt.okl_ech_rec; -- Eligibility Criteria set record
11
12 SUBTYPE okl_ecl_tbl IS okl_ecl_pvt.okl_ecl_tbl; -- Eligibility Criteria table
13
14 SUBTYPE okl_ecv_tbl IS okl_ecv_pvt.okl_ecv_tbl; -- Eligibility Criterion values table
15
16 TYPE okl_number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
17
18 SUBTYPE okl_lrs_id_tbl IS okl_lease_rate_Sets_pvt.okl_number_table;
19
20 TYPE invalid_object_rec IS RECORD (
21 obj_id NUMBER,
22 obj_name VARCHAR2(240),
23 obj_version VARCHAR2(24),
24 obj_type VARCHAR2(20)
25 );
26
27 TYPE invalid_object_tbl IS TABLE OF invalid_object_rec
28 INDEX BY BINARY_INTEGER;
29
30 ------------------------------------------------------------------------------
31 -- Global Variables
32
33 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_STD_RATE_TMPL_PVT';
34 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
35 g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
36 g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
37 g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
38 g_invalid_value CONSTANT VARCHAR2(200) := okl_api.g_invalid_value;
39 g_col_name_token CONSTANT VARCHAR2(200) := okl_api.g_col_name_token;
40
41 ------------------------------------------------------------------------------
42 --Global Exception
43 ------------------------------------------------------------------------------
44
45 g_exception_halt_validation EXCEPTION;
46
47 ------------------------------------------------------------------------------
48 -- procedure to give the details of the Standard Rate Template given the Standard
49 -- Rate Template id and the version number
50
51 PROCEDURE get_version(p_api_version IN NUMBER
52 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_srt_id IN NUMBER
57 ,p_version_number IN NUMBER
58 ,x_srtv_rec OUT NOCOPY okl_srtv_rec
59 ,x_srv_rec OUT NOCOPY okl_srv_rec
60 ,x_ech_rec OUT NOCOPY okl_ech_rec
61 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
62 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
63
64 -- procedure to give the details of the latest version of Standard Rate Template
65 -- given the Standard Rate Template id
66
67 PROCEDURE get_version(p_api_version IN NUMBER
68 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
69 ,x_return_status OUT NOCOPY VARCHAR2
70 ,x_msg_count OUT NOCOPY NUMBER
71 ,x_msg_data OUT NOCOPY VARCHAR2
72 ,p_srt_id IN NUMBER
73 ,x_srtv_rec OUT NOCOPY okl_srtv_rec
74 ,x_srv_rec OUT NOCOPY okl_srv_rec
75 ,x_ech_rec OUT NOCOPY okl_ech_rec
76 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
77 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
78
79 -- procedure to create a new version of the Standard Rate Template
80
81 PROCEDURE create_version(p_api_version IN NUMBER
82 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
83 ,x_return_status OUT NOCOPY VARCHAR2
84 ,x_msg_count OUT NOCOPY NUMBER
85 ,x_msg_data OUT NOCOPY VARCHAR2
86 ,p_srv_rec IN okl_srv_rec
87 ,x_srv_rec OUT NOCOPY okl_srv_rec);
88
89 --procedure to create a Standard Rate Template with the associated Eligibility Criteria
90
91 PROCEDURE insert_srt(p_api_version IN NUMBER
92 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 ,p_srtv_rec IN okl_srtv_rec
97 ,p_srv_rec IN okl_srv_rec
98 ,x_srtv_rec OUT NOCOPY okl_srtv_rec
99 ,x_srv_rec OUT NOCOPY okl_srv_rec);
100
101 -- procedure to update a particular version of the Standard Rate Template
102
103 PROCEDURE update_srt(p_api_version IN NUMBER
104 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,p_srv_rec IN okl_srv_rec
109 ,x_srv_rec OUT NOCOPY okl_srv_rec);
110
111 -- procedure to raise the workflow which submits the record and changes the status.
112
113 PROCEDURE submit_srt(p_api_version IN NUMBER
114 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
115 ,x_return_status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_data OUT NOCOPY VARCHAR2
118 ,p_version_id IN NUMBER);
119
120 -- procedure to handle when the process is going through the process of approval
121
122 PROCEDURE handle_approval(p_api_version IN NUMBER
123 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
124 ,x_return_status OUT NOCOPY VARCHAR2
125 ,x_msg_count OUT NOCOPY NUMBER
126 ,x_msg_data OUT NOCOPY VARCHAR2
127 ,p_version_id IN NUMBER);
128
129 -- procedure to set the default Standard Rate Template
130
131 PROCEDURE update_default(p_api_version IN NUMBER
132 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,x_msg_data OUT NOCOPY VARCHAR2
136 ,p_srt_id IN NUMBER);
137
138 -- to find the list of all the invalid object refernces
139
140 PROCEDURE invalid_objects(p_api_version IN NUMBER
141 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
142 ,x_return_status OUT NOCOPY VARCHAR2
143 ,x_msg_count OUT NOCOPY NUMBER
144 ,x_msg_data OUT NOCOPY VARCHAR2
145 ,p_version_id IN NUMBER
146 ,x_obj_tbl OUT NOCOPY invalid_object_tbl);
147
148 -- to calculate the start date of the new version
149
150 PROCEDURE calc_start_date(p_api_version IN NUMBER
151 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_srv_rec IN okl_srv_rec
156 ,x_cal_eff_from OUT NOCOPY DATE);
157
158 PROCEDURE enddate_std_rate_tmpl(p_api_version IN NUMBER
159 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
160 ,x_return_status OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162 ,x_msg_data OUT NOCOPY VARCHAR2
163 ,p_srv_id_tbl IN okl_number_table
164 ,p_end_date IN DATE);
165
166 END okl_fe_std_rate_tmpl_pvt;