[Home] [Help]
PACKAGE: APPS.OKL_EC_EVALUATE_PVT
Source
1 PACKAGE okl_ec_evaluate_pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRECUS.pls 120.2 2005/08/23 05:37:52 asawanka noship $ */
3
4 ------------------------------------------------------------------------------
5 -- data structures declaration
6 ------------------------------------------------------------------------------
7
8 SUBTYPE okl_ech_rec IS okl_ech_pvt.okl_ech_rec;
9
10 SUBTYPE okl_ecl_rec IS okl_ecl_pvt.okl_ecl_rec;
11
12 SUBTYPE okl_ecv_rec IS okl_ecv_pvt.okl_ecv_rec;
13
14 SUBTYPE okl_ecl_tbl IS okl_ecl_pvt.okl_ecl_tbl;
15
16 SUBTYPE okl_ecv_tbl IS okl_ecv_pvt.okl_ecv_tbl;
17
18 TYPE okl_number_table_type IS TABLE OF number INDEX BY BINARY_INTEGER;
19
20 TYPE okl_varchar2_table_type IS TABLE OF varchar2(240)
21 INDEX BY BINARY_INTEGER;
22
23 TYPE okl_date_tabe_type IS TABLE OF date INDEX BY BINARY_INTEGER;
24
25 TYPE okl_qa_result_rec_type IS RECORD (
26 message varchar2(240),
27 status varchar2(30)
28 );
29
30 TYPE okl_qa_result_tbl_type IS TABLE OF okl_qa_result_rec_type
31 INDEX BY BINARY_INTEGER;
32
33 TYPE okl_ec_rec_type IS RECORD (
34 src_id number,
35 source_name varchar2(240),
36 target_id number,
37 src_type varchar2(30),
38 target_type varchar2(30),
39 target_eff_from date,
40 term number,
41 territory varchar2(240),
42 deal_size number,
43 customer_credit_class varchar2(240),
44 down_payment number,
45 advance_rent number,
46 trade_in_value number,
47 item_table okl_number_table_type,
48 item_categories_table okl_number_table_type,
49 validation_mode varchar2(30),
50 consolidated_status varchar2(30),
51 qa_result_tbl okl_qa_result_tbl_type,
52 currency_code varchar2(30)
53 );
54 g_ec_rec okl_ec_rec_type;
55
56 TYPE okl_ac_rec_type IS RECORD (
57 src_id number,
58 source_name varchar2(240),
59 target_id number,
60 src_type varchar2(30),
61 target_type varchar2(30),
62 target_eff_from date,
63 term number,
64 territory varchar2(240),
65 deal_size number,
66 customer_credit_class varchar2(240)
67 );
68 g_ac_rec okl_ac_rec_type;
69
70 TYPE okl_ec_values_rec_type IS RECORD (
71 operator_code varchar2(30),
72 value1 varchar2(240),
73 value2 varchar2(240),
74 match_criteria_code varchar2(30)
75 );
76
77 TYPE okl_ec_values_tbl_type IS TABLE OF okl_ec_values_rec_type
78 INDEX BY BINARY_INTEGER;
79 g_ec_values_tbl okl_ec_values_tbl_type;
80 g_ac_values_tbl okl_ec_values_tbl_type;
81
82 ------------------------------------------------------------------------------
83 -- Global Variables
84 ------------------------------------------------------------------------------
85 g_pkg_name CONSTANT varchar2(200) := 'OKL_EC_EVALUATE_PVT';
86 g_app_name CONSTANT varchar2(3) := okl_api.g_app_name;
87 g_unexpected_error CONSTANT varchar2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
88 g_sqlerrm_token CONSTANT varchar2(200) := 'SQLERRM';
89 g_sqlcode_token CONSTANT varchar2(200) := 'SQLCODE';
90
91 --------------------------------------------------------------------------------
92 -- Procedures and Functions
93 --------------------------------------------------------------------------------
94
95 PROCEDURE validate(
96 p_api_version IN number
97 ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
98 ,x_return_status OUT nocopy varchar2
99 ,x_msg_count OUT nocopy number
100 ,x_msg_data OUT nocopy varchar2
101 ,p_okl_ec_rec IN OUT nocopy okl_ec_rec_type
102 ,x_eligible OUT nocopy boolean
103 );
104
105 PROCEDURE get_adjustment_factor(
106 p_api_version In number
107 ,p_init_msg_list In varchar2 Default Okl_api.G_false
108 ,x_return_status Out Nocopy varchar2
109 ,x_msg_count Out Nocopy number
110 ,x_msg_data Out Nocopy varchar2
111 ,p_okl_ac_rec In okl_ac_rec_type
112 ,x_adjustment_factor Out Nocopy number
113 );
114
115 FUNCTION compare_eligibility_criteria(p_source_id1 IN number
116 ,p_source_type1 IN varchar2
117 ,p_source_id2 IN number
118 ,p_source_type2 IN varchar2) RETURN boolean;
119
120 END okl_ec_evaluate_pvt;