1 PACKAGE okl_fe_std_rate_tmpl_pub AS
2 /* $Header: OKLPSRTS.pls 120.0 2005/07/07 10:42:03 viselvar noship $ */
3
4 -- record structures used in the package
5
6 SUBTYPE okl_srtv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srtv_rec; -- standard rate template header record
7
8 SUBTYPE okl_srv_rec IS okl_fe_std_rate_tmpl_pvt.okl_srv_rec; -- standard rate template version record
9
10 SUBTYPE okl_ech_rec IS okl_fe_std_rate_tmpl_pvt.okl_ech_rec; -- Eligibility Criteria set record
11
12 SUBTYPE okl_ecl_tbl IS okl_fe_std_rate_tmpl_pvt.okl_ecl_tbl; -- Eligibility Criteria table
13
14 SUBTYPE okl_ecv_tbl IS okl_fe_std_rate_tmpl_pvt.okl_ecv_tbl; -- Eligibility Criterion values table
15
16 SUBTYPE invalid_object_tbl IS okl_fe_std_rate_tmpl_pvt.invalid_object_tbl;
17
18 ------------------------------------------------------------------------------
19 -- Global Variables
20
21 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_STD_RATE_TMP_PUB';
22 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
23 g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
24 g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
25 g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
26
27 ------------------------------------------------------------------------------
28 --Global Exception
29 ------------------------------------------------------------------------------
30
31 g_exception_halt_validation EXCEPTION;
32
33 ------------------------------------------------------------------------------
34 -- procedure to give the details of the Standard Rate Template
35 --given the Standard Rate Template id and the version number
36
37 PROCEDURE get_version(p_api_version IN NUMBER
38 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
39 ,x_return_status OUT NOCOPY VARCHAR2
40 ,x_msg_count OUT NOCOPY NUMBER
41 ,x_msg_data OUT NOCOPY VARCHAR2
42 ,p_srt_id IN NUMBER
43 ,p_version_number IN NUMBER
44 ,x_srtv_rec OUT NOCOPY okl_srtv_rec
45 ,x_srv_rec OUT NOCOPY okl_srv_rec
46 ,x_ech_rec OUT NOCOPY okl_ech_rec
47 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
48 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
49
50 -- procedure to give the details of the latest version of Standard Rate Template
51 -- given the Standard Rate Template Id
52
53 PROCEDURE get_version(p_api_version IN NUMBER
54 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
55 ,x_return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 ,p_srt_id IN NUMBER
59 ,x_srtv_rec OUT NOCOPY okl_srtv_rec
60 ,x_srv_rec OUT NOCOPY okl_srv_rec
61 ,x_ech_rec OUT NOCOPY okl_ech_rec
62 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
63 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
64
65 -- procedure to create a new version of the Standard Rate Template
66
67 PROCEDURE create_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_srv_rec IN okl_srv_rec
73 ,x_srv_rec OUT NOCOPY okl_srv_rec);
74
75 --procedure to create a Standard Rate Template with the associated Eligibility Criteria
76
77 PROCEDURE insert_srt(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_srtv_rec IN okl_srtv_rec
83 ,p_srv_rec IN okl_srv_rec
84 ,x_srtv_rec OUT NOCOPY okl_srtv_rec
85 ,x_srv_rec OUT NOCOPY okl_srv_rec);
86
87 -- procedure to update a particular version of the Standard Rate Template
88
89 PROCEDURE update_srt(p_api_version IN NUMBER
90 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
91 ,x_return_status OUT NOCOPY VARCHAR2
92 ,x_msg_count OUT NOCOPY NUMBER
93 ,x_msg_data OUT NOCOPY VARCHAR2
94 ,p_srv_rec IN okl_srv_rec
95 ,x_srv_rec OUT NOCOPY okl_srv_rec);
96
97 -- procedure to raise the workflow which submits the record and changes the status.
98
99 PROCEDURE submit_srt(p_api_version IN NUMBER
100 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_version_id IN NUMBER);
105
106 -- procedure to handle when the process is going through the process of approval
107
108 PROCEDURE handle_approval(p_api_version IN NUMBER
109 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_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_version_id IN NUMBER);
114
115 -- to find the list of all the invalid object refernces
116
117 PROCEDURE invalid_objects(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_version_id IN NUMBER
123 ,x_obj_tbl OUT NOCOPY invalid_object_tbl);
124
125 -- to calculate the start date of the new version
126
127 PROCEDURE calc_start_date(p_api_version IN NUMBER
128 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 ,p_srv_rec IN okl_srv_rec
133 ,x_cal_eff_from OUT NOCOPY DATE);
134
135 -- procedure to set the default Standard Rate Template
136
137 PROCEDURE update_default(p_api_version IN NUMBER
138 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
139 ,x_return_status OUT NOCOPY VARCHAR2
140 ,x_msg_count OUT NOCOPY NUMBER
141 ,x_msg_data OUT NOCOPY VARCHAR2
142 ,p_srt_id IN NUMBER);
143
144 END okl_fe_std_rate_tmpl_pub;