[Home] [Help]
PACKAGE: APPS.QPR_POLICY_EVAL
Source
1 PACKAGE QPR_POLICY_EVAL AUTHID CURRENT_USER AS
2 /* $Header: QPRUPOLS.pls 120.3 2008/01/04 13:26:36 bhuchand noship $ */
3
4 TYPE num_type IS TABLE OF Number INDEX BY BINARY_INTEGER;
5 TYPE char240_type IS TABLE OF Varchar2(240) INDEX BY BINARY_INTEGER;
6 TYPE real_type IS TABLE OF Number(32,10) INDEX BY BINARY_INTEGER;
7 TYPE date_type IS TABLE OF Date INDEX BY BINARY_INTEGER;
8
9 TYPE MEASURE_REC_TYPE IS RECORD
10 (
11 instance char240_type,
12 prd_sr_level_value_pk char240_type,
13 geo_sr_level_value_pk char240_type,
14 cus_sr_level_value_pk char240_type,
15 ord_sr_level_value_pk char240_type,
16 org_sr_level_value_pk char240_type,
17 chn_sr_level_value_pk char240_type,
18 rep_sr_level_value_pk char240_type,
19 tim_sr_level_value_pk date_type,
20 vlb_sr_level_value_pk char240_type,
21 dsb_sr_level_value_pk char240_type,
22 DISC_AMOUNT num_type,
23 DISC_PERC num_type,
24 LIST_PRICE num_type,
25 QUANTITY num_type,
26 GROSS_REVENUE num_type
27 );
28
29 TYPE POLICY_REC_TYPE IS RECORD
30 (
31 instance num_type,
32 prd_sr_level_value_pk char240_type,
33 geo_sr_level_value_pk char240_type,
34 cus_sr_level_value_pk char240_type,
35 ord_sr_level_value_pk char240_type,
36 org_sr_level_value_pk char240_type,
37 chn_sr_level_value_pk char240_type,
38 rep_sr_level_value_pk char240_type,
39 tim_sr_level_value_pk date_type,
40 vlb_sr_level_value_pk char240_type,
41 dsb_sr_level_value_pk char240_type,
42 pass_exceptions num_type,
43 fail_exceptions num_type,
44 na_exceptions num_type,
45 hi_sever_thre num_type,
46 me_sever_thre num_type,
47 lo_sever_thre num_type,
48 hi_pol_imp_rank num_type,
49 me_pol_imp_rank num_type,
50 lo_pol_imp_rank num_type,
51 gross_rev_comp num_type,
52 gross_rev_non_comp num_type,
53 rev_at_lis_price num_type,
54 rev_at_pol_limit num_type,
55 policy_type_code char240_type
56 );
57
58 TYPE POLICY_DATA_REC is record
59 (
60 POLICY_LINE_ID number,
61 POLICY_ID number,
62 POLICY_TYPE_CODE varchar2(30),
63 POLICY_MEASURE_TYPE_CODE varchar2(30),
64 LIMIT_VALUE_TYPE_CODE varchar2(30),
65 REF_LIMIT_VALUE number,
66 EFFECTIVE_DATE_FROM date,
67 EFFECTIVE_DATE_TO date
68 );
69
70 type POLICY_DET_REC_TYPE is table of POLICY_DATA_REC;
71
72 procedure process(
73 errbuf OUT NOCOPY VARCHAR2,
74 retcode OUT NOCOPY VARCHAR2,
75 p_instance_id number,
76 p_from_date varchar2,
77 p_to_date varchar2);
78
79 procedure get_policy_details(
80 i_instance_id in number,
81 i_psg_id in number,
82 i_policy_id in number,
83 i_time_level_value in date,
84 i_vlb_level_value in varchar2,
85 i_policy_meas_type in varchar2,
86 i_policy_type in varchar2 default null,
87 o_policy_det out nocopy policy_det_rec_type) ;
88
89 procedure get_pricing_segment_id(
90 i_instance_id in number,
91 i_ord_level_value in varchar2,
92 i_time_level_value in date,
93 i_prd_level_value in varchar2,
94 i_geo_level_value in varchar2,
95 i_cus_level_value in varchar2,
96 i_org_level_value in varchar2,
97 i_rep_level_value in varchar2,
98 i_chn_level_value in varchar2,
99 i_vlb_level_value in varchar2,
100 o_pr_segment_id out nocopy number,
101 o_pol_importance_code out nocopy varchar2);
102
103 procedure copy_policy(p_policy_id in number,
104 p_new_policy_name in out nocopy varchar2,
105 p_new_pol_id out nocopy number,
106 retcode out nocopy number,
107 errbuf out nocopy varchar2);
108 end;
109