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.BIS_PMV_QUERY_PVT dependencies on BIS_PMV_QUERY_PVT

Line 1: package body BIS_PMV_QUERY_PVT AS

1: package body BIS_PMV_QUERY_PVT AS
2: /* $Header: BISVQUEB.pls 120.1 2005/09/09 03:30:09 msaran noship $ */
3: -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
4: -- dbdrv: checkfile(115.112=120.1):~PROD:~PATH:~FILE
5: --

Line 1153: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>l_viewbyat,

1149: l_viewby_select := l_viewby_select || ' (VBT.' || l_viewby_id_name ||') "VIEWBYID", ';
1150: end if;
1151: l_viewbyat := 'Y';
1152: if gvCode is not null and length(gvCode) > 0 then
1153: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>l_viewbyat,
1154: p_attribute_code =>l_viewby_attribute_code,
1155: p_region_code => p_region_code,
1156: p_user_id => p_user_id,
1157: p_customization_code =>gvCode,

Line 1221: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_CALCULATE_SELECT(l_ak_region_item_rec, l_parameter_tbl, l_base_column_tbl,l_aggregation_tbl);

1217:
1218: if (substr(l_ak_region_item_rec.base_column, 1, 1) = ''''
1219: or substr(l_ak_region_item_rec.base_column, 1, 1) = '"') then
1220: --if instrb(l_ak_region_item_rec.base_column, '/') <= 0 then
1221: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_CALCULATE_SELECT(l_ak_region_item_rec, l_parameter_tbl, l_base_column_tbl,l_aggregation_tbl);
1222: --end if;
1223: else
1224: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_NORMAL_SELECT(l_ak_region_item_rec);
1225: end if;

Line 1224: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_NORMAL_SELECT(l_ak_region_item_rec);

1220: --if instrb(l_ak_region_item_rec.base_column, '/') <= 0 then
1221: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_CALCULATE_SELECT(l_ak_region_item_rec, l_parameter_tbl, l_base_column_tbl,l_aggregation_tbl);
1222: --end if;
1223: else
1224: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_NORMAL_SELECT(l_ak_region_item_rec);
1225: end if;
1226: l_viewbyat := 'N';
1227: if gvCode is not null and length(gvCode) > 0 then
1228: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>l_viewbyat,

Line 1228: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>l_viewbyat,

1224: l_column_select := l_column_select || BIS_PMV_QUERY_PVT.GET_NORMAL_SELECT(l_ak_region_item_rec);
1225: end if;
1226: l_viewbyat := 'N';
1227: if gvCode is not null and length(gvCode) > 0 then
1228: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>l_viewbyat,
1229: p_attribute_code =>l_ak_region_item_rec.attribute_code,
1230: p_region_code => p_region_code,
1231: p_user_id => p_user_id,
1232: p_customization_code =>gvCode,

Line 1239: BIS_PMV_QUERY_PVT.GET_TARGET_SELECT

1235: p_second_order_by => l_second_order_by);
1236: end if;
1237:
1238: if l_ak_region_item_rec.attribute_type = 'MEASURE' and p_source not in ('ACTUAL','ACTUAL_FOR_KPI') then
1239: BIS_PMV_QUERY_PVT.GET_TARGET_SELECT
1240: (p_user_session_rec => l_user_session_rec,
1241: p_ak_region_item_rec => l_ak_region_item_rec,
1242: p_parameter_tbl => l_parameter_tbl,
1243: p_report_type => l_report_type,

Line 1294: l_user_groupby := BIS_PMV_QUERY_PVT.GET_USER_STRING(l_ak_region_rec.user_groupby);

1290: end if;
1291:
1292: --get user group by and user order by
1293: if l_ak_region_rec.user_groupby is not null and length(l_ak_region_rec.user_groupby) > 0 then
1294: l_user_groupby := BIS_PMV_QUERY_PVT.GET_USER_STRING(l_ak_region_rec.user_groupby);
1295: end if;
1296:
1297: if l_ak_region_rec.user_orderby is not null and length(l_ak_region_rec.user_orderby) > 0 then
1298: l_user_orderby := BIS_PMV_QUERY_PVT.GET_USER_STRING(l_ak_region_rec.user_orderby);

Line 1298: l_user_orderby := BIS_PMV_QUERY_PVT.GET_USER_STRING(l_ak_region_rec.user_orderby);

1294: l_user_groupby := BIS_PMV_QUERY_PVT.GET_USER_STRING(l_ak_region_rec.user_groupby);
1295: end if;
1296:
1297: if l_ak_region_rec.user_orderby is not null and length(l_ak_region_rec.user_orderby) > 0 then
1298: l_user_orderby := BIS_PMV_QUERY_PVT.GET_USER_STRING(l_ak_region_rec.user_orderby);
1299: end if;
1300:
1301: --construct select string
1302: l_select := l_select || l_viewby_select || l_column_select;

Line 1400: || BIS_PMV_QUERY_PVT.GET_TIME_WHERE

1396: if (l_OLTP_flag)
1397: or nvl(l_time_to_value, 'All') <> 'All'
1398: or nvl(l_time_from_value,'All') <> 'All' then
1399: l_where := l_where
1400: || BIS_PMV_QUERY_PVT.GET_TIME_WHERE
1401: (p_parameter_rec => l_parameter_rec,
1402: p_save_region_item_rec => l_save_region_item_rec,
1403: p_ak_region_rec => l_ak_region_rec,
1404: p_org_dimension_level => l_OLTP_org_level,

Line 1418: || BIS_PMV_QUERY_PVT.GET_NON_TIME_WHERE(l_parameter_rec,l_save_region_item_rec

1414: end if;
1415: end if ; -- if not(l_share_vbt_table)
1416: else
1417: l_where := l_where
1418: || BIS_PMV_QUERY_PVT.GET_NON_TIME_WHERE(l_parameter_rec,l_save_region_item_rec
1419: ,null,x_bind_variables,l_bind_count);
1420: end if;
1421: END IF ; -- not rolling dimension
1422: else

Line 1424: BIS_PMV_QUERY_PVT.GET_NON_DIMENSION_WHERE(l_parameter_rec,l_save_region_item_rec,

1420: end if;
1421: END IF ; -- not rolling dimension
1422: else
1423: l_where := l_where ||
1424: BIS_PMV_QUERY_PVT.GET_NON_DIMENSION_WHERE(l_parameter_rec,l_save_region_item_rec,
1425: x_bind_variables,l_bind_count);
1426: end if;
1427: end if;
1428:

Line 1432: l_where := l_where || BIS_PMV_QUERY_PVT.GET_LOV_WHERE(l_parameter_tbl,

1428:
1429: if l_save_region_item_rec.where_clause is not null and length(l_save_region_item_rec.where_clause) > 0 then
1430: if nvl(l_ak_region_rec.disable_viewby,'N') = 'Y' or
1431: (nvl(l_ak_region_rec.disable_viewby,'N') <> 'Y' and l_viewby_attribute2 = l_parameter_rec.parameter_name) then
1432: l_where := l_where || BIS_PMV_QUERY_PVT.GET_LOV_WHERE(l_parameter_tbl,
1433: l_save_region_item_rec.where_clause,
1434: l_user_session_rec.region_code
1435: );
1436:

Line 1472: l_group_by := BIS_PMV_QUERY_PVT.GET_GROUP_BY

1468: --construct group by string
1469: if (p_source = 'ACTUAL_FOR_KPI') then
1470: l_no_target := true;
1471: end if;
1472: l_group_by := BIS_PMV_QUERY_PVT.GET_GROUP_BY
1473: (p_disable_viewby => nvl(l_ak_region_rec.disable_viewby,'N'),
1474: p_viewby_id_name => l_viewby_id_name,
1475: p_viewby_value_name => l_viewby_value_name,
1476: p_viewby_dimension => l_viewby_dimension,

Line 1493: BIS_PMV_QUERY_PVT.sort(l_def_sort_seq_tbl, l_def_sort_attr_tbl);

1489:
1490: if (l_def_sort_attr_tbl.COUNT > 0) THEN
1491: --Sort the specified order
1492: if (l_def_sort_attr_tbl.COUNT > 1) then
1493: BIS_PMV_QUERY_PVT.sort(l_def_sort_seq_tbl, l_def_sort_attr_tbl);
1494: end if;
1495: for i in l_def_sort_seq_tbl.FIRST..l_def_sort_seq_tbl.LAST loop
1496: l_default_sort_attribute := ' '|| l_default_sort_attribute || l_def_sort_attr_tbl(i)||',';
1497: end loop;

Line 1519: || BIS_PMV_QUERY_PVT.GET_ORDER_BY

1515: l_sel_sort_attribute := p_sort_attribute;
1516: end if;
1517: l_order_by := ' ORDER BY ';
1518: l_order_by := l_order_by
1519: || BIS_PMV_QUERY_PVT.GET_ORDER_BY
1520: (p_disable_viewby => nvl(l_ak_region_rec.disable_viewby,'N'),
1521: p_sort_attribute => l_sel_sort_attribute,
1522: p_sort_direction => p_sort_direction,
1523: p_viewby_dimension => l_viewby_dimension,

Line 1606: || BIS_PMV_QUERY_PVT.APPLY_DATA_FORMAT(p_ak_region_item_rec) || ') "'

1602: return varchar2 is
1603: l_select_string varchar2(2000);
1604: begin
1605: l_select_string := p_ak_region_item_rec.aggregate_function || '('
1606: || BIS_PMV_QUERY_PVT.APPLY_DATA_FORMAT(p_ak_region_item_rec) || ') "'
1607: || p_ak_region_item_rec.attribute_code || '", ';
1608: return l_select_string;
1609: end GET_NORMAL_SELECT;
1610:

Line 1646: l_calculate_select := BIS_PMV_QUERY_PVT.REPLACE_FORMULA(p_ak_region_item_rec,

1642: || ' "'||p_ak_region_item_rec.attribute_code||'", ';
1643: end if;
1644: if substr(p_ak_region_item_rec.base_column, 1, 1) = '"'
1645: and instrb(p_ak_region_item_rec.base_column, '/') <= 0 then
1646: l_calculate_select := BIS_PMV_QUERY_PVT.REPLACE_FORMULA(p_ak_region_item_rec,
1647: p_parameter_tbl,
1648: p_base_column_tbl,
1649: p_aggregation_Tbl)
1650: || ' "'||p_ak_region_item_rec.attribute_code||'", ';

Line 2860: || BIS_PMV_QUERY_PVT.GET_TIME_WHERE(

2856: l_dimension_where varchar2(2000);
2857: begin
2858: if p_parameter_rec.dimension in ('TIME', 'EDW_TIME_M') then
2859: l_dimension_where := l_dimension_where
2860: || BIS_PMV_QUERY_PVT.GET_TIME_WHERE(
2861: p_parameter_rec => p_parameter_rec,
2862: p_save_region_item_rec => p_save_region_item_rec,
2863: p_ak_region_rec => p_ak_region_rec,
2864: p_org_dimension_level => p_org_dimension_level,

Line 2876: BIS_PMV_QUERY_PVT.GET_NON_TIME_WHERE(p_parameter_rec,p_save_region_item_rec,null,

2872: --x_bind_indexes => x_bind_indexes,
2873: x_bind_count => x_bind_count);
2874: else
2875: l_dimension_where := l_dimension_where ||
2876: BIS_PMV_QUERY_PVT.GET_NON_TIME_WHERE(p_parameter_rec,p_save_region_item_rec,null,
2877: x_bind_variables,x_bind_count);
2878: end if;
2879: return l_dimension_where;
2880: end GET_DIMENSION_WHERE;

Line 3006: l_time_where := l_time_where || BIS_PMV_QUERY_PVT.GET_TIME_LABEL_WHERE(p_parameter_rec.parameter_description,

3002: end if;
3003: end if;
3004:
3005: if instrb(p_parameter_rec.parameter_description,'(') > 0 then
3006: l_time_where := l_time_where || BIS_PMV_QUERY_PVT.GET_TIME_LABEL_WHERE(p_parameter_rec.parameter_description,
3007: p_time_value_name,
3008: p_TM_alias,
3009: x_bind_variables,
3010: --x_bind_indexes,

Line 3540: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>'Y',

3536: if gvCode is not null and length(gvCode) > 0 then
3537:
3538: IF l_ak_region_item_rec.attribute2 = p_viewby_attribute2 then
3539: -- for the view by attribute
3540: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>'Y',
3541: p_attribute_code =>l_ak_region_item_rec.attribute_code,
3542: p_region_code => pUserSession.region_code,
3543: p_user_id => pUserSession.user_id,
3544: p_customization_code =>gvCode,

Line 3555: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>'N',

3551: IF (l_ak_region_item_rec.attribute_type = 'MEASURE'
3552: or l_ak_region_item_rec.attribute_type = 'MEASURE_NOTARGET'
3553: OR (l_ak_region_item_rec.attribute_type is null AND l_ak_region_item_rec.node_query_flag = 'N')) THEN
3554:
3555: BIS_PMV_QUERY_PVT.get_customized_order_by(p_viewby =>'N',
3556: p_attribute_code =>l_ak_region_item_rec.attribute_code,
3557: p_region_code => pUserSession.region_code,
3558: p_user_id => pUserSession.user_id,
3559: p_customization_code =>gvCode,

Line 3600: BIS_PMV_QUERY_PVT.sort(l_def_sort_seq_tbl, l_def_sort_attr_tbl);

3596:
3597: IF (l_def_sort_attr_tbl.COUNT > 0) THEN
3598: --Sort the specified order
3599: IF (l_def_sort_attr_tbl.COUNT > 1) THEN
3600: BIS_PMV_QUERY_PVT.sort(l_def_sort_seq_tbl, l_def_sort_attr_tbl);
3601: END IF;
3602: FOR i in l_def_sort_seq_tbl.FIRST..l_def_sort_seq_tbl.LAST LOOP
3603: l_default_sort_attribute := ' '|| l_default_sort_attribute || l_def_sort_attr_tbl(i)||',';
3604: END LOOP;

Line 3625: l_user_order_by := BIS_PMV_QUERY_PVT.GET_USER_STRING(pAKRegionRec.user_orderby);

3621: l_sel_sort_attribute := p_sort_attribute;
3622: END IF;
3623:
3624: IF pAKRegionRec.user_orderby IS NOT NULL THEN
3625: l_user_order_by := BIS_PMV_QUERY_PVT.GET_USER_STRING(pAKRegionRec.user_orderby);
3626: END IF;
3627:
3628: --x_order_by := ' ORDER BY ';
3629: x_order_by := x_order_by

Line 3630: || BIS_PMV_QUERY_PVT.GET_ORDER_BY

3626: END IF;
3627:
3628: --x_order_by := ' ORDER BY ';
3629: x_order_by := x_order_by
3630: || BIS_PMV_QUERY_PVT.GET_ORDER_BY
3631: (p_disable_viewby => nvl(pAKRegionRec.disable_viewby,'N'),
3632: p_sort_attribute => l_sel_sort_attribute,
3633: p_sort_direction => p_sort_direction,
3634: p_viewby_dimension => p_viewby_dimension,

Line 4708: end BIS_PMV_QUERY_PVT;

4704: end loop;
4705: null;
4706: end if;
4707: END;
4708: end BIS_PMV_QUERY_PVT;