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_WEEK

Line 777: WHEN 'TIME+FII_TIME_WEEK_PFROM' THEN

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;
779:
780: WHEN 'TIME+FII_TIME_ENT_PERIOD_PFROM' THEN
781: x_prev_page_time_id := p_page_parameter_tbl(i).parameter_id;

Line 790: WHEN 'TIME+FII_TIME_WEEK_FROM' THEN

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
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';

Line 791: x_curr_page_time_id := p_page_parameter_tbl(i).parameter_id; --'+FII_TIME_WEEK_FROM';

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

Line 861: WHEN 'FII_TIME_WEEK' THEN x_period_type := 16; x_record_type_id := 32;

857: --Month :23
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:

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 1265: -- week - fii_time_week

1261: --
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: -- **********************************************************************

Line 1301: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_WEEK_TO' THEN

1297: IF p_page_parameter_tbl(i).parameter_name = 'BIS_PREV_REPORT_START_DATE' THEN
1298: x_prev_start_date:= p_page_parameter_tbl(i).period_date;
1299: END IF;
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;

Line 1314: IF p_page_parameter_tbl(i).parameter_name = 'TIME+FII_TIME_WEEK_PTO' THEN

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
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;

Line 1342: WHEN p_page_period_type = 'FII_TIME_WEEK' then

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';
1344: x_column_name := 'week_id';
1345:
1346: WHEN p_page_period_type = 'FII_TIME_ENT_PERIOD' then

Line 1343: x_table_name := 'fii_time_week';

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';
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';

Line 1688: IF (p_period_type = 'FII_TIME_WEEK') THEN

1684: IF (TRUNC(p_prev_date)>(bis_common_parameters.get_global_start_date-1)) THEN
1685:
1686: l_prev_date := TRUNC(p_prev_date);
1687:
1688: IF (p_period_type = 'FII_TIME_WEEK') THEN
1689:
1690: SELECT l_prev_date-w.start_date, w.sequence, p.year445_id
1691: INTO l_timespan, l_sequence, l_year
1692: FROM fii_time_week w, fii_time_p445 p

Line 1692: FROM fii_time_week w, fii_time_p445 p

1688: IF (p_period_type = 'FII_TIME_WEEK') THEN
1689:
1690: SELECT l_prev_date-w.start_date, w.sequence, p.year445_id
1691: INTO l_timespan, l_sequence, l_year
1692: FROM fii_time_week w, fii_time_p445 p
1693: WHERE w.period445_id=p.period445_id
1694: AND l_prev_date BETWEEN w.start_date AND w.end_date;
1695:
1696: IF p_comp_type='SEQUENTIAL' THEN

Line 1703: FROM fii_time_week w, fii_time_p445 p

1699: l_year:=l_year-1;
1700:
1701: SELECT MAX(w.sequence)
1702: INTO l_sequence
1703: FROM fii_time_week w, fii_time_p445 p
1704: WHERE w.period445_id=p.period445_id
1705: AND p.year445_id=l_year;
1706: else
1707:

Line 1717: FROM fii_time_week w, fii_time_p445 p

1713: END IF;
1714:
1715: SELECT w.week_id, w.start_date+l_timespan
1716: INTO l_prior_prior_time_id, l_prior_prior_date
1717: FROM fii_time_week w, fii_time_p445 p
1718: WHERE w.period445_id=p.period445_id
1719: AND w.sequence=l_sequence
1720: AND p.year445_id=l_year;
1721:

Line 2413: WHEN l_period_type = 'FII_TIME_WEEK' THEN

2409: -- TIME_COMPARISON_TYPE+YEARLY && TIME_COMPARISON_TYPE+SEQUENTIAL
2410:
2411: IF(l_compare_to = 'SEQUENTIAL') 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';

Line 2427: WHEN l_period_type = 'FII_TIME_WEEK' THEN

2423: l_prev_amt := 'PRVPRD'||l_prev_amt||'YR';
2424: END CASE;
2425: ELSIF (l_compare_to = 'YEARLY') 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';

Line 2451: WHEN l_period_type = 'FII_TIME_WEEK' THEN

2447: WHEN upper(l_column_type) = 'W' THEN l_prev_amt := 'WTD_PIPELINE_AMT_';
2448: END CASE;
2449:
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';