1 PACKAGE QPR_SR_UTIL AS
2 /* $Header: QPRUTILS.pls 120.3 2008/03/12 12:56:56 amjha ship $ */
3
4 /* Public Variables */
5
6 g_datamart_tmpl_id number := 1;
7 g_priceplan_tmpl_id number := 2;
8
9 /* Public Functions */
10
11 function get_null_pk return number;
12 function get_null_desc return varchar2;
13 function get_all_scs_pk return number;
14 function get_all_scs_desc return varchar2;
15 function get_all_cus_pk return number;
16 function get_all_cus_desc return varchar2;
17 function get_all_geo_pk return number;
18 function get_all_geo_desc return varchar2;
19 function get_all_org_pk return number;
20 function get_all_org_desc return varchar2;
21 function get_all_prd_pk return number;
22 function get_all_prd_desc return varchar2;
23 function get_all_rep_pk return number;
24 function get_all_rep_desc return varchar2;
25 function get_all_ord_pk return number;
26 function get_all_ord_desc return VARCHAR2;
27 function get_all_adj_pk return number;
28 function get_all_adj_desc return VARCHAR2;
29 function get_all_dsb_pk return number;
30 function get_all_dsb_desc return VARCHAR2;
31 function get_all_vlb_pk return number;
32 function get_all_vlb_desc return VARCHAR2;
33 function get_all_mgb_pk return number;
34 function get_all_mgb_desc return VARCHAR2;
35 function get_all_oad_pk return number;
36 function get_all_oad_desc return VARCHAR2;
37 function get_all_cos_pk return number;
38 function get_all_cos_desc return VARCHAR2;
39 function get_cost_type_desc return VARCHAR2;
40 function get_all_psg_pk return number;
41 function get_all_psg_desc return varchar2;
42 function get_all_year_pk return number;
43 function get_all_year_desc return VARCHAR2;
44
45 function dm_parameters_ok return boolean;
46
47 FUNCTION get_dimension_desc(p_type varchar2,
48 p_code varchar2) return VARCHAR2;
49
50
51
52 function set_customer_attr( p_profile_name IN VARCHAR2,
53 p_profile_value IN VARCHAR2,
54 p_profile_Level IN VARCHAR2) return number;
55
56 FUNCTION get_customer_id( p_party_id IN NUMBER) return NUMBER ;
57 function get_internal_customers_desc return VARCHAR2;
58 function uom_conv(p_uom_code in varchar2,
59 p_item_id in number, p_master_uom in varchar2
60 ) return number;
61
62 function convert_global_amt(p_curr_code in varchar2,
63 p_date in date,
64 from_ind_flag in varchar2 default 'Y',
65 p_global_curr_code in varchar2 default null)
66 return number;
67
68 function get_customer_attribute return varchar2;
69
70 function get_dblink(p_instance_id in number) return varchar2;
71
72 FUNCTION ods_uom_conv(p_item_id in NUMBER, p_from_uom_code in VARCHAR2,
73 p_to_uom_code in varchar2,
74 p_instance_id in number default null,
75 p_precision in number default null) RETURN NUMBER ;
76
77 function get_base_uom(p_item_id in number,
78 p_instance_id in number default null) return varchar2;
79
80 function read_parameter(p_para_name in varchar2) return varchar2;
81
82 function qpr_convert_amount(p_instance_id in number,
83 p_from_currency in varchar2,
84 p_to_currency in varchar2,
85 p_conversion_date in date,
86 p_conversion_type in varchar2 default null,
87 p_amount in number) return number;
88
89 function ods_curr_conversion(p_from_curr_code in varchar2 default null,
90 p_to_curr_code in varchar2,
91 p_conv_type in varchar2 default null,
92 p_date in date,
93 p_instance_id in number)
94 return number;
95
96 function get_oad_om_group_pk return varchar2;
97 function get_oad_om_group_desc return varchar2;
98
99 function get_oad_ar_group_pk return varchar2;
100 function get_oad_ar_group_desc return varchar2;
101
102 function get_oad_om_type_pk return varchar2;
103 function get_oad_om_type_desc return varchar2;
104
105 function get_oad_ar_cm_type_pk return varchar2;
106 function get_oad_ar_cm_type_desc return varchar2;
107
108 function get_oad_ar_cd_type_pk return varchar2;
109 function get_oad_ar_cd_type_desc return varchar2;
110
111 function get_oad_group_desc(p_code varchar2) return varchar2;
112 function get_oad_type_desc(p_code varchar2) return varchar2;
113
114 function get_max_date(p_date1 in date, p_date2 in date) return date;
115
116 procedure purge_base_tables_data(p_price_plan_id in number);
117
118 END QPR_SR_UTIL;