eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIL_BI_PIPELINE_F_PKG dependencies on FII_TIME_API

Line 317: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);

313:
314:
315: --write_log(p_msg => 'Date range:'||l_stg_min_dt||' '||l_stg_max_dt, p_log => 'N');
316: IF l_stg_min_dt IS NOT NULL AND l_stg_max_dt IS NOT NULL THEN
317: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);
318: END IF;
319: l_has_missing_date := FALSE;
320:
321: IF (l_has_missing_date) THEN

Line 2247: l_dynamic_sql := 'BEGIN :1 := fii_time_api.sd_pwk(:2); END;';

2243: x_year => l_year, x_min_date_id => l_min_date_id, x_max_date_id => l_max_date_id);
2244:
2245:
2246: BEGIN
2247: l_dynamic_sql := 'BEGIN :1 := fii_time_api.sd_pwk(:2); END;';
2248: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lwk, IN l_date;
2249:
2250: SELECT week_end_date
2251: INTO l_sd_lwk_end

Line 2255: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pper_end(:2); END;';

2251: INTO l_sd_lwk_end
2252: from fii_time_day
2253: where report_date=l_sd_lwk;
2254:
2255: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pper_end(:2); END;';
2256: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lper, IN l_date;
2257:
2258: SELECT LEAST(week_end_date, ent_period_end_date)
2259: INTO l_sd_lper_end

Line 2263: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pqtr_end(:2); END;';

2259: INTO l_sd_lper_end
2260: from fii_time_day
2261: where report_date=l_sd_lper;
2262:
2263: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pqtr_end(:2); END;';
2264: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lqtr, IN l_date;
2265:
2266: SELECT LEAST(week_end_date, ent_qtr_end_date)
2267: INTO l_sd_lqtr_end

Line 2271: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_lyr_end(:2); END;';

2267: INTO l_sd_lqtr_end
2268: from fii_time_day
2269: where report_date=l_sd_lqtr;
2270:
2271: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_lyr_end(:2); END;';
2272: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lyr, IN l_date;
2273:
2274: SELECT LEAST(week_end_date, ent_year_end_date)
2275: INTO l_sd_lyr_end

Line 3218: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);

3214:
3215:
3216: --write_log(p_msg => 'Date range:'||l_stg_min_dt||' '||l_stg_max_dt, p_log => 'N');
3217: IF l_stg_min_dt IS NOT NULL AND l_stg_max_dt IS NOT NULL THEN
3218: FII_TIME_API.check_missing_date (l_stg_min_dt,l_stg_max_dt,l_has_missing_date);
3219:
3220: END IF;
3221: IF (l_has_missing_date) THEN
3222: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN

Line 3570: l_dynamic_sql := 'BEGIN :1 := fii_time_api.sd_pwk(:2); END;';

3566: p_msg => 'Start of Procedure '|| l_proc);
3567: END IF;
3568:
3569: BEGIN
3570: l_dynamic_sql := 'BEGIN :1 := fii_time_api.sd_pwk(:2); END;';
3571: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lwk, IN p_date;
3572:
3573: SELECT week_end_date
3574: INTO l_sd_lwk_end

Line 3578: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pper_end(:2); END;';

3574: INTO l_sd_lwk_end
3575: from fii_time_day
3576: where report_date=l_sd_lwk;
3577:
3578: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pper_end(:2); END;';
3579: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lper, IN p_date;
3580:
3581: SELECT LEAST(week_end_date, ent_period_end_date)
3582: INTO l_sd_lper_end

Line 3586: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pqtr_end(:2); END;';

3582: INTO l_sd_lper_end
3583: from fii_time_day
3584: where report_date=l_sd_lper;
3585:
3586: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pqtr_end(:2); END;';
3587: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lqtr, IN p_date;
3588:
3589: SELECT LEAST(week_end_date, ent_qtr_end_date)
3590: INTO l_sd_lqtr_end

Line 3594: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_lyr_end(:2); END;';

3590: INTO l_sd_lqtr_end
3591: from fii_time_day
3592: where report_date=l_sd_lqtr;
3593:
3594: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_lyr_end(:2); END;';
3595: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lyr, IN p_date;
3596:
3597: SELECT LEAST(week_end_date, ent_year_end_date)
3598: INTO l_sd_lyr_end

Line 6376: l_dynamic_sql := 'BEGIN :1 := fii_time_api.sd_pwk(:2); END;';

6372: p_msg => 'Start of Procedure '|| l_proc);
6373: END IF;
6374:
6375: BEGIN
6376: l_dynamic_sql := 'BEGIN :1 := fii_time_api.sd_pwk(:2); END;';
6377: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lwk, IN p_date;
6378:
6379: SELECT week_end_date
6380: INTO l_sd_lwk_end

Line 6384: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pper_end(:2); END;';

6380: INTO l_sd_lwk_end
6381: from fii_time_day
6382: where report_date=l_sd_lwk;
6383:
6384: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pper_end(:2); END;';
6385: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lper, IN p_date;
6386:
6387: SELECT LEAST(week_end_date, ent_period_end_date)
6388: INTO l_sd_lper_end

Line 6392: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pqtr_end(:2); END;';

6388: INTO l_sd_lper_end
6389: from fii_time_day
6390: where report_date=l_sd_lper;
6391:
6392: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_pqtr_end(:2); END;';
6393: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lqtr, IN p_date;
6394:
6395: SELECT LEAST(week_end_date, ent_qtr_end_date)
6396: INTO l_sd_lqtr_end

Line 6400: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_lyr_end(:2); END;';

6396: INTO l_sd_lqtr_end
6397: from fii_time_day
6398: where report_date=l_sd_lqtr;
6399:
6400: l_dynamic_sql := 'BEGIN :1 := fii_time_api.ent_sd_lyr_end(:2); END;';
6401: EXECUTE IMMEDIATE l_dynamic_sql USING OUT l_sd_lyr, IN p_date;
6402:
6403: SELECT LEAST(week_end_date, ent_year_end_date)
6404: INTO l_sd_lyr_end