1 PACKAGE PQH_RBC_STAGE AUTHID CURRENT_USER AS
2 /* $Header: pqrbcstg.pkh 120.1 2005/10/31 10:25 srajakum noship $ */
3 function build_rate_node_name(p_rate_matrix_node_id in number,
4 p_business_group_id in number,
5 p_node_short_code in varchar2 default null,
6 p_effective_date in date
7 ) return varchar2 ;
8 procedure cre_matrix(p_business_group_id in number,
9 p_effective_date in date,
10 p_copy_entity_txn_id out nocopy number);
11 procedure upd_matrix(p_rate_matrix_id in number,
12 p_effective_date in date,
13 p_business_group_id in number,
14 p_mode in varchar2 default 'NORMAL',
15 p_matrix_loaded out nocopy varchar2,
16 p_copy_entity_txn_id out nocopy number);
17 procedure build_rate_matx(p_cet_id in number,
18 p_effective_date in date);
19 procedure rbr_writeback(p_cet_id in number,
20 p_effective_date in date);
21 procedure rbr_writeback(p_rbr_cer_id in number,
22 p_effective_date in date);
23 procedure recalc_rate_matx(p_cet_id in number,
24 p_effective_date in date);
25 function get_annual_factor(p_freq_cd in varchar2) return number;
26 --
27 end pqh_rbc_stage;