1 PACKAGE okl_ecc_values_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRECVS.pls 120.1 2005/09/23 07:18:18 asawanka noship $ */
3
4 ------------------------------------------------------------------------------
5 -- data structures declaration
6 ------------------------------------------------------------------------------
7 SUBTYPE okl_ech_rec IS okl_ech_pvt.okl_ech_rec;
8
9 SUBTYPE okl_ecl_rec IS okl_ecl_pvt.okl_ecl_rec;
10
11 SUBTYPE okl_ecv_rec IS okl_ecv_pvt.okl_ecv_rec;
12
13 SUBTYPE okl_ecl_tbl IS okl_ecl_pvt.okl_ecl_tbl;
14
15 SUBTYPE okl_ecv_tbl IS okl_ecv_pvt.okl_ecv_tbl;
16
17 ------------------------------------------------------------------------------
18 -- Global Variables
19 ------------------------------------------------------------------------------
20 g_pkg_name CONSTANT varchar2(200) := 'OKL_ECC_VALUES_PVT';
21 g_api_type CONSTANT varchar2(4) := '_PVT';
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 -- Procedures and Functions
35 --------------------------------------------------------------------------------
36
37 PROCEDURE remove_ec_line(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_ecl_rec IN okl_ecl_rec);
43
44 PROCEDURE handle_eligibility_criteria(p_api_version IN number
45 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
46 ,x_return_status OUT NOCOPY varchar2
47 ,x_msg_count OUT NOCOPY number
48 ,x_msg_data OUT NOCOPY varchar2
49 ,p_ech_rec IN okl_ech_rec
50 ,x_ech_rec OUT NOCOPY okl_ech_rec
51 ,p_ecl_tbl IN okl_ecl_tbl
52 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
53 ,p_ecv_tbl IN okl_ecv_tbl
54 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl
55 ,p_source_eff_from IN date
56 ,p_source_eff_to IN date);
57
58 PROCEDURE get_eligibility_criteria(p_api_version IN number
59 ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
60 ,x_return_status OUT NOCOPY varchar2
61 ,x_msg_count OUT NOCOPY number
62 ,x_msg_data OUT NOCOPY varchar2
63 ,p_source_id IN number
64 ,p_source_type IN varchar2
65 ,p_eff_from IN date
66 ,p_eff_to IN date
67 ,x_ech_rec OUT NOCOPY okl_ech_rec
68 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
69 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
70
71 PROCEDURE get_eligibility_criteria(p_api_version IN number
72 ,p_init_msg_list IN varchar2 DEFAULT fnd_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_source_id IN number
77 ,p_source_type IN varchar2
78 ,x_ech_rec OUT NOCOPY okl_ech_rec
79 ,x_ecl_tbl OUT NOCOPY okl_ecl_tbl
80 ,x_ecv_tbl OUT NOCOPY okl_ecv_tbl);
81
82 PROCEDURE delete_eligibility_criteria(p_api_version IN number
83 ,p_init_msg_list IN varchar2 DEFAULT fnd_api.g_false
84 ,x_return_status OUT NOCOPY varchar2
85 ,x_msg_count OUT NOCOPY number
86 ,x_msg_data OUT NOCOPY varchar2
87 ,p_source_id IN number
88 ,p_source_type IN varchar2);
89
90 PROCEDURE end_date_eligibility_criteria(p_api_version IN number
91 ,p_init_msg_list IN varchar2 DEFAULT fnd_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_source_id IN number
96 ,p_source_type IN varchar2
97 ,p_end_date IN date);
98
99 END okl_ecc_values_pvt;