DBA Data[Home] [Help]

APPS.OPI_DBI_CALENDAR_PKG dependencies on FII_TIME_API

Line 133: l_date := fii_time_api.ent_cyr_start(as_of_date);

129:
130: begin
131:
132: if(period_type='YTD') then
133: l_date := fii_time_api.ent_cyr_start(as_of_date);
134:
135: elsif(period_type='QTD') then
136: l_date := fii_time_api.ent_cqtr_start(as_of_date);
137:

Line 136: l_date := fii_time_api.ent_cqtr_start(as_of_date);

132: if(period_type='YTD') then
133: l_date := fii_time_api.ent_cyr_start(as_of_date);
134:
135: elsif(period_type='QTD') then
136: l_date := fii_time_api.ent_cqtr_start(as_of_date);
137:
138: elsif(period_type='MTD') then
139: l_date := fii_time_api.ent_cper_start(as_of_date);
140:

Line 139: l_date := fii_time_api.ent_cper_start(as_of_date);

135: elsif(period_type='QTD') then
136: l_date := fii_time_api.ent_cqtr_start(as_of_date);
137:
138: elsif(period_type='MTD') then
139: l_date := fii_time_api.ent_cper_start(as_of_date);
140:
141: elsif(period_type = 'WTD') then
142: l_date := fii_time_api.cwk_start(as_of_date);
143:

Line 142: l_date := fii_time_api.cwk_start(as_of_date);

138: elsif(period_type='MTD') then
139: l_date := fii_time_api.ent_cper_start(as_of_date);
140:
141: elsif(period_type = 'WTD') then
142: l_date := fii_time_api.cwk_start(as_of_date);
143:
144: end if;
145:
146: return l_date;

Line 186: l_date := fii_time_api.ent_sd_lyr_end(as_of_date);

182: begin
183:
184: if(period_type='YTD') then
185:
186: l_date := fii_time_api.ent_sd_lyr_end(as_of_date);
187:
188: elsif(period_type='QTD') then
189:
190: if(comparison_type = 'Y') then

Line 191: l_date := fii_time_api.ent_sd_lysqtr_end(as_of_date);

187:
188: elsif(period_type='QTD') then
189:
190: if(comparison_type = 'Y') then
191: l_date := fii_time_api.ent_sd_lysqtr_end(as_of_date);
192: else
193: l_date := fii_time_api.ent_sd_pqtr_end(as_of_date);
194: end if;
195:

Line 193: l_date := fii_time_api.ent_sd_pqtr_end(as_of_date);

189:
190: if(comparison_type = 'Y') then
191: l_date := fii_time_api.ent_sd_lysqtr_end(as_of_date);
192: else
193: l_date := fii_time_api.ent_sd_pqtr_end(as_of_date);
194: end if;
195:
196: elsif(period_type='MTD') then
197:

Line 199: l_date := fii_time_api.ent_sd_lysper_end(as_of_date);

195:
196: elsif(period_type='MTD') then
197:
198: if(comparison_type = 'Y') then
199: l_date := fii_time_api.ent_sd_lysper_end(as_of_date);
200: else
201: l_date := fii_time_api.ent_sd_pper_end(as_of_date);
202: end if;
203:

Line 201: l_date := fii_time_api.ent_sd_pper_end(as_of_date);

197:
198: if(comparison_type = 'Y') then
199: l_date := fii_time_api.ent_sd_lysper_end(as_of_date);
200: else
201: l_date := fii_time_api.ent_sd_pper_end(as_of_date);
202: end if;
203:
204: elsif(period_type='WTD') then
205:

Line 207: l_date := fii_time_api.sd_lyswk(as_of_date);

203:
204: elsif(period_type='WTD') then
205:
206: if(comparison_type = 'Y') then
207: l_date := fii_time_api.sd_lyswk(as_of_date);
208: else
209: l_date := fii_time_api.sd_pwk(as_of_date);
210: end if;
211:

Line 209: l_date := fii_time_api.sd_pwk(as_of_date);

205:
206: if(comparison_type = 'Y') then
207: l_date := fii_time_api.sd_lyswk(as_of_date);
208: else
209: l_date := fii_time_api.sd_pwk(as_of_date);
210: end if;
211:
212: end if;
213: