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_FCST_MGMT_RPTS_PKG dependencies on BIL_BI_UTIL_PKG

Line 160: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

156: WHERE LOOKUP_TYPE = l_lookup_type
157: AND LOOKUP_CODE = l_lookup_code
158: AND LANGUAGE = l_lang;
159:
160: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
161: ,p_region_id => l_region_id
162: ,x_period_type => l_period_type
163: ,x_conv_rate_selected => l_conv_rate_selected
164: ,x_sg_id => l_sg_id

Line 179: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl

175: ,x_record_type_id => l_record_type_id
176: ,x_viewby => l_viewby );
177:
178: /*
179: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl
180: ,p_as_of_date => l_curr_as_of_date
181: ,p_period_type => NULL
182: ,x_snapshot_date => l_snap_date);
183: */

Line 205: l_drill_str:=BIL_BI_UTIL_PKG.GET_DRILL_LINKS(p_view_by => l_viewby

201: *******************************************************************************/
202:
203: IF l_parameter_valid THEN
204:
205: l_drill_str:=BIL_BI_UTIL_PKG.GET_DRILL_LINKS(p_view_by => l_viewby
206: ,p_salesgroup_id => l_sg_id
207: ,p_resource_id => l_resource_id);
208:
209: IF l_prodcat_id IS NULL THEN

Line 234: l_prev_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

230:
231: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */
232:
233:
234: l_prev_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
235: p_period_type => l_page_period_type ,
236: p_compare_to => l_comp_type,
237: p_column_type => 'P',
238: p_curr_suffix => l_currency_suffix

Line 243: l_prv_wt_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

239: );
240:
241:
242:
243: l_prv_wt_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
244: p_period_type => l_page_period_type ,
245: p_compare_to => l_comp_type,
246: p_column_type => 'W',
247: p_curr_suffix => l_currency_suffix

Line 251: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */

247: p_curr_suffix => l_currency_suffix
248: );
249:
250:
251: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
252:
253:
254:
255: BIL_BI_UTIL_PKG.GET_PIPE_MV(

Line 255: BIL_BI_UTIL_PKG.GET_PIPE_MV(

251: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
252:
253:
254:
255: BIL_BI_UTIL_PKG.GET_PIPE_MV(
256: p_asof_date => l_curr_as_of_date ,
257: p_period_type => l_page_period_type ,
258: p_compare_to => l_comp_type ,
259: p_prev_date => l_prev_date,

Line 604: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );

600: ELSE
601: l_where_clause3 := ' WHERE sumry.snap_date in (:l_snapshot_date) ';
602: END IF;
603:
604: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );
605:
606: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
607: x_calendar_id =>l_calendar_id,
608: x_curr_date =>l_bis_sysdate,

Line 606: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,

602: END IF;
603:
604: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );
605:
606: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
607: x_calendar_id =>l_calendar_id,
608: x_curr_date =>l_bis_sysdate,
609: x_fii_struct =>l_fii_struct);
610:

Line 643: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

639: END IF;
640:
641:
642:
643: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
644: p_prodcat => l_prodcat_id,
645: p_viewby => l_viewby,
646: x_denorm => l_pipe_denorm,
647: x_where_clause => l_pipe_product_where_clause);

Line 1079: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;

1075: salesrep_id,
1076: NULL BIL_URL1
1077: ';
1078:
1079: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;
1080:
1081: l_sumry := 'BIL_BI_FST_PG_MV';
1082: l_sumry1 := 'BIL_BI_OPTY_PG_MV';
1083: -- l_sumry2 := 'BIL_BI_PIPE_G_MV';

Line 1726: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

1722:
1723:
1724: ELSE --no valid parameters
1725:
1726: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
1727: ,x_sqlstr => x_custom_sql);
1728: END IF;
1729:
1730: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1885: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

1881: WHERE LOOKUP_TYPE = l_lookup_type
1882: AND LOOKUP_CODE = l_lookup_code
1883: AND LANGUAGE = l_lang;
1884:
1885: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
1886: ,p_region_id => l_region_id
1887: ,x_period_type => l_period_type
1888: ,x_conv_rate_selected => l_conv_rate_selected
1889: ,x_sg_id => l_sg_id

Line 1905: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl

1901: ,x_viewby => l_viewby );
1902:
1903:
1904: /*
1905: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl
1906: ,p_as_of_date => l_curr_as_of_date
1907: ,p_period_type => NULL
1908: ,x_snapshot_date => l_snap_date);
1909: */

Line 1936: BIL_BI_UTIL_PKG.GET_PRIOR_PRIOR_TIME (p_comp_type => l_comp_type,

1932:
1933: l_viewby:='ITEM+ENI_ITEM_VBH_CAT';
1934:
1935:
1936: BIL_BI_UTIL_PKG.GET_PRIOR_PRIOR_TIME (p_comp_type => l_comp_type,
1937: p_period_type => l_page_period_type,
1938: p_prev_date => l_prev_date,
1939: p_prev_page_time_id => l_prev_page_time_id,
1940: x_prior_prior_date => l_prior_prior_date,

Line 1969: l_pipe_url:=BIL_BI_UTIL_PKG.GET_DRILL_LINKS(p_view_by => l_viewby

1965: 'BIL_MEASURE6,BIL_MEASURE7,BIL_MEASURE8,BIL_MEASURE9,BIL_MEASURE10,BIL_MEASURE11,'||
1966: 'BIL_MEASURE12,BIL_URL1,BIL_URL2)';
1967:
1968:
1969: l_pipe_url:=BIL_BI_UTIL_PKG.GET_DRILL_LINKS(p_view_by => l_viewby
1970: ,p_salesgroup_id => l_sg_id
1971: ,p_resource_id => l_resource_id);
1972:
1973: l_url_str:='pFunctionName=BIL_BI_FSTOVER_R&pParamIds=Y&VIEW_BY='||l_viewby||'&VIEW_BY_NAME=VIEW_BY_ID';

Line 1979: l_prev_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

1975:
1976: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */
1977:
1978:
1979: l_prev_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
1980: p_period_type => l_page_period_type ,
1981: p_compare_to => l_comp_type,
1982: p_column_type => 'P',
1983: p_curr_suffix => l_currency_suffix

Line 1988: l_prv_wt_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

1984: );
1985:
1986:
1987:
1988: l_prv_wt_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
1989: p_period_type => l_page_period_type ,
1990: p_compare_to => l_comp_type,
1991: p_column_type => 'W',
1992: p_curr_suffix => l_currency_suffix

Line 1996: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */

1992: p_curr_suffix => l_currency_suffix
1993: );
1994:
1995:
1996: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
1997:
1998: BIL_BI_UTIL_PKG.GET_PIPE_MV(
1999: p_asof_date => l_curr_as_of_date ,
2000: p_period_type => l_page_period_type ,

Line 1998: BIL_BI_UTIL_PKG.GET_PIPE_MV(

1994:
1995:
1996: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
1997:
1998: BIL_BI_UTIL_PKG.GET_PIPE_MV(
1999: p_asof_date => l_curr_as_of_date ,
2000: p_period_type => l_page_period_type ,
2001: p_compare_to => l_comp_type ,
2002: p_prev_date => l_prev_date,

Line 2222: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );

2218: END IF;
2219:
2220:
2221:
2222: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );
2223:
2224:
2225: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
2226: x_calendar_id =>l_calendar_id,

Line 2225: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,

2221:
2222: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );
2223:
2224:
2225: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
2226: x_calendar_id =>l_calendar_id,
2227: x_curr_date =>l_bis_sysdate,
2228: x_fii_struct =>l_fii_struct);
2229:

Line 2265: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

2261: MESSAGE => l_sql_error_desc);
2262:
2263: END IF;
2264:
2265: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
2266: p_prodcat => l_prodcat_id,
2267: p_viewby => l_viewby,
2268: x_denorm => l_pipe_denorm,
2269: x_where_clause => l_pipe_product_where_clause);

Line 2338: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;

2334: salesrep_id,
2335: BIL_URL2
2336: ';
2337:
2338: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;
2339:
2340: l_sumry := 'BIL_BI_FST_PG_MV';
2341: -- l_sumry2 := 'BIL_BI_PIPE_G_MV';
2342: l_sumry2 := l_open_mv_new;

Line 3193: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

3189: END IF;
3190:
3191: ELSE --no valid parameters
3192:
3193: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
3194: ,x_sqlstr => x_custom_sql);
3195: END IF;
3196:
3197: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN