1 PACKAGE PQH_RBC_UTILITY AUTHID CURRENT_USER AS
2 /* $Header: pqrbcutl.pkh 120.25 2006/03/10 09:29 srajakum noship $ */
3 function allow_criteria_delete(p_eligy_criteria_id in number) return varchar2;
4 function get_matrix_disable_date(p_pl_id in number,p_effective_date in date) return Date;
5
6 function allow_hgrid_add(p_copy_entity_txn_id in number,p_max_allowed in number) return varchar2;
7 function allow_hgrid_reorder(p_copy_entity_txn_id in number) return varchar2;
8
9 procedure delete_matrix_nodes(p_copy_entity_txn_id in number,
10 p_pl_id in number,
11 p_level in number,
12 p_short_code in varchar2,
13 p_mode in varchar2
14 );
15
16 procedure delete_matrix_rates(p_copy_entity_txn_id in number,
17 p_rate_matrix_node_id in number,
18 p_mode in varchar2
19 );
20
21 procedure delete_matrix_values(p_copy_entity_txn_id in number,
22 p_rate_matrix_node_id in number,
23 p_mode in varchar2
24 );
25
26 procedure create_update_criteria(p_mode in varchar2,
27 p_eligy_criteria_id in number,
28 p_business_area in varchar2,
29 p_business_group_id in number,
30 p_effective_date in date,
31 p_criteria_type in varchar2,
32 p_copy_entity_txn_id in out nocopy number,
33 p_copy_entity_result_id out nocopy number,
34 p_copy_entity_result_ovn out nocopy number);
35 procedure stage_to_criteria(p_copy_entity_txn_id in number,
36 p_effective_date in date,
37 p_eligy_criteria_id out nocopy number);
38
39 FUNCTION check_criteria_rate_under_use(p_criteria_rate_defn_id NUMBER) RETURN varchar2;
40 PROCEDURE insert_rate_defn_tl(rateid in number,
41 ratename in varchar2,
42 lang in varchar2,
43 slang in varchar2,
44 cdate in date,
45 cperson in number);
46 PROCEDURE sync_rate_factors_tables(critId in varchar2,
47 parentId in varchar2);
48 FUNCTION is_used_in_matrix(p_selected_rate_matrix NUMBER, p_criteria_rate_defn_id NUMBER) RETURN varchar2;
49 FUNCTION get_rate_factor_name(p_criteria_rate_factor_id NUMBER) RETURN varchar2;
50 PROCEDURE is_crit_rate_short_name_uniq(sname in varchar2,
51 rateId in number,
52 bgId in number,
53 isValid out nocopy varchar2);
54 PROCEDURE is_crit_rate_name_uniq(cname in varchar2,
55 rateId in number,
56 bgId in number,
57 isValid out nocopy varchar2);
58 PROCEDURE cascade_rate_factors_table(rateTypeId in varchar2);
59 procedure cancel_rate_matrix_txn(p_copy_entity_txn_id in number,p_status out nocopy varchar2);
60 function is_lowest_level(p_copy_entity_txn_id number,
61 p_copy_entity_result_id number,
62 p_level_number number) return varchar2;
63 --
64 procedure delete_rate_values
65 (p_copy_entity_txn_id in number,
66 p_copy_entity_result_id in number
67 );
68
69 --
70 Procedure add_crd_to_rate_matrix
71 (p_business_group_id in number,
72 p_criteria_rate_defn_id in number,
73 p_copy_entity_txn_id in number,
74 p_define_min_flag in varchar2,
75 p_define_mid_flag in varchar2,
76 p_define_max_flag in varchar2,
77 p_define_std_flag in varchar2,
78 p_currency_code in varchar2,
79 p_uom in varchar2,
80 p_rate_calc_cd in varchar2,
81 p_display_computed_values in varchar2,
82 p_name in varchar2
83 );
84 --
85 Procedure remove_crd_from_rate_matrix
86 (p_business_group_id in number,
87 p_criteria_rate_defn_id in number,
88 p_copy_entity_txn_id in number,
89 p_removed_crd_name out nocopy varchar2,
90 p_removed_dep_crd out nocopy varchar2);
91 --
92 Procedure rebuild_rbr_rows
93 (p_business_group_id in number,
94 p_copy_entity_txn_id in number
95 ) ;
96
97 /**
98 procedure load_criteria_seed_row(p_owner in varchar2
99 ,p_short_code in varchar2
100 ,p_name in varchar2
101 ,p_description in varchar2
102 ,p_crit_col1_val_type_cd in varchar2
103 ,p_crit_col1_datatype in varchar2
104 ,p_col1_lookup_type in varchar2
105 ,p_col1_value_set_name in varchar2
106 ,p_access_table_name1 in varchar2
107 ,p_access_column_name1 in varchar2
108 ,p_crit_col2_val_type_cd in varchar2
109 ,p_crit_col2_datatype in varchar2
110 ,p_col2_lookup_type in varchar2
111 ,p_col2_value_set_name in varchar2
112 ,p_access_table_name2 in varchar2
113 ,p_access_column_name2 in varchar2
114 ,p_allow_range_validation_flag in varchar2
115 ,p_allow_range_validation_flag2 in varchar2
116 ,p_user_defined_flag in varchar2
117 ,p_business_group_id in varchar2
118 ,p_legislation_code in varchar2
119 );
120 **/
121 procedure rate_columns_in_sync(critId in number,
122 pMaxFlag in varchar2,
123 pMinFlag in varchar2,
124 pMidFlag in varchar2,
125 pDflFlag in varchar2,
126 pOutValue out nocopy varchar2);
127 FUNCTION get_currency_name(p_currency_code varchar2) RETURN varchar2;
128
129 FUNCTION get_formula_name(p_formula_id varchar2) RETURN varchar2;
130
131 Function get_vset_datatype(p_value_set_id in number) return varchar2;
132
133 end pqh_rbc_utility;