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.

[Home] [Help]

APPS.BIL_BI_UTIL_PKG dependencies on FII_TIME_ENT_YEAR

Line 786: WHEN 'TIME+FII_TIME_ENT_YEAR_PFROM' THEN

782:
783: WHEN 'TIME+FII_TIME_ENT_QTR_PFROM' THEN
784: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;
785:
786: WHEN 'TIME+FII_TIME_ENT_YEAR_PFROM' THEN
787: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;
788:
789: -- get values for x_curr_page_time_id
790: WHEN 'TIME+FII_TIME_WEEK_FROM' THEN

Line 799: WHEN 'TIME+FII_TIME_ENT_YEAR_FROM' THEN

795:
796: WHEN 'TIME+FII_TIME_ENT_QTR_FROM' THEN
797: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_QTR_FROM';
798:
799: WHEN 'TIME+FII_TIME_ENT_YEAR_FROM' THEN
800: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_YEAR_FROM';
801:
802: ELSE
803:

Line 800: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_YEAR_FROM';

796: WHEN 'TIME+FII_TIME_ENT_QTR_FROM' THEN
797: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_QTR_FROM';
798:
799: WHEN 'TIME+FII_TIME_ENT_YEAR_FROM' THEN
800: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_YEAR_FROM';
801:
802: ELSE
803:
804: NULL;

Line 864: WHEN 'FII_TIME_ENT_YEAR' THEN x_period_type := 128; x_record_type_id := 256;

860: CASE x_page_period_type
861: WHEN 'FII_TIME_WEEK' THEN x_period_type := 16; x_record_type_id := 32;
862: WHEN 'FII_TIME_ENT_PERIOD' THEN x_period_type := 32; x_record_type_id := 64;
863: WHEN 'FII_TIME_ENT_QTR' THEN x_period_type := 64; x_record_type_id := 128;
864: WHEN 'FII_TIME_ENT_YEAR' THEN x_period_type := 128; x_record_type_id := 256;
865:
866: ELSE
867:
868: l_parameter_valid := FALSE;

Line 1138: , TIME+FII_TIME_ENT_QTR, TIME+FII_TIME_ENT_YEAR, CAMPAIGN+CAMPAIGN */

1134:
1135: ELSE
1136:
1137: /* View by is one of ORGANIZATION+JTF_ORG_SALES_GROUP, TIME+FII_TIME_WEEK, TIME+FII_TIME_ENT_PERIOD
1138: , TIME+FII_TIME_ENT_QTR, TIME+FII_TIME_ENT_YEAR, CAMPAIGN+CAMPAIGN */
1139: IF 'ALL' <> UPPER(p_prodcat) THEN
1140: l_product_where_clause := ' AND sumry.product_category_id = :l_prodcat '||
1141: ' AND sumry.item_id IS NULL ';
1142: END IF;

Line 1222: , TIME+FII_TIME_ENT_QTR, TIME+FII_TIME_ENT_YEAR, CAMPAIGN+CAMPAIGN */

1218: END IF;
1219:
1220: ELSE
1221: /* View by is one of ORGANIZATION+JTF_ORG_SALES_GROUP, TIME+FII_TIME_WEEK, TIME+FII_TIME_ENT_PERIOD
1222: , TIME+FII_TIME_ENT_QTR, TIME+FII_TIME_ENT_YEAR, CAMPAIGN+CAMPAIGN */
1223: IF 'ALL' <> UPPER(p_prodcat) THEN
1224: l_product_where_clause := ' AND sumry.product_category_id = eni1.child_id
1225: AND eni1.object_type = ''CATEGORY_SET''
1226: AND eni1.object_id = d.category_set_id

Line 1268: -- year - fii_time_ent_year

1264: -- span, time id, and fii time table depending on the period type
1265: -- week - fii_time_week
1266: -- month - fii_time_ent_period
1267: -- quarter - fii_time_ent_qtr
1268: -- year - fii_time_ent_year
1269: -- **********************************************************************
1270: PROCEDURE GET_TREND_PARAMS( p_comp_type IN VARCHAR2,
1271: p_curr_as_of_date IN DATE,
1272: p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,

Line 1310: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_TO' THEN

1306: END IF;
1307: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_QTR_TO' THEN
1308: x_curr_eff_end_date := p_page_parameter_tbl(i).period_date;
1309: END IF;
1310: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_TO' THEN
1311: x_curr_eff_end_date := p_page_parameter_tbl(i).period_date;
1312: END IF;
1313: -- GET values for &BIS_PREVIOUS_EFFECTIVE_END_DATE
1314: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_WEEK_PTO' THEN

Line 1323: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_PTO' THEN

1319: END IF;
1320: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_QTR_PTO' THEN
1321: x_prev_eff_end_date := p_page_parameter_tbl(i).period_date;
1322: END IF;
1323: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_YEAR_PTO' THEN
1324: x_prev_eff_end_date := p_page_parameter_tbl(i).period_date;
1325: END IF;
1326: END LOOP;
1327: END IF;

Line 1333: WHEN p_page_period_type = 'FII_TIME_ENT_YEAR' THEN

1329:
1330: CASE
1331:
1332:
1333: WHEN p_page_period_type = 'FII_TIME_ENT_YEAR' THEN
1334: x_table_name := 'fii_time_ent_year';
1335: x_column_name := 'ent_year_id';
1336:
1337: /* SELECT ENT_YEAR_ID

Line 1334: x_table_name := 'fii_time_ent_year';

1330: CASE
1331:
1332:
1333: WHEN p_page_period_type = 'FII_TIME_ENT_YEAR' THEN
1334: x_table_name := 'fii_time_ent_year';
1335: x_column_name := 'ent_year_id';
1336:
1337: /* SELECT ENT_YEAR_ID
1338: INTO x_curr_startprd_id

Line 1339: FROM fii_time_ent_year

1335: x_column_name := 'ent_year_id';
1336:
1337: /* SELECT ENT_YEAR_ID
1338: INTO x_curr_startprd_id
1339: FROM fii_time_ent_year
1340: WHERE x_curr_start_date BETWEEN start_date AND end_date;
1341: */
1342: WHEN p_page_period_type = 'FII_TIME_WEEK' then
1343: x_table_name := 'fii_time_week';

Line 1784: ELSIF (p_period_type = 'FII_TIME_ENT_YEAR') THEN

1780: FROM fii_time_ent_qtr
1781: WHERE sequence=l_sequence
1782: AND ent_year_id=l_year;
1783:
1784: ELSIF (p_period_type = 'FII_TIME_ENT_YEAR') THEN
1785:
1786: SELECT end_date-l_prev_date, sequence
1787: INTO l_timespan, l_year
1788: FROM fii_time_ent_year

Line 1788: FROM fii_time_ent_year

1784: ELSIF (p_period_type = 'FII_TIME_ENT_YEAR') THEN
1785:
1786: SELECT end_date-l_prev_date, sequence
1787: INTO l_timespan, l_year
1788: FROM fii_time_ent_year
1789: WHERE l_prev_date BETWEEN start_date AND end_date;
1790:
1791: SELECT ent_year_id, GREATEST(start_date, end_date-l_timespan)
1792: INTO l_prior_prior_time_id, l_prior_prior_date

Line 1793: FROM fii_time_ent_year

1789: WHERE l_prev_date BETWEEN start_date AND end_date;
1790:
1791: SELECT ent_year_id, GREATEST(start_date, end_date-l_timespan)
1792: INTO l_prior_prior_time_id, l_prior_prior_date
1793: FROM fii_time_ent_year
1794: WHERE sequence=l_year-1;
1795:
1796: END IF;
1797:

Line 2320: ELSIF (l_period_type = 'FII_TIME_ENT_YEAR') THEN

2316: ELSE
2317: l_end_date := LEAST(l_week_end_date, l_qtr_end_date);
2318: END IF;
2319:
2320: ELSIF (l_period_type = 'FII_TIME_ENT_YEAR') THEN
2321:
2322: IF (l_year_end_date= l_as_of_date) THEN
2323: l_end_date := l_as_of_date;
2324: ELSE

Line 2422: WHEN l_period_type = 'FII_TIME_ENT_YEAR' THEN

2418:
2419: WHEN l_period_type = 'FII_TIME_ENT_QTR' THEN
2420: l_prev_amt := 'PRVPRD'||l_prev_amt||'QTR';
2421:
2422: WHEN l_period_type = 'FII_TIME_ENT_YEAR' THEN
2423: l_prev_amt := 'PRVPRD'||l_prev_amt||'YR';
2424: END CASE;
2425: ELSIF (l_compare_to = 'YEARLY') THEN
2426: CASE

Line 2436: WHEN l_period_type = 'FII_TIME_ENT_YEAR' THEN

2432:
2433: WHEN l_period_type = 'FII_TIME_ENT_QTR' THEN
2434: l_prev_amt := 'PRVYR'||l_prev_amt||'QTR';
2435:
2436: WHEN l_period_type = 'FII_TIME_ENT_YEAR' THEN
2437: l_prev_amt := 'PRVYR'||l_prev_amt||'YR';
2438:
2439: END CASE;
2440: END IF;

Line 2460: WHEN l_period_type = 'FII_TIME_ENT_YEAR' THEN

2456:
2457: WHEN l_period_type = 'FII_TIME_ENT_QTR' THEN
2458: l_prev_amt := l_prev_amt||'QUARTER';
2459:
2460: WHEN l_period_type = 'FII_TIME_ENT_YEAR' THEN
2461: l_prev_amt := l_prev_amt||'YEAR';
2462: END CASE;
2463: END IF;
2464: