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

Line 125: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

121:
122: END IF;
123:
124:
125: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
126: ,p_region_id => l_region_id
127: ,x_period_type => l_period_type
128: ,x_conv_rate_selected => l_conv_rate_selected
129: ,x_sg_id => l_sg_id

Line 145: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES(x_FstCrdtType => l_fst_crdt_type);

141: ,x_viewby => l_viewby );
142:
143: IF l_parameter_valid THEN
144:
145: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES(x_FstCrdtType => l_fst_crdt_type);
146:
147: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
148: l_prodcat_id := TO_NUMBER(REPLACE(l_prodcat_id,''''));
149:

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

146:
147: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
148: l_prodcat_id := TO_NUMBER(REPLACE(l_prodcat_id,''''));
149:
150: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id,
151: x_calendar_id => l_calendar_id,
152: x_curr_date => l_bis_sysdate,
153: x_fii_struct => l_fii_struct);
154:

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

200:
201:
202: -- Get the Drill Link to the Opty Line Detail Report
203:
204: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,
205: p_salesgroup_id => l_sg_id,
206: p_resource_id => l_resource_id );
207:
208:

Line 443: BIL_BI_UTIL_PKG.GET_PRODUCT_WHERE_CLAUSE(p_viewby => l_viewby,

439:
440:
441: --l_denorm is used in the forecast and ISC query, product where clause
442: --is ignored since it is assigned locally.
443: BIL_BI_UTIL_PKG.GET_PRODUCT_WHERE_CLAUSE(p_viewby => l_viewby,
444: p_prodcat => l_prodcat_id,
445: x_denorm => l_denorm,
446: x_where_clause => l_product_where_clause);
447:

Line 449: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(p_viewby => l_viewby,

445: x_denorm => l_denorm,
446: x_where_clause => l_product_where_clause);
447:
448: --reusing the local var for product where clause
449: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(p_viewby => l_viewby,
450: p_prodcat => l_prodcat_id,
451: x_denorm => l_opty_denorm,
452: x_where_clause => l_product_where_clause);
453:

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

673:
674:
675: WHEN 'ITEM+ENI_ITEM_VBH_CAT' THEN
676:
677: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
678: ,p_lookupcode => 'ASSIGN_CATEG');
679:
680: l_cat_url := 'pFunctionName=BIL_BI_SLSMGMT_R&pParamIds=Y&VIEW_BY='||l_viewby||'&VIEW_BY_NAME=VIEW_BY_ID';
681: l_inner_select := l_inner_select ||

Line 726: l_unassigned_value:= bil_bi_util_pkg.GET_UNASSIGNED_PC;

722: l_from3 := l_fii_struct ||' cal, '|| l_sumry3 ||' sumry ';
723:
724: IF l_prodcat_id = 'All' THEN
725:
726: l_unassigned_value:= bil_bi_util_pkg.GET_UNASSIGNED_PC;
727:
728: --Opportunity by prod cat
729: x_custom_sql := l_inner_select ||
730:

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

862:
863:
864: ELSE -- prodcat selected
865:
866: -- l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
867: -- ,p_lookupcode => 'ASSIGN_CATEG');
868:
869:
870: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1040: IF bil_bi_util_pkg.isleafnode(l_prodcat_id) THEN

1036: end if;
1037: end if;
1038:
1039:
1040: IF bil_bi_util_pkg.isleafnode(l_prodcat_id) THEN
1041: x_custom_sql := 'SELECT * FROM ('|| l_outer_select ||
1042: ' FROM ('||
1043: ' SELECT VIEWBY, VIEWBYID, sortorder,BIL_MEASURE2,
1044: BIL_MEASURE3, BIL_MEASURE5,BIL_MEASURE6,

Line 1127: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

1123: x_custom_attr.Extend();
1124: x_custom_attr(l_bind_ctr) := l_custom_rec;
1125:
1126: ELSE --No valid parameters
1127: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
1128: ,x_sqlstr => x_custom_sql);
1129:
1130: END IF;
1131:

Line 1305: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

1301:
1302:
1303: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
1304: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
1305: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
1306: ,p_region_id => l_region_id
1307: ,x_period_type => l_period_type
1308: ,x_conv_rate_selected => l_conv_rate_selected
1309: ,x_sg_id => l_sg_id

Line 1324: bil_bi_util_pkg.get_latest_snap_date(p_page_parameter_tbl => p_page_parameter_tbl

1320: ,x_record_type_id => l_record_type_id
1321: ,x_viewby => l_viewby );
1322:
1323: /*
1324: bil_bi_util_pkg.get_latest_snap_date(p_page_parameter_tbl => p_page_parameter_tbl
1325: ,p_as_of_date => l_curr_as_of_date
1326: ,p_period_type => NULL
1327: ,x_snapshot_date => l_snap_date);
1328: */

Line 1361: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id

1357: --Not sure what PMV returns for 'All', as of now it returns NULL, so convert it to 'All'.
1358: IF l_prodcat_id IS NULL THEN
1359: l_prodcat_id := 'All';
1360: END IF;
1361: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id
1362: ,x_calendar_id => l_calendar_id
1363: ,x_curr_date => l_bis_sysdate
1364: ,x_fii_struct => l_fii_struct );
1365:

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

1374:
1375:
1376: -- Get the Drill Link to the Opty Line Detail Report
1377:
1378: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,
1379: p_salesgroup_id => l_sg_id,
1380: p_resource_id => l_resource_id );
1381:
1382: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */

Line 1385: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

1381:
1382: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */
1383:
1384:
1385: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
1386: p_period_type => l_page_period_type ,
1387: p_compare_to => l_comp_type,
1388: p_column_type => 'O',
1389: p_curr_suffix => l_currency_suffix

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

1389: p_curr_suffix => l_currency_suffix
1390: );
1391:
1392:
1393: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
1394:
1395:
1396: BIL_BI_UTIL_PKG.GET_PIPE_MV(
1397: p_asof_date => l_curr_as_of_date ,

Line 1396: BIL_BI_UTIL_PKG.GET_PIPE_MV(

1392:
1393: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
1394:
1395:
1396: BIL_BI_UTIL_PKG.GET_PIPE_MV(
1397: p_asof_date => l_curr_as_of_date ,
1398: p_period_type => l_page_period_type ,
1399: p_compare_to => l_comp_type ,
1400: p_prev_date => l_prev_date,

Line 1843: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(

1839: ' ,BIL_URL2 ';
1840:
1841: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP1';
1842:
1843: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(
1844: p_prodcat => l_prodcat_id,
1845: p_viewby => l_viewby,
1846: x_denorm => l_denorm,
1847: x_where_clause => l_product_where_clause);

Line 2407: l_unassigned_value:= bil_bi_util_pkg.GET_UNASSIGNED_PC;

2403: END IF;
2404: END IF;
2405: END IF;
2406:
2407: l_unassigned_value:= bil_bi_util_pkg.GET_UNASSIGNED_PC;
2408:
2409: x_custom_sql :=
2410: ' SELECT * FROM ('||
2411: l_outer_select||' FROM

Line 2690: IF bil_bi_util_pkg.isleafnode(l_prodcat_id) THEN

2686: END IF;
2687:
2688: END IF;
2689: END IF;
2690: IF bil_bi_util_pkg.isleafnode(l_prodcat_id) THEN
2691:
2692: x_custom_sql := ' SELECT * FROM ( '||
2693: l_outer_select||
2694: ' FROM ('||

Line 2788: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

2784: l_bind_ctr:=l_bind_ctr+1;
2785:
2786: END CASE;
2787: ELSE --no valid parameters
2788: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
2789: ,x_sqlstr => x_custom_sql);
2790:
2791: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2792:

Line 2965: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

2961: END IF;
2962:
2963: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2964: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2965: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
2966: ,p_region_id => l_region_id
2967: ,x_period_type => l_period_type
2968: ,x_conv_rate_selected => l_conv_rate_selected
2969: ,x_sg_id => l_sg_id

Line 2984: bil_bi_util_pkg.get_latest_snap_date(p_page_parameter_tbl => p_page_parameter_tbl

2980: ,x_record_type_id => l_record_type_id
2981: ,x_viewby => l_viewby );
2982:
2983: /*
2984: bil_bi_util_pkg.get_latest_snap_date(p_page_parameter_tbl => p_page_parameter_tbl
2985: ,p_as_of_date => l_curr_as_of_date
2986: ,p_period_type => NULL
2987: ,x_snapshot_date => l_snap_date);
2988: */

Line 3016: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id

3012: END IF;
3013:
3014: --Not sure what PMV returns for 'All', as of now it returns NULL, so convert it to 'All'.
3015: l_prodcat_id := 'All';
3016: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id
3017: ,x_calendar_id => l_calendar_id
3018: ,x_curr_date => l_bis_sysdate
3019: ,x_fii_struct => l_fii_struct );
3020:

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

3038: --
3039:
3040: -- Get the Drill Link to the Opty Line Detail Report
3041:
3042: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,
3043: p_salesgroup_id => l_sg_id,
3044: p_resource_id => l_resource_id );
3045:
3046:

Line 3053: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

3049:
3050: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */
3051:
3052:
3053: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
3054: p_period_type => l_page_period_type ,
3055: p_compare_to => l_comp_type,
3056: p_column_type => 'O',
3057: p_curr_suffix => l_currency_suffix

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

3057: p_curr_suffix => l_currency_suffix
3058: );
3059:
3060:
3061: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
3062:
3063: BIL_BI_UTIL_PKG.GET_PIPE_MV(
3064: p_asof_date => l_curr_as_of_date ,
3065: p_period_type => l_page_period_type ,

Line 3063: BIL_BI_UTIL_PKG.GET_PIPE_MV(

3059:
3060:
3061: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
3062:
3063: BIL_BI_UTIL_PKG.GET_PIPE_MV(
3064: p_asof_date => l_curr_as_of_date ,
3065: p_period_type => l_page_period_type ,
3066: p_compare_to => l_comp_type ,
3067: p_prev_date => l_prev_date,

Line 3559: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(

3555:
3556:
3557: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP1';
3558:
3559: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(
3560: p_prodcat => l_prodcat_id,
3561: p_viewby => l_viewby,
3562: x_denorm => l_pipe_denorm,
3563: x_where_clause => l_pipe_product_where_clause);

Line 3860: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

3856: END IF;
3857:
3858:
3859: ELSE --no valid parameters
3860: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
3861: ,x_sqlstr => x_custom_sql);
3862:
3863: IF FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
3864:

Line 3985: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS( p_page_parameter_tbl => p_page_parameter_tbl

3981:
3982: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3983: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3984:
3985: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS( p_page_parameter_tbl => p_page_parameter_tbl
3986: ,p_region_id => l_region_id
3987: ,x_period_type => l_period_type
3988: ,x_conv_rate_selected => l_conv_rate_selected
3989: ,x_sg_id => l_sg_id

Line 4013: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id

4009: l_currency_suffix := '';
4010: END IF;
4011:
4012: IF l_parameter_valid THEN
4013: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id
4014: ,x_calendar_id => l_calendar_id
4015: ,x_curr_date => l_bis_sysdate
4016: ,x_fii_struct => l_fii_struct );
4017: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES( x_debugmode => l_debug_mode );

Line 4017: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES( x_debugmode => l_debug_mode );

4013: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id
4014: ,x_calendar_id => l_calendar_id
4015: ,x_curr_date => l_bis_sysdate
4016: ,x_fii_struct => l_fii_struct );
4017: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES( x_debugmode => l_debug_mode );
4018: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
4019: /*Mappings
4020: *BIL_MEASURE1 => Revenue
4021: *BIL_MEASURE2 => Prior Revenue

Line 4256: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

4252: END IF;
4253:
4254:
4255: ELSE --no valid parameters
4256: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
4257: ,x_sqlstr => x_custom_sql);
4258: END IF;
4259: EXCEPTION
4260: WHEN OTHERS THEN

Line 4415: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl

4411:
4412: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
4413: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
4414:
4415: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl
4416: ,p_region_id => l_region_id
4417: ,x_period_type => l_period_type
4418: ,x_conv_rate_selected => l_conv_rate_selected
4419: ,x_sg_id => l_sg_id

Line 4435: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id

4431: ,x_viewby => l_viewby );
4432:
4433: IF l_parameter_valid THEN
4434:
4435: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS( x_bitand_id => l_bitand_id
4436: ,x_calendar_id => l_calendar_id
4437: ,x_curr_date => l_bis_sysdate
4438: ,x_fii_struct => l_fii_struct );
4439:

Line 4474: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

4470: ELSE
4471: l_group_flag := ' AND sumry.grp_total_flag = 0 ';
4472: END IF;
4473:
4474: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
4475: p_prodcat => l_prodcat_id,
4476: p_viewby => l_viewby,
4477: x_denorm => l_denorm,
4478: x_where_clause => l_product_where_clause

Line 4481: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,

4477: x_denorm => l_denorm,
4478: x_where_clause => l_product_where_clause
4479: );
4480: /*
4481: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,
4482: p_as_of_date => l_curr_as_of_date,
4483: p_period_type =>null,
4484: x_snapshot_date => l_snapshot_date);
4485: */

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

4488:
4489:
4490: -- Get the Drill Link to the Opty Line Detail Report
4491:
4492: l_drill_link := bil_bi_util_pkg.get_drill_links( p_view_by => l_viewby,
4493: p_salesgroup_id => l_sg_id,
4494: p_resource_id => l_resource_id );
4495:
4496:

Line 4502: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

4498:
4499: /* Get the Prefix for the Open amt based upon Period Type and Compare To Params */
4500:
4501:
4502: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
4503: p_period_type => l_page_period_type ,
4504: p_compare_to => l_comp_type,
4505: p_column_type => 'O',
4506: p_curr_suffix => l_currency_suffix

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

4506: p_curr_suffix => l_currency_suffix
4507: );
4508:
4509:
4510: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
4511:
4512: BIL_BI_UTIL_PKG.GET_PIPE_MV(
4513: p_asof_date => l_curr_as_of_date ,
4514: p_period_type => l_page_period_type ,

Line 4512: BIL_BI_UTIL_PKG.GET_PIPE_MV(

4508:
4509:
4510: /* Use the BIL_BI_UTIL_PKG.GET_PIPE_MV proc to get the MV name and snap date for Pipeline/Open Amts. */
4511:
4512: BIL_BI_UTIL_PKG.GET_PIPE_MV(
4513: p_asof_date => l_curr_as_of_date ,
4514: p_period_type => l_page_period_type ,
4515: p_compare_to => l_comp_type ,
4516: p_prev_date => l_prev_date,

Line 5222: l_unassigned_value:= bil_bi_util_pkg.GET_UNASSIGNED_PC;

5218:
5219:
5220: IF l_prodcat_id = 'All' THEN
5221:
5222: l_unassigned_value:= bil_bi_util_pkg.GET_UNASSIGNED_PC;
5223:
5224:
5225: --Open Opportunity by prod cat
5226: l_custom_sql := ' SELECT null VIEWBY'||

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

5424: --PRODCAT NOT ALL
5425: ELSE -- if prod cat is not All
5426:
5427:
5428: l_cat_assign := bil_bi_util_pkg.getLookupMeaning(p_lookuptype => 'BIL_BI_LOOKUPS'
5429: ,p_lookupcode => 'ASSIGN_CATEG');
5430:
5431:
5432: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 5630: IF bil_bi_util_pkg.isleafnode(l_prodcat_id) THEN

5626: end if;
5627: end if;
5628:
5629:
5630: IF bil_bi_util_pkg.isleafnode(l_prodcat_id) THEN
5631:
5632: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
5633:
5634: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT,

Line 5868: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

5864: END IF;
5865:
5866:
5867: ELSE -- params not valid
5868: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
5869: ,x_sqlstr => x_custom_sql);
5870: END IF;
5871:
5872: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 5892: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

5888: MODULE => g_pkg || l_proc || 'proc_error',
5889: MESSAGE => fnd_message.get );
5890: END IF;
5891:
5892: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
5893: ,x_sqlstr => x_custom_sql);
5894: END BIL_BI_OPEN_LDOPBKLOG;
5895:
5896:

Line 6024: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(

6020: END IF;
6021:
6022: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
6023: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
6024: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(
6025: p_page_parameter_tbl => p_page_parameter_tbl
6026: ,p_region_id => l_region_id
6027: ,x_period_type => l_period_type
6028: ,x_conv_rate_selected => l_conv_rate_selected

Line 6077: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS

6073: l_currency_suffix := '';
6074: END IF;
6075:
6076:
6077: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS
6078: (
6079: x_bitand_id => l_bitand_id
6080: ,x_calendar_id => l_calendar_id
6081: ,x_curr_date => l_bis_sysdate

Line 6181: BIL_BI_UTIL_PKG.GET_PRODUCT_WHERE_CLAUSE

6177:
6178: --l_url_str:='pFunctionName=BIL_BI_LDOPCAMP_R&pParamIds=Y&VIEW_BY='||l_viewby||'&VIEW_BY_NAME=VIEW_BY_ID';
6179: */
6180:
6181: BIL_BI_UTIL_PKG.GET_PRODUCT_WHERE_CLAUSE
6182: (
6183: p_viewby => l_viewby,--Timebeing used as there is no case stmt
6184: p_prodcat => l_prodcat_id,
6185: x_denorm => l_denorm,

Line 6682: BIL_BI_UTIL_PKG.get_default_query

6678:
6679:
6680:
6681: ELSE --no valid parameters
6682: BIL_BI_UTIL_PKG.get_default_query
6683: (
6684: p_regionname => l_region_id
6685: ,x_sqlstr => x_custom_sql
6686: );

Line 6711: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

6707: MODULE => g_pkg || l_proc || 'proc_error',
6708: MESSAGE => fnd_message.get );
6709:
6710: END IF;
6711: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
6712: ,x_sqlstr => x_custom_sql);
6713:
6714: RAISE;
6715:

Line 6837: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID

6833: l_err := 'l_currency';
6834: END IF;
6835: ELSIF p_page_parameter_tbl(i).parameter_name = 'ORGANIZATION+JTF_ORG_SALES_GROUP' THEN
6836: l_salesgroup_id := p_page_parameter_tbl(i).parameter_id;
6837: BIL_BI_UTIL_PKG.PARSE_SALES_GROUP_ID
6838: (
6839: p_salesgroup_id =>l_salesgroup_id,
6840: x_resource_id =>l_resource_id
6841: );

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

6936: l_booked_suffix := '1';
6937: END IF;
6938:
6939:
6940: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );
6941:
6942: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
6943: x_calendar_id =>l_calendar_id,
6944: x_curr_date =>l_bis_sysdate,

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

6938:
6939:
6940: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES( x_fstcrdttype => l_fst_crdt_type );
6941:
6942: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
6943: x_calendar_id =>l_calendar_id,
6944: x_curr_date =>l_bis_sysdate,
6945: x_fii_struct =>l_fii_struct);
6946:

Line 6948: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(

6944: x_curr_date =>l_bis_sysdate,
6945: x_fii_struct =>l_fii_struct);
6946:
6947:
6948: l_prev_amt := BIL_BI_UTIL_PKG.GET_PIPE_COL_NAMES(
6949: p_period_type => l_page_period_type ,
6950: p_compare_to => l_comp_type,
6951: p_column_type => 'P',
6952: p_curr_suffix => l_curr_suffix

Line 6955: BIL_BI_UTIL_PKG.GET_PIPE_MV(

6951: p_column_type => 'P',
6952: p_curr_suffix => l_curr_suffix
6953: );
6954:
6955: BIL_BI_UTIL_PKG.GET_PIPE_MV(
6956: p_asof_date => l_asof_date ,
6957: p_period_type => l_page_period_type ,
6958: p_compare_to => l_comp_type ,
6959: p_prev_date => l_prev_date,