1 PACKAGE okl_fe_eo_term_options_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLREOTS.pls 120.1 2005/08/25 10:34:50 viselvar noship $ */
3
4 -- record structure for the Purchase Options Header
5
6 SUBTYPE okl_ethv_rec IS okl_eth_pvt.okl_ethv_rec;
7
8 SUBTYPE okl_ethv_tbl IS okl_eth_pvt.okl_ethv_tbl;
9
10 -- record structure for the Purchase Options Version Details
11
12 SUBTYPE okl_eve_rec IS okl_eve_pvt.okl_eve_rec;
13
14 SUBTYPE okl_eve_tbl IS okl_eve_pvt.okl_eve_tbl;
15
16 -- record structure for the Purchase Option Values
17
18 SUBTYPE okl_etv_rec IS okl_etv_pvt.okl_etv_rec;
19
20 SUBTYPE okl_etv_tbl IS okl_etv_pvt.okl_etv_tbl;
21
22 -- record structure for the Purchase Option Lines
23
24 SUBTYPE okl_eto_rec IS okl_eto_pvt.okl_eto_rec;
25
26 SUBTYPE okl_eto_tbl IS okl_eto_pvt.okl_eto_tbl;
27
28 TYPE invalid_object_rec IS RECORD (
29 obj_id NUMBER,
30 obj_name VARCHAR2(240),
31 obj_version VARCHAR2(24),
32 obj_type VARCHAR2(20)
33 );
34
35 TYPE invalid_object_tbl IS TABLE OF invalid_object_rec
36 INDEX BY BINARY_INTEGER;
37
38 SUBTYPE okl_lrs_id_tbl IS okl_lease_rate_Sets_pvt.okl_number_table; -- Global variables
39 g_pkg_name CONSTANT VARCHAR2(200) := 'OKL_FE_EO_TERM_OPTIONS_PVT';
40 g_app_name CONSTANT VARCHAR2(3) := okl_api.g_app_name;
41 g_unexpected_error CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
42 g_sqlerrm_token CONSTANT VARCHAR2(200) := 'SQLERRM';
43 g_sqlcode_token CONSTANT VARCHAR2(200) := 'SQLCODE';
44
45 ------------------------------------------------------------------------------
46 --Global Exception
47 ------------------------------------------------------------------------------
48
49 g_exception_halt_validation EXCEPTION;
50
51 PROCEDURE get_item_lines(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_end_of_term_id IN NUMBER
57 ,p_version IN VARCHAR2
58 ,x_eto_tbl OUT NOCOPY okl_eto_tbl);
59
60 -- Get the values of the Purchase Options
61
62 PROCEDURE get_eo_term_values(p_api_version IN NUMBER
63 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
64 ,x_return_status OUT NOCOPY VARCHAR2
65 ,x_msg_count OUT NOCOPY NUMBER
66 ,x_msg_data OUT NOCOPY VARCHAR2
67 ,p_end_of_term_id IN NUMBER
68 ,p_version IN VARCHAR2
69 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
70
71 -- Get the Purchase Option Header, Version, values and Values
72
73 PROCEDURE get_end_of_term_option(p_api_version IN NUMBER
74 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
75 ,x_return_status OUT NOCOPY VARCHAR2
76 ,x_msg_count OUT NOCOPY NUMBER
77 ,x_msg_data OUT NOCOPY VARCHAR2
78 ,p_eot_id IN NUMBER
79 ,p_version IN VARCHAR2
80 ,x_ethv_rec OUT NOCOPY okl_ethv_rec
81 ,x_eve_rec OUT NOCOPY okl_eve_rec
82 ,x_eto_tbl OUT NOCOPY okl_eto_tbl
83 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
84
85 PROCEDURE insert_end_of_term_option(p_api_version IN NUMBER
86 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY NUMBER
89 ,x_msg_data OUT NOCOPY VARCHAR2
90 ,p_ethv_rec IN okl_ethv_rec
91 ,p_eve_rec IN okl_eve_rec
92 ,p_eto_tbl IN okl_eto_tbl
93 ,p_etv_tbl IN okl_etv_tbl
94 ,x_ethv_rec OUT NOCOPY okl_ethv_rec
95 ,x_eve_rec OUT NOCOPY okl_eve_rec
96 ,x_eto_tbl OUT NOCOPY okl_eto_tbl
97 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
98
99 PROCEDURE update_end_of_term_option(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_eve_rec IN okl_eve_rec
105 ,p_eto_tbl IN okl_eto_tbl
106 ,p_etv_tbl IN okl_etv_tbl
107 ,x_eve_rec OUT NOCOPY okl_eve_rec
108 ,x_eto_tbl OUT NOCOPY okl_eto_tbl
109 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
110
111 PROCEDURE create_version(p_api_version IN NUMBER
112 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
113 ,x_return_status OUT NOCOPY VARCHAR2
114 ,x_msg_count OUT NOCOPY NUMBER
115 ,x_msg_data OUT NOCOPY VARCHAR2
116 ,p_eve_rec IN okl_eve_rec
117 ,p_eto_tbl IN okl_eto_tbl
118 ,p_etv_tbl IN okl_etv_tbl
119 ,x_eve_rec OUT NOCOPY okl_eve_rec
120 ,x_eto_tbl OUT NOCOPY okl_eto_tbl
121 ,x_etv_tbl OUT NOCOPY okl_etv_tbl);
122
123 PROCEDURE validate_end_of_term_option(p_api_version IN NUMBER
124 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
125 ,x_return_status OUT NOCOPY VARCHAR2
126 ,x_msg_count OUT NOCOPY NUMBER
127 ,x_msg_data OUT NOCOPY VARCHAR2
128 ,p_end_of_ver_id IN NUMBER);
129
130 PROCEDURE handle_approval(p_api_version IN NUMBER
131 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
132 ,x_return_status OUT NOCOPY VARCHAR2
133 ,x_msg_count OUT NOCOPY NUMBER
134 ,x_msg_data OUT NOCOPY VARCHAR2
135 ,p_end_of_term_ver_id IN NUMBER);
136
137 -- to find the list of all the invalid object refernces
138
139 PROCEDURE invalid_objects(p_api_version IN NUMBER
140 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
141 ,x_return_status OUT NOCOPY VARCHAR2
142 ,x_msg_count OUT NOCOPY NUMBER
143 ,x_msg_data OUT NOCOPY VARCHAR2
144 ,p_version_id IN NUMBER
145 ,x_obj_tbl OUT NOCOPY invalid_object_tbl);
146
147 -- to calculate the start date of the new version
148
149 PROCEDURE calculate_start_date(p_api_version IN NUMBER
150 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
151 ,x_return_status OUT NOCOPY VARCHAR2
152 ,x_msg_count OUT NOCOPY NUMBER
153 ,x_msg_data OUT NOCOPY VARCHAR2
154 ,p_eve_rec IN okl_eve_rec
155 ,x_cal_eff_from OUT NOCOPY DATE);
156
157 PROCEDURE submit_end_of_term(p_api_version IN NUMBER
158 ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_count OUT NOCOPY NUMBER
161 ,x_msg_data OUT NOCOPY VARCHAR2
162 ,p_end_of_term_ver_id IN NUMBER);
163
164 END okl_fe_eo_term_options_pvt;