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_PARAMETERS_PVT dependencies on BIS_PMV_DRILL_PVT

Line 1471: l_time_from_description varchar2(2000) := BIS_PMV_DRILL_PVT.gvAll;

1467: l_parameter_rec parameter_rec_type;
1468: l_time_parameter_rec time_parameter_rec_type;
1469:
1470: l_time_attr_2 varchar2(2000);
1471: l_time_from_description varchar2(2000) := BIS_PMV_DRILL_PVT.gvAll;
1472: l_time_to_description varchar2(2000) := BIS_PMV_DRILL_PVT.gvAll;
1473: l_time_exists boolean := false;
1474: l_element_id varchar2(1000);
1475:

Line 1472: l_time_to_description varchar2(2000) := BIS_PMV_DRILL_PVT.gvAll;

1468: l_time_parameter_rec time_parameter_rec_type;
1469:
1470: l_time_attr_2 varchar2(2000);
1471: l_time_from_description varchar2(2000) := BIS_PMV_DRILL_PVT.gvAll;
1472: l_time_to_description varchar2(2000) := BIS_PMV_DRILL_PVT.gvAll;
1473: l_time_exists boolean := false;
1474: l_element_id varchar2(1000);
1475:
1476: --Bug Fix 3087383 added variables and get_as_of_date,get_nested_region sqls

Line 1569: l_parameter_rec.parameter_description := nvl(l_attr_value(i), BIS_PMV_DRILL_PVT.gvAll);

1565:
1566: IF (l_attr_code(i) = 'VIEW_BY' ) THEN
1567: --save the parameter
1568: l_parameter_rec.parameter_name := l_attr_code(i);
1569: l_parameter_rec.parameter_description := nvl(l_attr_value(i), BIS_PMV_DRILL_PVT.gvAll);
1570: l_parameter_rec.parameter_value := null;
1571: l_parameter_rec.hierarchy_flag := 'N';
1572: l_parameter_rec.default_flag := 'N';
1573: l_parameter_rec.dimension := substr(l_attr_code(i),1,instr(l_attr_code(i),'+')-1);

Line 1620: l_time_from_description := nvl(l_attr_value(i),BIS_PMV_DRILL_PVT.gvAll);

1616: ELSE
1617: l_time_attr_2 := l_attr_code(i);
1618: END IF;
1619:
1620: l_time_from_description := nvl(l_attr_value(i),BIS_PMV_DRILL_PVT.gvAll);
1621:
1622: ELSIF substr(l_attr_code(i),instr(l_attr_code(i),'_TO')) = '_TO' THEN
1623:
1624: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

Line 1634: l_time_to_description := nvl(l_attr_value(i),BIS_PMV_DRILL_PVT.gvAll);

1630: ELSE
1631: l_time_attr_2 := l_attr_code(i);
1632: END IF;
1633:
1634: l_time_to_description := nvl(l_attr_value(i),BIS_PMV_DRILL_PVT.gvAll);
1635: --Bug Fix 3087383 copy time attr2, time exists as true
1636: ELSIF substr(l_attr_code(i),1, instr(l_attr_code(i),'+')-1) = 'TIME' then
1637:
1638: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

Line 1654: l_parameter_rec.parameter_description := nvl(l_attr_value(i), BIS_PMV_DRILL_PVT.gvAll);

1650: END IF;
1651:
1652: --save the parameter
1653: l_parameter_rec.parameter_name := l_attr_code(i);
1654: l_parameter_rec.parameter_description := nvl(l_attr_value(i), BIS_PMV_DRILL_PVT.gvAll);
1655: l_parameter_rec.parameter_value := null;
1656: l_parameter_rec.hierarchy_flag := 'N';
1657: l_parameter_rec.default_flag := 'N';
1658: l_parameter_rec.dimension := substr(l_attr_code(i),1,instr(l_attr_code(i),'+')-1);

Line 1700: if (l_time_from_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)

1696: l_time_parameter_rec.parameter_name := l_time_attr_2;
1697: l_time_parameter_rec.dimension := substr(l_time_attr_2,1,instr(l_time_attr_2,'+')-1);
1698:
1699: --Bug Fix 3087383 populate time from, to using level id, value if its value is all and nested region is present
1700: if (l_time_from_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)
1701: and l_as_of_date is not null and l_savebyid ) then
1702: l_time_parameter_rec.from_description := l_time_level_id;
1703: elsif (l_time_from_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null) and l_as_of_date is not null) then
1704: l_time_parameter_rec.from_description := l_time_level_value;

Line 1703: elsif (l_time_from_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null) and l_as_of_date is not null) then

1699: --Bug Fix 3087383 populate time from, to using level id, value if its value is all and nested region is present
1700: if (l_time_from_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)
1701: and l_as_of_date is not null and l_savebyid ) then
1702: l_time_parameter_rec.from_description := l_time_level_id;
1703: elsif (l_time_from_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null) and l_as_of_date is not null) then
1704: l_time_parameter_rec.from_description := l_time_level_value;
1705: else
1706: l_time_parameter_rec.from_description := l_time_from_description;
1707: end if;

Line 1709: if (l_time_to_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)

1705: else
1706: l_time_parameter_rec.from_description := l_time_from_description;
1707: end if;
1708:
1709: if (l_time_to_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)
1710: and l_as_of_date is not null and l_savebyid ) then
1711: l_time_parameter_rec.to_description := l_time_level_id;
1712: elsif (l_time_to_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)
1713: and l_as_of_date is not null) then

Line 1712: elsif (l_time_to_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)

1708:
1709: if (l_time_to_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)
1710: and l_as_of_date is not null and l_savebyid ) then
1711: l_time_parameter_rec.to_description := l_time_level_id;
1712: elsif (l_time_to_description = BIS_PMV_DRILL_PVT.gvAll and (pNestedRegionCode is not null)
1713: and l_as_of_date is not null) then
1714: l_time_parameter_rec.to_description := l_time_level_value;
1715: else
1716: l_time_parameter_rec.to_description := l_time_to_description;