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

Line 185: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

181:
182: END IF;
183:
184:
185: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
186: ,p_region_id => l_region_id
187: ,x_period_type => l_period_type
188: ,x_conv_rate_selected => l_conv_rate_selected
189: ,x_sg_id => l_sg_id

Line 279: bil_bi_util_pkg.get_latest_snap_date(p_page_parameter_tbl => p_page_parameter_tbl

275: END IF;
276:
277:
278: /*
279: bil_bi_util_pkg.get_latest_snap_date(p_page_parameter_tbl => p_page_parameter_tbl
280: ,p_as_of_date => l_curr_as_of_date
281: ,p_period_type => NULL
282: ,x_snapshot_date => l_snap_date);
283: */

Line 303: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id

299: ELSE
300: l_prodcat := REPLACE(l_prodcat,'''','');
301: END IF;
302:
303: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id
304: ,x_calendar_id => l_calendar_id
305: ,x_curr_date => l_bis_sysdate
306: ,x_fii_struct => l_fii_struct);
307:

Line 312: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,

308:
309:
310: -- Get the Drill Link to the Opty Line Detail Report
311:
312: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,
313: p_salesgroup_id => l_sg_id,
314: p_resource_id => l_resource_id );
315:
316:

Line 323: l_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

319:
320: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */
321:
322:
323: l_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
324: p_period_type => l_page_period_type ,
325: p_compare_to => l_comp_type,
326: p_column_type => 'P',
327: p_curr_suffix => l_currency_suffix

Line 330: l_wt_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

326: p_column_type => 'P',
327: p_curr_suffix => l_currency_suffix
328: );
329:
330: l_wt_pipe_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
331: p_period_type => l_page_period_type ,
332: p_compare_to => l_comp_type,
333: p_column_type => 'W',
334: p_curr_suffix => l_currency_suffix

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

334: p_curr_suffix => l_currency_suffix
335: );
336:
337:
338: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
339:
340: BIL_BI_UTIL_PKG.GET_PIPE_MV(
341: p_asof_date => l_curr_as_of_date ,
342: p_period_type => l_page_period_type ,

Line 340: BIL_BI_UTIL_PKG.GET_PIPE_MV(

336:
337:
338: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
339:
340: BIL_BI_UTIL_PKG.GET_PIPE_MV(
341: p_asof_date => l_curr_as_of_date ,
342: p_period_type => l_page_period_type ,
343: p_compare_to => l_comp_type ,
344: p_prev_date => l_prev_date,

Line 504: l_pipe := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

500: l_wtd_pipe := 'wtd_pipeline_amt_week'||l_currency_suffix;
501: END CASE;
502: */
503:
504: l_pipe := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
505: p_period_type => l_page_period_type ,
506: p_compare_to => NULL,
507: p_column_type => 'P',
508: p_curr_suffix => l_currency_suffix

Line 511: l_wtd_pipe := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

507: p_column_type => 'P',
508: p_curr_suffix => l_currency_suffix
509: );
510:
511: l_wtd_pipe := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
512: p_period_type => l_page_period_type ,
513: p_compare_to => NULL,
514: p_column_type => 'W',
515: p_curr_suffix => l_currency_suffix

Line 722: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

718: l_inner_where_clause := ' AND sumry.snap_date in (:l_snapshot_date) ';
719: END IF;
720:
721:
722: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
723: p_prodcat => l_prodcat,
724: p_viewby => l_viewby,
725: x_denorm => l_pipe_denorm,
726: x_where_clause => l_pipe_product_where_clause);

Line 885: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;

881: END IF;
882:
883:
884: IF 'All' = l_prodcat THEN
885: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;
886: l_custom_sql := 'SELECT NULL VIEWBY '||
887: ', 1 '||l_inner_select||
888: ',pcd.parent_id VIEWBYID '||
889: ',NULL BIL_URL1 '||

Line 972: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'

968:
969:
970: ELSE -- Product category selected
971:
972: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
973: ,p_lookupcode => 'ASSIGN_CATEG');
974:
975: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
976:

Line 1295: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

1291: x_custom_attr(l_bind_ctr):=l_custom_rec;
1292: l_bind_ctr:=l_bind_ctr+1;
1293:
1294: ELSE --Invalid parameters
1295: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
1296: ,x_sqlstr => x_custom_sql);
1297:
1298:
1299:

Line 1529: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

1525:
1526: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1527: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1528:
1529: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
1530: ,p_region_id => l_region_id
1531: ,x_period_type => l_period_type
1532: ,x_conv_rate_selected => l_conv_rate_selected
1533: ,x_sg_id => l_sg_id

Line 1549: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl

1545: ,x_viewby => l_viewby);
1546:
1547:
1548: /*
1549: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl
1550: ,p_as_of_date => l_curr_as_of_date
1551: ,p_period_type => NULL
1552: ,x_snapshot_date => l_snap_date);
1553: */

Line 1560: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id

1556: END IF;*/
1557:
1558:
1559: IF l_parameter_valid THEN
1560: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id
1561: ,x_calendar_id => l_calendar_id
1562: ,x_curr_date => l_bis_sysdate
1563: ,x_fii_struct => l_fii_struct);
1564:

Line 1609: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,

1605:
1606:
1607: -- Get the Drill Link to the Opty Line Detail Report
1608:
1609: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,
1610: p_salesgroup_id => l_sg_id,
1611: p_resource_id => l_resource_id );
1612:
1613:

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

1611: p_resource_id => l_resource_id );
1612:
1613:
1614:
1615: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
1616:
1617: -- This API calll is to find whether Period Start_date lies in Current or Historical range.
1618:
1619: BIL_BI_UTIL_PKG.GET_PIPE_MV(

Line 1619: BIL_BI_UTIL_PKG.GET_PIPE_MV(

1615: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
1616:
1617: -- This API calll is to find whether Period Start_date lies in Current or Historical range.
1618:
1619: BIL_BI_UTIL_PKG.GET_PIPE_MV(
1620: p_asof_date => l_start_date ,
1621: p_period_type => l_page_period_type ,
1622: p_compare_to => l_comp_type ,
1623: p_prev_date => l_prev_date,

Line 1632: BIL_BI_UTIL_PKG.GET_PIPE_MV(

1628: );
1629:
1630: -- This API calll is to find the snapshot date based on the l_asof_date.
1631:
1632: BIL_BI_UTIL_PKG.GET_PIPE_MV(
1633: p_asof_date => l_curr_as_of_date ,
1634: p_period_type => l_page_period_type ,
1635: p_compare_to => l_comp_type ,
1636: p_prev_date => l_prev_date,

Line 1817: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

1813: AND BIL_MEASURE4 IS NULL
1814: AND BIL_MEASURE5 IS NULL
1815: AND BIL_MEASURE6 IS NULL) ';
1816:
1817: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
1818: p_prodcat => l_prodcat,
1819: p_viewby => l_viewby,
1820: x_denorm => l_pipe_denorm,
1821: x_where_clause => l_pipe_product_where_clause);

Line 1995: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;

1991:
1992:
1993: IF 'All' = l_prodcat THEN
1994:
1995: l_unassigned_value := BIL_BI_UTIL_PKG.GET_UNASSIGNED_PC;
1996:
1997: x_custom_sql := l_outer_select ||
1998: ' FROM ('||l_inner_select||
1999: ' FROM ( '||

Line 2054: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'

2050:
2051: --Prod cat chosen
2052: ELSE
2053: --For 'Assigned to Category' message
2054: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
2055: ,p_lookupcode => 'ASSIGN_CATEG');
2056:
2057: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2058:

Line 2385: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

2381: l_bind_ctr:=l_bind_ctr+1;
2382: END IF;
2383:
2384: ELSE
2385: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
2386: ,x_sqlstr => x_custom_sql);
2387:
2388: END IF;
2389:

Line 2524: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID

2520: END IF;
2521:
2522: ELSIF p_page_parameter_tbl(i).parameter_name = 'ORGANIZATION+JTF_ORG_SALES_GROUP' THEN
2523: l_salesgroup_id := p_page_parameter_tbl(i).parameter_id;
2524: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID
2525: (
2526: p_salesgroup_id =>l_salesgroup_id,
2527: x_resource_id =>l_resource_id
2528: );

Line 2779: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id,x_sqlstr => l_select_stmt);

2775: x_custom_attr(l_bind_ctr):=l_custom_rec;
2776: l_bind_ctr:=l_bind_ctr+1;
2777:
2778: ELSE
2779: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id,x_sqlstr => l_select_stmt);
2780: x_custom_sql := l_select_stmt;
2781: END IF;
2782:
2783: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2915: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID

2911: l_err := 'l_currency';
2912: END IF;
2913: ELSIF p_page_parameter_tbl(i).parameter_name = 'ORGANIZATION+JTF_ORG_SALES_GROUP' THEN
2914: l_salesgroup_id := p_page_parameter_tbl(i).parameter_id;
2915: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID
2916: (
2917: p_salesgroup_id =>l_salesgroup_id,
2918: x_resource_id =>l_resource_id
2919: );