1 PACKAGE QPR_REGRESSION_ANALYSIS AS
2 /* $Header: QPRURGRS.pls 120.4 2008/01/03 10:23:40 kdhabali noship $ */
3
4 type num_type is table of number index by binary_integer;
5
6 type QPRREGRDATA is ref cursor;
7
8
9 TYPE REGR_DATA_REC_TYPE IS RECORD
10 (
11 product_id num_type,
12 pr_segment_id num_type,
13 regression_slope num_type,
14 regression_intercept num_type,
15 regression_r2 num_type,
16 regression_count num_type
17 );
18
19 procedure reg_transf(
20 i_pp_id in number,
21 i_item_id in number,
22 i_psg_id in number,
23 i_value in number,
24 o_value in out nocopy number) ;
25
26 procedure reg_antitransf(
27 i_pp_id in number,
28 i_item_id in number,
29 i_psg_id in number,
30 i_value in number,
31 o_value in out nocopy number) ;
32
33 procedure do_regress(
34 errbuf out nocopy varchar2,
35 retcode out nocopy varchar2,
36 p_price_plan_id in number,
37 p_start_date in varchar2,
38 p_end_date in varchar2,
39 p_i_prd_id in varchar2,
40 p_f_prd_id in varchar2,
41 p_i_psg_id in varchar2,
42 p_f_psg_id in varchar2);
43
44
45 END QPR_REGRESSION_ANALYSIS ;
46