1 PACKAGE bis_common_parameters AUTHID CURRENT_USER AS
2 /* $Header: BISGPFVS.pls 120.0.12000000.2 2007/04/20 09:04:17 rkumar ship $ */
3 version CONSTANT VARCHAR (80)
4 := '$Header: BISGPFVS.pls 120.0.12000000.2 2007/04/20 09:04:17 rkumar ship $';
5
6 -- ------------------------
7 -- Global Variables
8 -- ------------------------
9
10
11 /*
12 HIGH number := nvl(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_HIGH'), 0.5);
13 MEDIUM number := nvl(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_MEDIUM'), 1.0);
14 LOW number := nvl(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_LOW'),2.0);
15 */
16
17 FUNCTION HIGH return number;
18 FUNCTION MEDIUM return number;
19 FUNCTION LOW return number;
20
21 -- ------------------------
22 -- Public functions
23 --More will be added later
24 -- ------------------------
25
26
27 function get_rate_type return varchar2;
28
29 FUNCTION get_secondary_rate_type
30 return varchar2;
31
32 function get_currency_code
33 return varchar2;
34
35 function get_secondary_currency_code
36 return varchar2;
37
38 function get_period_set_name
39 return varchar2;
40
41 function get_START_DAY_OF_WEEK_ID
42 return varchar2;
43
44 function get_period_type
45 return varchar2;
46
47 function get_workforce_mes_type_id
48 return varchar2;
49
50 function get_auto_factor_mode
51 return varchar2;
52
53 function get_ITM_HRCHY3_VBH_TOP_NODE
54 return varchar2;
55
56 function get_GLOBAL_START_DATE
57 return date;
58
59 function get_implementation_type
60 return varchar2;
61
62 procedure get_global_parameters(
63 p_parameter_list IN DBMS_SQL.VARCHAR2_TABLE,
64 p_attribute_values OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE);
65
66 FUNCTION check_global_parameters(
67 p_parameter_list IN DBMS_SQL.VARCHAR2_TABLE) return boolean;
68
69 function get_item_category_set_1
70 return varchar2;
71
72 function get_item_category_set_2
73 return varchar2;
74
75 function get_item_category_set_3
76 return varchar2;
77
78 function get_item_org_catset_1
79 return varchar2;
80
81 function get_item_hierarchy3_type
82 return varchar2;
83
84 function get_master_instance
85 return varchar2;
86
87 function GET_DISPLAY_VALUE(NAME in varchar2)
88 return varchar2;
89
90 function GET_PRIMARY_CURDIS_NAME
91 return varchar2;
92
93 function GET_SECONDARY_CURDIS_NAME
94 return varchar2;
95
96 FUNCTION get_batch_size(p_complexity_level IN NUMBER) RETURN NUMBER;
97
98 FUNCTION get_degree_of_parallelism RETURN NUMBER;
99
100 FUNCTION get_current_date_id return DATE;
101
102 FUNCTION get_value_at_site_level(pname IN VARCHAR2) RETURN VARCHAR2;
103
104
105 FUNCTION get_annualized_currency_code
106 return varchar2;
107
108 FUNCTION get_annualized_rate_type
109 return varchar2;
110
111 FUNCTION GET_ANNUALIZED_CURDIS_NAME
112 return varchar2;
113
114 -- get the profile option value at site level
115 -- although this profile option is enabled for site, application, responsibility, and user levels
116 FUNCTION get_low_percentage_range
117 RETURN VARCHAR2;
118
119 -- get the profile option value at site level
120 -- although this profile option is enabled for site, application, responsibility, and user levels
121 FUNCTION get_high_percentage_range
122 RETURN VARCHAR2;
123
124 FUNCTION get_treasury_rate_type
125 RETURN VARCHAR2;
126
127 FUNCTION GET_BIS_CUST_CLASS_TYPE
128 RETURN VARCHAR2;
129 --given an string removes multiple occurences of spaces with one space
130 FUNCTION remove_extra_spaces(INPUT IN VARCHAR2) RETURN VARCHAR2;
131
132
133 END bis_common_parameters;