1 PACKAGE BODY BIM_VALIDITY_CHECK AS
2 /* $Header: bimvalcb.pls 120.1 2005/06/14 15:44:53 appldev $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(20) :='BIM_VALIDITY_CHECK';
5 G_FILE_NAME CONSTANT VARCHAR2(20) :='bimvalcb.pls';
6
7 ---------------------------------------------------------------------
8 -- FUNCTION
9 -- validate_periods
10 -- NOTE
11 -- PARAMETER
12 -- p_date IN DATE
13 -- RETURN VARCHAR2
14 ---------------------------------------------------------------------
15 FUNCTION validate_periods(
16 p_input_date DATE) return VARCHAR2
17 IS
18
19 BEGIN
20
21 return('SUCCESS');
22
23 END validate_periods;
24
25 ---------------------------------------------------------------------
26 -- FUNCTION
27 -- call_currency
28 -- NOTE
29 -- PARAMETER
30 -- p_from_currency IN VARCHAR2
31 -- RETURN VARCHAR2
32 ---------------------------------------------------------------------
33 FUNCTION call_currency(
34 p_from_currency IN VARCHAR2) return VARCHAR2
35 IS
36 l_to_amount NUMBER;
37 l_from_amount NUMBER;
38 l_to_currency VARCHAR2(100) ;
39 x_return_status varchar2(1);
40
41
42 BEGIN
43
44 return('SUCCESS');
45
46 END call_currency;
47
48 ---------------------------------------------------------------------
49 -- FUNCTION
50 -- validate_currency
51 -- NOTE
52 -- PARAMETER
53 -- RETURN VARCHAR2
54 ---------------------------------------------------------------------
55 FUNCTION validate_currency(
56 p_start_date IN DATE
57 ,p_end_date IN DATE) return VARCHAR2
58 IS
59
60 BEGIN
61
62 return('SUCCESS');
63
64 END validate_currency;
65
66
67 ---------------------------------------------------------------------
68 -- FUNCTION
69 -- validate_campaigns
70 -- NOTE
71 -- PARAMETERS
72 -- p_input_date IN DATE -- starting date of the validity
73 -- x_period_errror OUT NOCOPY VARCHAR2 -- error message for period validation
74 -- x_currency_errror OUT NOCOPY VARCHAR2 -- error message for cuurency validation
75 -- RETURN NUMBER
76 -- 0 if both validations succeed,
77 -- 1 if both validations failed,
78 -- 2 only if period validaion failed,
79 -- 3 only if currency validation failed
80 ---------------------------------------------------------------------
81 FUNCTION validate_campaigns(
82 p_start_date IN DATE
83 ,p_end_date IN DATE
84 ,x_period_error OUT NOCOPY VARCHAR2
85 ,x_currency_error OUT NOCOPY VARCHAR2
86 ) return NUMBER
87 IS
88
89 BEGIN
90
91 return (0);
92
93
94 END validate_campaigns;
95
96 ---------------------------------------------------------------------
97 -- FUNCTION
98 -- validate_events
99 -- NOTE
100 -- PARAMETERS
101 -- p_start_date IN DATE -- starting date of the validity
102 -- x_period_errror OUT NOCOPY VARCHAR2 -- error message for period validation
103 -- x_currency_errror OUT NOCOPY VARCHAR2 -- error message for cuurency validation
104 -- RETURN NUMBER
105 -- 0 if both validations succeed,
106 -- 1 if both validations failed,
107 -- 2 only if period validaion failed,
108 -- 3 only if currency validation failed
109 ---------------------------------------------------------------------
110 FUNCTION validate_events(
111 p_start_date IN DATE
112 ,p_end_date IN DATE
113 ,x_period_error OUT NOCOPY VARCHAR2
114 ,x_currency_error OUT NOCOPY VARCHAR2
115 ) return NUMBER
116 IS
117
118 BEGIN
119
120 return (0);
121
122 END validate_events;
123
124 ---------------------------------------------------------------------
125 -- FUNCTION
126 -- validate_budgets
127 -- NOTE
128 -- PARAMETERS
129 -- p_start_date IN DATE -- starting date of the validity
130 -- x_period_errror OUT NOCOPY VARCHAR2 -- error message for period validation
131 -- x_currency_errror OUT NOCOPY VARCHAR2 -- error message for cuurency validation
132 -- RETURN NUMBER
133 -- 0 if both validations succeed,
134 -- 1 if both validations failed,
135 -- 2 only if period validaion failed,
136 -- 3 only if currency validation failed
137 ---------------------------------------------------------------------
138 FUNCTION validate_budgets(
139 p_start_date IN DATE
140 ,p_end_date IN DATE
141 ,x_period_error OUT NOCOPY VARCHAR2
142 ,x_currency_error OUT NOCOPY VARCHAR2
143 ) return NUMBER
144 IS
145
146 BEGIN
147
148 return (0);
149
150 END validate_budgets;
151
152 END BIM_VALIDITY_CHECK;