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

Line 105: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl,

101:
102: END IF;
103:
104:
105: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl => p_page_parameter_tbl,
106: p_region_id => l_region_id,
107: x_period_type => l_period_type,
108: x_conv_rate_selected => l_conv_rate_selected,
109: x_sg_id => l_sg_id,

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

122:
123: IF l_parameter_valid THEN
124:
125: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
126: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES(x_FstCrdtType => l_fst_crdt_type);
127: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl => p_page_parameter_tbl,
128: p_page_period_type => l_page_period_type,
129: p_comp_type => l_comp_type,
130: p_curr_as_of_date => l_curr_as_of_date,

Line 127: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl => p_page_parameter_tbl,

123: IF l_parameter_valid THEN
124:
125: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
126: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES(x_FstCrdtType => l_fst_crdt_type);
127: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl => p_page_parameter_tbl,
128: p_page_period_type => l_page_period_type,
129: p_comp_type => l_comp_type,
130: p_curr_as_of_date => l_curr_as_of_date,
131: x_table_name => l_table_name,

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

134: x_prev_start_date => l_prev_start_date,
135: x_curr_eff_end_date => l_curr_eff_end_date,
136: x_prev_eff_end_date => l_prev_eff_end_date);
137:
138: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id,
139: x_calendar_id => l_calendar_id,
140: x_curr_date => l_bis_sysdate,
141: x_fii_struct => l_fii_struct);
142:

Line 155: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

151: IF l_prodcat_id IS NULL THEN
152: l_prodcat_id := 'All';
153: END IF;
154: /* Added following code for PC rollup when PC <> All */
155: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
156: p_viewby => l_viewby,
157: p_prodcat => l_prodcat_id,
158: x_denorm => l_denorm,
159: x_where_clause => l_product_where_clause);

Line 855: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

851:
852: END IF;
853:
854: ELSE --p_valid_param false
855: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
856: ,x_sqlstr => l_default_query);
857: l_custom_sql := l_default_query;
858: END IF;
859:

Line 1178: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,

1174:
1175: END IF;
1176:
1177:
1178: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
1179: p_region_id =>l_region_id,
1180: x_period_type =>l_period_type,
1181: x_conv_rate_selected =>l_conv_rate_selected,
1182: x_sg_id =>l_sg_id,

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

1195:
1196:
1197: IF l_parameter_valid THEN
1198:
1199: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES(x_FstCrdtType => l_fst_crdt_type);
1200:
1201: /* bil_bi_util_pkg.get_Latest_Snap_Date(p_page_parameter_tbl => p_page_parameter_tbl
1202: ,p_as_of_date => l_curr_as_of_date
1203: ,p_period_type => NULL

Line 1201: /* bil_bi_util_pkg.get_Latest_Snap_Date(p_page_parameter_tbl => p_page_parameter_tbl

1197: IF l_parameter_valid THEN
1198:
1199: BIL_BI_UTIL_PKG.GET_FORECAST_PROFILES(x_FstCrdtType => l_fst_crdt_type);
1200:
1201: /* bil_bi_util_pkg.get_Latest_Snap_Date(p_page_parameter_tbl => p_page_parameter_tbl
1202: ,p_as_of_date => l_curr_as_of_date
1203: ,p_period_type => NULL
1204: ,x_snapshot_date => l_snap_date);
1205: */

Line 1207: BIL_BI_UTIL_PKG.GET_PIPE_TREND_SOURCE(p_as_of_date => l_curr_as_of_date

1203: ,p_period_type => NULL
1204: ,x_snapshot_date => l_snap_date);
1205: */
1206:
1207: BIL_BI_UTIL_PKG.GET_PIPE_TREND_SOURCE(p_as_of_date => l_curr_as_of_date
1208: ,p_prev_date => l_prev_date
1209: ,p_trend_type => 'E'
1210: ,p_period_type => l_page_period_type
1211: ,p_page_parameter_tbl => p_page_parameter_tbl

Line 1219: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl => p_page_parameter_tbl,

1215:
1216: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
1217: l_prodcat := REPLACE(l_prodcat,'''','');
1218:
1219: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl => p_page_parameter_tbl,
1220: p_page_period_type => l_page_period_type,
1221: p_comp_type => l_comp_type,
1222: p_curr_as_of_date => l_curr_as_of_date,
1223: x_table_name => l_table_name,

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

1226: x_prev_start_date => l_prev_start_date,
1227: x_curr_eff_end_date => l_curr_eff_end_date,
1228: x_prev_eff_end_date => l_prev_eff_end_date);
1229:
1230: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id,
1231: x_calendar_id => l_calendar_id,
1232: x_curr_date => l_bis_sysdate,
1233: x_fii_struct => l_fii_struct);
1234:

Line 1235: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(p_prodcat => l_viewby

1231: x_calendar_id => l_calendar_id,
1232: x_curr_date => l_bis_sysdate,
1233: x_fii_struct => l_fii_struct);
1234:
1235: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(p_prodcat => l_viewby
1236: ,p_viewby => l_prodcat
1237: ,x_denorm => l_denorm
1238: ,x_where_clause => l_prod_where_clause_pipe);
1239:

Line 1351: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);

1347: l_pipe_col := ' sumry.pipeline_amt_year'||l_currency_suffix||' ';
1348: END IF;
1349: */
1350:
1351: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);
1352:
1353: l_sql_stmnt1 := l_sql_stmnt1 ||' UNION ALL '||
1354: 'SELECT ftime.'|| l_column_name ||' timeId '||
1355: ',0 fstAmt '||

Line 1424: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);

1420:
1421: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP1';
1422: execute immediate 'TRUNCATE TABLE '||g_sch_name||'.'||'BIL_BI_RPT_TMP2';
1423:
1424: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);
1425:
1426: l_sql_stmnt1 :='SELECT /*+ ORDERED INDEX (ftime, '||l_page_period_type||'_N1) USE_NL (ftime ftrs sumry) */ ftime.sequence timeSequence '||
1427: ',SUM(DECODE(sumry.salesrep_id,NULL,sumry.forecast_amt_sub'||l_currency_suffix||',sumry.forecast_amt'||l_currency_suffix||')) forecast_amt '||
1428: ',0 pipe_amt '||

Line 1795: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);

1791: ELSE
1792: l_pipe_col := ' sumry.pipeline_amt_quarter'||l_currency_suffix||' ';
1793: END IF;
1794: */
1795: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);
1796:
1797:
1798: l_sql_stmnt1 := 'SELECT /*+ ORDERED INDEX (ftime, '||l_page_period_type||'_N1) USE_NL (ftime ftrs sumry) */ ftime.sequence time_sequence '||
1799: ',(CASE WHEN ftrs.report_date = :l_curr_as_of_date AND ftime.end_date > :l_curr_start_date '||

Line 1892: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

1888:
1889: END IF;
1890:
1891: ELSE --p_valid_param false
1892: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
1893: ,x_sqlstr => l_default_query);
1894: l_custom_sql := l_default_query;
1895: END IF;
1896:

Line 2205: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,

2201:
2202: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2203: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2204:
2205: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
2206: p_region_id =>l_region_id,
2207: x_period_type =>l_period_type,
2208: x_conv_rate_selected =>l_conv_rate_selected,
2209: x_sg_id =>l_sg_id,

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

2236: IF l_parameter_valid THEN
2237:
2238: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
2239:
2240: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id => l_bitand_id,
2241: x_calendar_id => l_calendar_id,
2242: x_curr_date => l_bis_sysdate,
2243: x_fii_struct => l_fii_struct);
2244:

Line 2245: bil_bi_util_pkg.get_forecast_profiles(x_FstCrdtType => l_fst_crdt_type);

2241: x_calendar_id => l_calendar_id,
2242: x_curr_date => l_bis_sysdate,
2243: x_fii_struct => l_fii_struct);
2244:
2245: bil_bi_util_pkg.get_forecast_profiles(x_FstCrdtType => l_fst_crdt_type);
2246:
2247: IF l_conv_rate_selected = 0 THEN /*this part moved for BUG 4000977*/
2248: l_currency_suffix := '_s';
2249: ELSE

Line 2271: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);

2267: l_show_period := ' FII_TIME_DAY ';
2268: -- l_pipe_col := ' sumry.pipeline_amt_week'||l_currency_suffix;
2269: END IF;
2270:
2271: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);
2272:
2273:
2274: /* BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl,
2275: p_as_of_date => l_curr_as_of_date,

Line 2274: /* BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl,

2270:
2271: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);
2272:
2273:
2274: /* BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl => p_page_parameter_tbl,
2275: p_as_of_date => l_curr_as_of_date,
2276: p_period_type => l_page_period_type,
2277: x_snapshot_date => l_snapshot_date);
2278: */

Line 2281: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(

2277: x_snapshot_date => l_snapshot_date);
2278: */
2279:
2280:
2281: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause(
2282: p_prodcat => l_prodcat,
2283: p_viewby => l_viewby,
2284: x_denorm => l_denorm,
2285: x_where_clause => l_pc_norollup_where);

Line 2366: BIL_BI_UTIL_PKG.GET_PIPE_TREND_SOURCE(p_as_of_date => l_curr_as_of_date

2362: * BIL_MEASURE3 - Won
2363: */
2364:
2365:
2366: BIL_BI_UTIL_PKG.GET_PIPE_TREND_SOURCE(p_as_of_date => l_curr_as_of_date
2367: ,p_prev_date => NULL
2368: ,p_trend_type => 'P'
2369: ,p_period_type => l_page_period_type
2370: ,p_page_parameter_tbl => p_page_parameter_tbl

Line 2549: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

2545: l_custom_sql := l_custom_sql ||') opty, BIL_BI_RPT_TMP1 temp where opty.viewby(+) = temp.date2
2546: GROUP BY temp.date2,opty.viewby_date,opty.viewby order by temp.date2';
2547:
2548: ELSE
2549: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
2550: ,x_sqlstr => l_default_query);
2551: l_custom_sql := l_default_query;
2552: END IF;
2553:

Line 2821: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);

2817: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
2818: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
2819:
2820:
2821: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
2822:
2823: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
2824: p_region_id =>l_region_id,
2825: x_period_type =>l_period_type,

Line 2823: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,

2819:
2820:
2821: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
2822:
2823: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
2824: p_region_id =>l_region_id,
2825: x_period_type =>l_period_type,
2826: x_conv_rate_selected =>l_conv_rate_selected,
2827: x_sg_id =>l_sg_id,

Line 2844: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl =>p_page_parameter_tbl,

2840:
2841:
2842: IF (l_parameter_valid) THEN
2843:
2844: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl =>p_page_parameter_tbl,
2845: p_page_period_type =>l_page_period_type,
2846: p_comp_type =>l_comp_type,
2847: p_curr_as_of_date =>l_curr_as_of_date,
2848: x_table_name =>l_table_name,

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

2855:
2856: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
2857:
2858:
2859: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
2860: x_calendar_id =>l_calendar_id,
2861: x_curr_date =>l_bis_sysdate,
2862: x_fii_struct =>l_fii_struct);
2863:

Line 2875: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(

2871: IF l_productcat_id IS NULL THEN
2872: l_productcat_id := 'All';
2873: END IF;
2874:
2875: BIL_BI_UTIL_PKG.GET_PC_NOROLLUP_WHERE_CLAUSE(
2876: p_viewby => l_viewby,
2877: p_prodcat => l_productcat_id,
2878: x_denorm => l_denorm,
2879: x_where_clause => l_product_where_clause

Line 2882: /* BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,

2878: x_denorm => l_denorm,
2879: x_where_clause => l_product_where_clause
2880: );
2881:
2882: /* BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,
2883: p_as_of_date => l_curr_as_of_date,
2884: p_period_type =>null,
2885: x_snapshot_date => l_snapshot_date);
2886: */

Line 2889: BIL_BI_UTIL_PKG.GET_PIPE_TREND_SOURCE(p_as_of_date => l_curr_as_of_date

2885: x_snapshot_date => l_snapshot_date);
2886: */
2887:
2888:
2889: BIL_BI_UTIL_PKG.GET_PIPE_TREND_SOURCE(p_as_of_date => l_curr_as_of_date
2890: ,p_prev_date => NULL
2891: ,p_trend_type => 'E'
2892: ,p_period_type => l_page_period_type
2893: ,p_page_parameter_tbl => p_page_parameter_tbl

Line 2913: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);

2909: l_pipe_col := 'pipeline_amt_week'||l_currency_suffix;
2910: END CASE;
2911: */
2912:
2913: l_pipe_col := bil_bi_util_pkg.get_pipe_col_names(l_page_period_type, NULL, 'P', l_currency_suffix);
2914:
2915: IF(l_productcat_id = 'All') THEN
2916: -- l_sumry := 'bil_bi_pipe_g_mv';
2917: l_group_flag := ' AND sumry.grp_total_flag = 1 ';

Line 3023: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

3019: ' ORDER BY end_date ';
3020:
3021: ELSE
3022:
3023: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
3024: ,x_sqlstr => l_default_query);
3025:
3026: l_custom_sql := l_default_query;
3027:

Line 3358: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,

3354:
3355: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3356: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3357:
3358: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
3359: p_region_id =>l_region_id,
3360: x_period_type =>l_period_type,
3361: x_conv_rate_selected =>l_conv_rate_selected,
3362: x_sg_id =>l_sg_id,

Line 3378: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl =>p_page_parameter_tbl,

3374: x_viewby =>l_viewby);
3375:
3376: IF (l_parameter_valid) THEN
3377:
3378: BIL_BI_UTIL_PKG.get_trend_params(p_page_parameter_tbl =>p_page_parameter_tbl,
3379: p_page_period_type =>l_page_period_type,
3380: p_comp_type =>l_comp_type,
3381: p_curr_as_of_date =>l_curr_as_of_date,
3382: x_table_name =>l_table_name,

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

3388:
3389:
3390: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
3391:
3392: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
3393: x_calendar_id =>l_calendar_id,
3394: x_curr_date =>l_bis_sysdate,
3395: x_fii_struct =>l_fii_struct);
3396:

Line 3409: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause( p_prodcat => l_productcat_id,

3405: IF l_productcat_id IS NULL THEN
3406: l_productcat_id := 'All';
3407: END IF;
3408:
3409: BIL_BI_UTIL_PKG.get_PC_NoRollup_Where_Clause( p_prodcat => l_productcat_id,
3410: p_viewby => l_viewby,
3411: x_denorm => l_denorm,
3412: x_where_clause => l_product_where_clause
3413: );

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

3413: );
3414: /* LATEST SNAPSHOT IMPLEMENTATION */
3415:
3416:
3417: BIL_BI_UTIL_PKG.GET_LATEST_SNAP_DATE(p_page_parameter_tbl =>p_page_parameter_tbl,
3418: p_as_of_date => l_curr_as_of_date,
3419: p_period_type =>null,
3420: x_snapshot_date => l_snapshot_date);
3421:

Line 3609: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

3605: ORDER BY ftime.end_date';
3606:
3607:
3608: ELSE
3609: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
3610: ,x_sqlstr => l_default_query);
3611:
3612: l_custom_sql := l_default_query;
3613:

Line 3898: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);

3894: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
3895: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
3896:
3897:
3898: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
3899:
3900: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
3901: p_region_id =>l_region_id,
3902: x_period_type =>l_period_type,

Line 3900: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,

3896:
3897:
3898: BIL_BI_UTIL_PKG.GET_OTHER_PROFILES(x_DebugMode => l_DebugMode);
3899:
3900: BIL_BI_UTIL_PKG.GET_PAGE_PARAMS(p_page_parameter_tbl =>p_page_parameter_tbl,
3901: p_region_id =>l_region_id,
3902: x_period_type =>l_period_type,
3903: x_conv_rate_selected =>l_conv_rate_selected,
3904: x_sg_id =>l_sg_id,

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

3919: l_prodcat := REPLACE(l_prodcat,'''','');
3920:
3921: IF (l_parameter_valid = TRUE) THEN
3922: l_sg_id_num := TO_NUMBER(REPLACE(l_sg_id, ''''));
3923: BIL_BI_UTIL_PKG.GET_GLOBAL_CONTS(x_bitand_id =>l_bitand_id,
3924: x_calendar_id =>l_calendar_id,
3925: x_curr_date =>l_bis_sysdate,
3926: x_fii_struct =>l_fii_struct);
3927:

Line 3928: bil_bi_util_pkg.get_forecast_profiles(x_FstCrdtType => l_fst_crdt_type);

3924: x_calendar_id =>l_calendar_id,
3925: x_curr_date =>l_bis_sysdate,
3926: x_fii_struct =>l_fii_struct);
3927:
3928: bil_bi_util_pkg.get_forecast_profiles(x_FstCrdtType => l_fst_crdt_type);
3929:
3930: if l_page_period_type = 'FII_TIME_ENT_YEAR' THEN
3931: l_viewby:='TIME+FII_TIME_ENT_PERIOD';
3932: l_show_period := 'FII_TIME_ENT_PERIOD ';

Line 4252: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id

4248: ORDER BY opty.viewby';
4249:
4250:
4251: ELSE
4252: BIL_BI_UTIL_PKG.get_default_query(p_regionname => l_region_id
4253: ,x_sqlstr => l_default_query);
4254: l_custom_sql := l_default_query;
4255: END IF;
4256: