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_PERIOD

Line 774: -- ER #2467584 for gettig previous time_id e.g. TIME+FII_TIME_ENT_PERIOD_PFROM and TIME+FII_TIME_ENT_PERIOD_PTO

770: WHEN 'ITEM+ENI_ITEM_VBH_CAT' THEN
771:
772: x_prodcat_id := p_page_parameter_tbl(i).parameter_id;
773:
774: -- ER #2467584 for gettig previous time_id e.g. TIME+FII_TIME_ENT_PERIOD_PFROM and TIME+FII_TIME_ENT_PERIOD_PTO
775: -- get values for p_prev_page_time_id to implement ER#2467584
776:
777: WHEN 'TIME+FII_TIME_WEEK_PFROM' THEN
778: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;

Line 780: WHEN 'TIME+FII_TIME_ENT_PERIOD_PFROM' THEN

776:
777: WHEN 'TIME+FII_TIME_WEEK_PFROM' THEN
778: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;
779:
780: WHEN 'TIME+FII_TIME_ENT_PERIOD_PFROM' THEN
781: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;
782:
783: WHEN 'TIME+FII_TIME_ENT_QTR_PFROM' THEN
784: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;

Line 793: WHEN 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN

789: -- get values for x_curr_page_time_id
790: WHEN 'TIME+FII_TIME_WEEK_FROM' THEN
791: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_WEEK_FROM';
792:
793: WHEN 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN
794: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_PERIOD_FROM';
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';

Line 794: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_PERIOD_FROM';

790: WHEN 'TIME+FII_TIME_WEEK_FROM' THEN
791: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_WEEK_FROM';
792:
793: WHEN 'TIME+FII_TIME_ENT_PERIOD_FROM' THEN
794: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_ENT_PERIOD_FROM';
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:

Line 862: WHEN 'FII_TIME_ENT_PERIOD' THEN x_period_type := 32; x_record_type_id := 64;

858: --Week :11
859:
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

Line 1137: /* View by is one of ORGANIZATION+JTF_ORG_SALES_GROUP, TIME+FII_TIME_WEEK, TIME+FII_TIME_ENT_PERIOD

1133: END IF;
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 ';

Line 1221: /* View by is one of ORGANIZATION+JTF_ORG_SALES_GROUP, TIME+FII_TIME_WEEK, TIME+FII_TIME_ENT_PERIOD

1217:
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''

Line 1266: -- month - fii_time_ent_period

1262: -- Purpose:
1263: -- used by the trend queries, returns the start and end dates of the trend
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,

Line 1304: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_TO' THEN

1300: -- GET values for &BIS_CUR_EFFECTIVE_END_DATE
1301: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_WEEK_TO' THEN
1302: x_curr_eff_end_date := p_page_parameter_tbl(i).period_date;
1303: END IF;
1304: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_TO' THEN
1305: x_curr_eff_end_date := p_page_parameter_tbl(i).period_date;
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;

Line 1317: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_PTO' THEN

1313: -- GET values for &BIS_PREVIOUS_EFFECTIVE_END_DATE
1314: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_WEEK_PTO' THEN
1315: x_prev_eff_end_date := p_page_parameter_tbl(i).period_date;
1316: END IF;
1317: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_ENT_PERIOD_PTO' THEN
1318: x_prev_eff_end_date := p_page_parameter_tbl(i).period_date;
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;

Line 1346: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then

1342: WHEN p_page_period_type = 'FII_TIME_WEEK' then
1343: x_table_name := 'fii_time_week';
1344: x_column_name := 'week_id';
1345:
1346: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then
1347: x_table_name := 'fii_time_ent_period';
1348: x_column_name := 'ent_period_id';
1349: /*
1350: -- Get p_startprd_id

Line 1347: x_table_name := 'fii_time_ent_period';

1343: x_table_name := 'fii_time_week';
1344: x_column_name := 'week_id';
1345:
1346: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then
1347: x_table_name := 'fii_time_ent_period';
1348: x_column_name := 'ent_period_id';
1349: /*
1350: -- Get p_startprd_id
1351: SELECT ent_period_id

Line 1353: FROM fii_time_ent_period

1349: /*
1350: -- Get p_startprd_id
1351: SELECT ent_period_id
1352: INTO x_curr_startprd_id
1353: FROM fii_time_ent_period
1354: WHERE x_curr_start_date BETWEEN start_date AND end_date;
1355:
1356: IF p_comp_type = 'YEARLY' then
1357: -- Get p_prev_startprd_id

Line 1361: FROM fii_time_ent_period

1357: -- Get p_prev_startprd_id
1358:
1359: SELECT ent_period_id
1360: INTO x_prev_startprd_id
1361: FROM fii_time_ent_period
1362: WHERE x_prev_start_date BETWEEN start_date AND end_date;
1363:
1364: END IF;
1365: */

Line 1722: ELSIF (p_period_type = 'FII_TIME_ENT_PERIOD') THEN

1718: WHERE w.period445_id=p.period445_id
1719: AND w.sequence=l_sequence
1720: AND p.year445_id=l_year;
1721:
1722: ELSIF (p_period_type = 'FII_TIME_ENT_PERIOD') THEN
1723:
1724: SELECT p.end_date-l_prev_date, p.sequence, p.ent_year_id
1725: INTO l_timespan, l_sequence, l_year
1726: FROM fii_time_ent_period p

Line 1726: FROM fii_time_ent_period p

1722: ELSIF (p_period_type = 'FII_TIME_ENT_PERIOD') THEN
1723:
1724: SELECT p.end_date-l_prev_date, p.sequence, p.ent_year_id
1725: INTO l_timespan, l_sequence, l_year
1726: FROM fii_time_ent_period p
1727: WHERE l_prev_date BETWEEN p.start_date AND p.end_date;
1728:
1729: IF p_comp_type='SEQUENTIAL' THEN
1730: if l_sequence=1 then

Line 1736: FROM fii_time_ent_period p

1732: l_year:=l_year-1;
1733:
1734: SELECT MAX(p.sequence)
1735: INTO l_sequence
1736: FROM fii_time_ent_period p
1737: WHERE p.ent_year_id=l_year;
1738: else
1739:
1740: l_sequence:=l_sequence-1;

Line 1749: FROM fii_time_ent_period p

1745: END IF;
1746:
1747: SELECT ent_period_id, GREATEST(p.start_date, p.end_date-l_timespan)
1748: INTO l_prior_prior_time_id, l_prior_prior_date
1749: FROM fii_time_ent_period p
1750: WHERE p.sequence=l_sequence
1751: AND p.ent_year_id=l_year;
1752:
1753: ELSIF (p_period_type = 'FII_TIME_ENT_QTR') THEN

Line 2304: IF (l_period_type = 'FII_TIME_ENT_PERIOD') THEN

2300: FROM FII_TIME_DAY
2301: WHERE report_date = l_as_of_date;
2302:
2303:
2304: IF (l_period_type = 'FII_TIME_ENT_PERIOD') THEN
2305:
2306: IF (l_period_end_date= l_as_of_date) THEN
2307: l_end_date := l_as_of_date;
2308: ELSE

Line 2416: WHEN l_period_type = 'FII_TIME_ENT_PERIOD' THEN

2412: CASE
2413: WHEN l_period_type = 'FII_TIME_WEEK' THEN
2414: l_prev_amt := 'PRVPRD'||l_prev_amt||'WK';
2415:
2416: WHEN l_period_type = 'FII_TIME_ENT_PERIOD' THEN
2417: l_prev_amt := 'PRVPRD'||l_prev_amt||'PRD';
2418:
2419: WHEN l_period_type = 'FII_TIME_ENT_QTR' THEN
2420: l_prev_amt := 'PRVPRD'||l_prev_amt||'QTR';

Line 2430: WHEN l_period_type = 'FII_TIME_ENT_PERIOD' THEN

2426: CASE
2427: WHEN l_period_type = 'FII_TIME_WEEK' THEN
2428: l_prev_amt := 'PRVYR'||l_prev_amt||'WK';
2429:
2430: WHEN l_period_type = 'FII_TIME_ENT_PERIOD' THEN
2431: l_prev_amt := 'PRVYR'||l_prev_amt||'PRD';
2432:
2433: WHEN l_period_type = 'FII_TIME_ENT_QTR' THEN
2434: l_prev_amt := 'PRVYR'||l_prev_amt||'QTR';

Line 2454: WHEN l_period_type = 'FII_TIME_ENT_PERIOD' THEN

2450: CASE
2451: WHEN l_period_type = 'FII_TIME_WEEK' THEN
2452: l_prev_amt := l_prev_amt||'WEEK';
2453:
2454: WHEN l_period_type = 'FII_TIME_ENT_PERIOD' THEN
2455: l_prev_amt := l_prev_amt||'PERIOD';
2456:
2457: WHEN l_period_type = 'FII_TIME_ENT_QTR' THEN
2458: l_prev_amt := l_prev_amt||'QUARTER';