1 PACKAGE BIM_SET_OF_BOOKS AUTHID CURRENT_USER AS
2 /* $Header: bimsobfs.pls 120.2 2005/09/26 23:45:34 arvikuma noship $*/
3
4 default_calender VARCHAR2(240) := fnd_profile.value('AMS_CAMPAIGN_DEFAULT_CALENDER');
5 month_type VARCHAR2(240) := fnd_profile.value('BIM_IO_MONTH');
6 quarter_type VARCHAR2(240) := fnd_profile.value('BIM_IO_QUARTER');
7 year_type VARCHAR2(240) := fnd_profile.value('BIM_IO_YEAR');
8
9 PROCEDURE GET_FISCAL_DATA
10 (
11 p_input_date IN DATE DEFAULT sysdate
12 ,p_org_id IN NUMBER
13 ,x_year OUT NOCOPY VARCHAR2
14 ,x_quarter OUT NOCOPY VARCHAR2
15 ,x_month OUT NOCOPY VARCHAR2
16 ,x_quarter_num OUT NOCOPY NUMBER
17 ,x_month_num OUT NOCOPY NUMBER
18 );
19
20 FUNCTION GET_FISCAL_MONTH
21 (
22 p_input_date IN DATE DEFAULT sysdate
23 ,p_org_id IN NUMBER
24 )RETURN VARCHAR2;
25
26 FUNCTION GET_FISCAL_QTR
27 (
28 p_input_date IN DATE DEFAULT sysdate
29 ,p_org_id IN NUMBER
30 )RETURN VARCHAR2;
31
32 FUNCTION GET_FISCAL_YEAR
33 (
34 p_input_date IN DATE DEFAULT sysdate
35 ,p_org_id IN NUMBER
36 )RETURN VARCHAR2;
37
38 FUNCTION GET_FISCAL_ROLL_YEAR_START
39 (
40 p_input_date IN DATE DEFAULT sysdate
41 ,p_org_id IN NUMBER
42 )RETURN DATE;
43
44 FUNCTION GET_FISCAL_MONTH_START
45 (
46 p_input_date IN DATE DEFAULT sysdate
47 ,p_org_id IN NUMBER
48 )RETURN DATE;
49
50 FUNCTION GET_FISCAL_MONTH_END
51 (
52 p_input_date IN DATE DEFAULT sysdate
53 ,p_org_id IN NUMBER
54 )RETURN DATE;
55
56 FUNCTION GET_FISCAL_QTR_START
57 (
58 p_input_date IN DATE DEFAULT sysdate
59 ,p_org_id IN NUMBER
60 )RETURN DATE;
61
62 FUNCTION GET_FISCAL_QTR_END
63 (
64 p_input_date IN DATE DEFAULT sysdate
65 ,p_org_id IN NUMBER
66 )RETURN DATE;
67
68 FUNCTION GET_FISCAL_YEAR_START
69 (
70 p_input_date IN DATE DEFAULT sysdate
71 ,p_org_id IN NUMBER
72 )RETURN DATE;
73
74 FUNCTION GET_FISCAL_YEAR_END
75 (
76 p_input_date IN DATE DEFAULT sysdate
77 ,p_org_id IN NUMBER
78 )RETURN DATE;
79
80 FUNCTION GET_PRE_FISCAL_ROLL_YEAR_START
81 (
82 p_input_date IN DATE DEFAULT sysdate
83 ,p_org_id IN NUMBER
84 )RETURN DATE;
85
86 FUNCTION GET_PRE_FISCAL_ROLL_YEAR_END
87 (
88 p_input_date IN DATE DEFAULT sysdate
89 ,p_org_id IN NUMBER
90 )RETURN DATE;
91
92 FUNCTION GET_PRE_FISCAL_MONTH_START
93 (
94 p_input_date IN DATE DEFAULT sysdate
95 ,p_org_id IN NUMBER
96 )RETURN DATE;
97
98 FUNCTION GET_PRE_FISCAL_MONTH_END
99 (
100 p_input_date IN DATE DEFAULT sysdate
101 ,p_org_id IN NUMBER
102 )RETURN DATE;
103
104 FUNCTION GET_PRE_FISCAL_QTR_START
105 (
106 p_input_date IN DATE DEFAULT sysdate
107 ,p_org_id IN NUMBER
108 )RETURN DATE;
109
110 FUNCTION GET_PRE_FISCAL_QTR_END
111 (
112 p_input_date IN DATE DEFAULT sysdate
113 ,p_org_id IN NUMBER
114 )RETURN DATE;
115
116 FUNCTION GET_PRE_FISCAL_YEAR_START
117 (
118 p_input_date IN DATE DEFAULT sysdate
119 ,p_org_id IN NUMBER
120 )RETURN DATE;
121
122 FUNCTION GET_PRE_FISCAL_YEAR_END
123 (
124 p_input_date IN DATE DEFAULT sysdate
125 ,p_org_id IN NUMBER
126 )RETURN DATE;
127
128 FUNCTION GET_FISCAL_QTR_NUM
129 (
130 p_input_date IN DATE DEFAULT sysdate
131 ,p_org_id IN NUMBER
132 )RETURN NUMBER;
133
134 FUNCTION GET_MONTH_ORDER
135 (
136 p_month IN VARCHAR2
137 ,p_org_id IN NUMBER
138 )RETURN NUMBER;
139
140 FUNCTION GET_PRE_PERIOD
141 ( p_name IN VARCHAR2
142 ,p_type IN VARCHAR2
143 ,p_org_id IN NUMBER
144 ) RETURN VARCHAR2;
145
146 FUNCTION GET_FISCAL_MONTH_NUM
147 (
148 p_input_date IN DATE DEFAULT sysdate
149 ,p_org_id IN NUMBER
150 )RETURN NUMBER;
151
152 FUNCTION GET_QTR_FROM_MONTH
153 ( p_period_name IN VARCHAR2
154 ,p_org_id IN NUMBER
155 ) RETURN VARCHAR2;
156
157 FUNCTION GET_YEAR_FROM_MONTH
158 ( p_period_name IN VARCHAR2
159 ,p_org_id IN NUMBER
160 ) RETURN VARCHAR2;
161
162 FUNCTION GET_YEAR_FROM_QTR
163 ( p_period_name IN VARCHAR2
164 ,p_org_id IN NUMBER
165 ) RETURN VARCHAR2;
166
167
168 END BIM_SET_OF_BOOKS;