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_UTIL

Line 1405: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

1401: IF (l_attr_code(i) IS NULL) THEN
1402: l_attr_code.DELETE(i);
1403: l_attr_value.DELETE(i);
1404: ELSE
1405: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);
1406: END IF;
1407:
1408: ELSIF (l_attr_code(i)='VIEW_BY') THEN
1409:

Line 1430: --l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

1426: END IF;
1427:
1428: --ELSE
1429:
1430: --l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);
1431:
1432: END IF;
1433:
1434: END LOOP;

Line 1589: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

1585: x_msg_data => x_msg_data);
1586:
1587: ELSIF substr(l_attr_code(i),instr(l_attr_code(i),'_HIERARCHY')) = '_HIERARCHY' THEN
1588:
1589: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);
1590: l_dimension := substr(l_attr_code(i),1,instr(l_attr_code(i),'+')-1);
1591: l_element_id := BIS_PMV_UTIL.getHierarchyElementId(l_attr_value(i), l_dimension);
1592:
1593: -- If there is a hierarchy then only store it

Line 1591: l_element_id := BIS_PMV_UTIL.getHierarchyElementId(l_attr_value(i), l_dimension);

1587: ELSIF substr(l_attr_code(i),instr(l_attr_code(i),'_HIERARCHY')) = '_HIERARCHY' THEN
1588:
1589: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);
1590: l_dimension := substr(l_attr_code(i),1,instr(l_attr_code(i),'+')-1);
1591: l_element_id := BIS_PMV_UTIL.getHierarchyElementId(l_attr_value(i), l_dimension);
1592:
1593: -- If there is a hierarchy then only store it
1594: IF (l_element_id > 0) THEN
1595: l_parameter_rec.parameter_name := l_attr_code(i);

Line 1611: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

1607: END IF; --element id
1608:
1609: ELSIF substr(l_attr_code(i),instr(l_attr_code(i),'_FROM')) = '_FROM' then
1610:
1611: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);
1612: l_time_exists := true;
1613:
1614: IF(instr(l_attr_code(i),'_FROM',1,1) > 0 AND instr(l_attr_code(i),'+',1,1) > 0) then
1615: l_time_attr_2 := substr(l_attr_code(i),1,instr(l_attr_code(i),'_FROM')-1);

Line 1624: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

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);
1625:
1626: l_time_exists := true;
1627:
1628: IF(instr(l_attr_code(i),'_TO',1,1) > 0 AND instr(l_attr_code(i),'+',1,1) > 0) THEN

Line 1638: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

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);
1639: l_time_exists := true;
1640: l_time_attr_2 := l_attr_code(i);
1641:
1642: ELSE

Line 1644: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);

1640: l_time_attr_2 := l_attr_code(i);
1641:
1642: ELSE
1643:
1644: l_attr_code(i) := BIS_PMV_UTIL.getDimensionForAttribute(l_attr_code(i), pRegionCode);
1645:
1646: IF (l_attr_code(i) = 'AS_OF_DATE' ) THEN
1647: l_as_of_date := l_attr_value(i);
1648: ELSIF substr(l_attr_code(i),1, instr(l_attr_code(i),'+')-1) = 'TIME_COMPARISON_TYPE' then

Line 2263: l_attribute_code := BIS_PMV_UTIL.getAttributeForDimension(l_delegation_param, pRegionCode);

2259: OPEN getDelegationParam;
2260: FETCH getDelegationParam INTO l_delegation_param;
2261: CLOSE getDelegationParam;
2262: IF (pDelegationParam = l_delegation_param) THEN
2263: l_attribute_code := BIS_PMV_UTIL.getAttributeForDimension(l_delegation_param, pRegionCode);
2264: IF (l_attribute_code <> l_delegation_param) THEN
2265: IF getPrivileges%ISOPEN THEN
2266: CLOSE getPrivileges;
2267: END IF;

Line 2273: l_roleIds_tbl := BIS_PMV_UTIL.getRoleIds(l_privilege);

2269: FETCH getPrivileges INTO l_privilege;
2270: CLOSE getPrivileges;
2271: IF (l_privilege IS NOT NULL AND l_privilege <> '-1' AND length(trim(l_privilege)) > 0) THEN
2272: -- Get Role Id's for Privileges
2273: l_roleIds_tbl := BIS_PMV_UTIL.getRoleIds(l_privilege);
2274: IF (l_roleIds_tbl IS NOT NULL AND l_roleIds_tbl.COUNT > 0) THEN
2275: IF c_level_values_view_name%ISOPEN THEN
2276: CLOSE c_level_values_view_name;
2277: END IF;

Line 2300: BIS_PMV_UTIL.getDelegations(

2296: , x_msg_data => l_msg_data
2297: );
2298: END IF;
2299:
2300: BIS_PMV_UTIL.getDelegations(
2301: pRoleIdsTbl => l_roleIds_tbl
2302: , pParamName => l_delegation_param
2303: , pParameterView => l_view_name
2304: , pAsOfDate => l_AsOfDate

Line 5847: l_attribute2 := BIS_PMV_UTIL.getDimensionForAttribute(rtrim(ltrim(l_attribute_code)),p_user_session_rec.region_code);

5843: end if;
5844: --nbarik - 05/05/03 - Bug Fix 2691199 - Use p_where_clause
5845: --l_attribute_code := substr(l_lov_where, l_index1+1, l_index2-l_index1-1);
5846: l_attribute_code := substr(p_where_clause, l_index1+1, l_index2-l_index1-1);
5847: l_attribute2 := BIS_PMV_UTIL.getDimensionForAttribute(rtrim(ltrim(l_attribute_code)),p_user_session_rec.region_code);
5848: l_parameter_name := nvl(l_attribute2, l_attribute_code);
5849:
5850: if p_parameter_tbl.COUNT > 0 then
5851: for i in p_parameter_tbl.FIRST..p_parameter_tbl.LAST loop

Line 6106: l_PLSQLFunction := BIS_PMV_UTIL.getParameterValue(lFunctionParams, 'pPLSQLFunction');

6102: OPEN getFunctionParams ;
6103: FETCH getFunctionParams INTO lFunctionParams;
6104: CLOSE getFunctionParams ;
6105:
6106: l_PLSQLFunction := BIS_PMV_UTIL.getParameterValue(lFunctionParams, 'pPLSQLFunction');
6107: processDynamicAttributeValue(
6108: pPlSqlFunctionName => l_PLSQLFunction
6109: , xOutPut => l_function_result
6110: );

Line 6111: --l_function_result := BIS_PMV_UTIL.getFunctionResult(l_PLSQLFunction);

6107: processDynamicAttributeValue(
6108: pPlSqlFunctionName => l_PLSQLFunction
6109: , xOutPut => l_function_result
6110: );
6111: --l_function_result := BIS_PMV_UTIL.getFunctionResult(l_PLSQLFunction);
6112: IF l_function_result IS NOT NULL THEN
6113: IF substr(l_function_result, 1, 1) = '&' THEN
6114: lFunctionParams := lFunctionParams || l_function_result;
6115: ELSE

Line 6120: l_pParameters := BIS_PMV_UTIL.getParameterValue(lFunctionParams, 'pParameters');

6116: lFunctionParams := lFunctionParams || '&' || l_function_result;
6117: END IF;
6118: END IF;
6119: -- For report default parameters
6120: l_pParameters := BIS_PMV_UTIL.getParameterValue(lFunctionParams, 'pParameters');
6121: IF (l_pParameters IS NOT NULL) THEN
6122: lFunctionParams := replace (lFunctionParams, '~', '&');
6123: lFunctionParams := replace (lFunctionParams, '@', '=');
6124: lFunctionParams := replace (lFunctionParams, '^', '+');

Line 6127: lsaveById := BIS_PMV_UTIL.getParameterValue (lFunctionParams, 'pParamIds');

6123: lFunctionParams := replace (lFunctionParams, '@', '=');
6124: lFunctionParams := replace (lFunctionParams, '^', '+');
6125: END IF;
6126:
6127: lsaveById := BIS_PMV_UTIL.getParameterValue (lFunctionParams, 'pParamIds');
6128: IF lSaveById IS NULL THEN
6129: lSaveByid := 'N';
6130: END IF;
6131:

Line 6185: l_attribute_code := BIS_PMV_UTIL.getAttributeForDimension(lAttributeCodeTable(i), pParamRegionCode);

6181: , x_msg_data => l_msg_data
6182: );
6183: IF l_valid <> 'Y' THEN
6184: -- Assign the value from form function
6185: l_attribute_code := BIS_PMV_UTIL.getAttributeForDimension(lAttributeCodeTable(i), pParamRegionCode);
6186: l_default_value := BIS_PMV_UTIL.getParameterValue(lFunctionParams, l_attribute_code);
6187: IF l_default_value IS NOT NULL THEN
6188: IF (lSaveById = 'Y') THEN
6189: GET_NONTIME_VALIDATED_ID (p_parameter_name => l_parameter_rec_tbl(i).parameter_name

Line 6186: l_default_value := BIS_PMV_UTIL.getParameterValue(lFunctionParams, l_attribute_code);

6182: );
6183: IF l_valid <> 'Y' THEN
6184: -- Assign the value from form function
6185: l_attribute_code := BIS_PMV_UTIL.getAttributeForDimension(lAttributeCodeTable(i), pParamRegionCode);
6186: l_default_value := BIS_PMV_UTIL.getParameterValue(lFunctionParams, l_attribute_code);
6187: IF l_default_value IS NOT NULL THEN
6188: IF (lSaveById = 'Y') THEN
6189: GET_NONTIME_VALIDATED_ID (p_parameter_name => l_parameter_rec_tbl(i).parameter_name
6190: ,p_parameter_value => l_default_value

Line 6216: x_DrillDefaultParameters := x_DrillDefaultParameters || '&pDrillParamName=' || BIS_PMV_UTIL.encode(lAttributeCodeTable(i)) ||

6212: END IF;
6213: IF (x_DrillDefaultParameters IS NULL) THEN
6214: x_DrillDefaultParameters := 'pDrillParamRegion=' || pParamRegionCode;
6215: END IF;
6216: x_DrillDefaultParameters := x_DrillDefaultParameters || '&pDrillParamName=' || BIS_PMV_UTIL.encode(lAttributeCodeTable(i)) ||
6217: '&pDrillPrevDesc=' || BIS_PMV_UTIL.encode(xSessionDescTable(i)) ||
6218: '&pDrillCurrentDesc=' || BIS_PMV_UTIL.encode(l_default_desc);
6219: xSessionValueTable(i) := l_default_value;
6220: xSessionDescTable(i) := l_default_desc;

Line 6217: '&pDrillPrevDesc=' || BIS_PMV_UTIL.encode(xSessionDescTable(i)) ||

6213: IF (x_DrillDefaultParameters IS NULL) THEN
6214: x_DrillDefaultParameters := 'pDrillParamRegion=' || pParamRegionCode;
6215: END IF;
6216: x_DrillDefaultParameters := x_DrillDefaultParameters || '&pDrillParamName=' || BIS_PMV_UTIL.encode(lAttributeCodeTable(i)) ||
6217: '&pDrillPrevDesc=' || BIS_PMV_UTIL.encode(xSessionDescTable(i)) ||
6218: '&pDrillCurrentDesc=' || BIS_PMV_UTIL.encode(l_default_desc);
6219: xSessionValueTable(i) := l_default_value;
6220: xSessionDescTable(i) := l_default_desc;
6221: END IF;

Line 6218: '&pDrillCurrentDesc=' || BIS_PMV_UTIL.encode(l_default_desc);

6214: x_DrillDefaultParameters := 'pDrillParamRegion=' || pParamRegionCode;
6215: END IF;
6216: x_DrillDefaultParameters := x_DrillDefaultParameters || '&pDrillParamName=' || BIS_PMV_UTIL.encode(lAttributeCodeTable(i)) ||
6217: '&pDrillPrevDesc=' || BIS_PMV_UTIL.encode(xSessionDescTable(i)) ||
6218: '&pDrillCurrentDesc=' || BIS_PMV_UTIL.encode(l_default_desc);
6219: xSessionValueTable(i) := l_default_value;
6220: xSessionDescTable(i) := l_default_desc;
6221: END IF;
6222: -- Assign the first value in the drop down - Not required

Line 6256: xRegionCode := BIS_PMV_UTIL.getReportRegion(xFunctionName);

6252: FETCH getPageToFunctionName INTO xFunctionName;
6253: CLOSE getPageToFunctionName;
6254:
6255: IF (xFunctionName IS NOT NULL) THEN
6256: xRegionCode := BIS_PMV_UTIL.getReportRegion(xFunctionName);
6257: END IF;
6258:
6259: END getPageParamFuncProps;
6260:

Line 6425: BIS_PMV_UTIL.SETUP_BIND_VARIABLES(

6421:
6422: begin
6423:
6424: if (length(p_bind_variables) > 0) then
6425: BIS_PMV_UTIL.SETUP_BIND_VARIABLES(
6426: p_bind_variables => p_bind_variables,
6427: x_bind_var_tbl => l_bind_values);
6428: end if;
6429:

Line 7233: l_RegionCode := BIS_PMV_UTIL.getReportRegion(p_function_name);

7229: l_schedule_id NUMBER;
7230:
7231: BEGIN
7232:
7233: l_RegionCode := BIS_PMV_UTIL.getReportRegion(p_function_name);
7234: l_AsOfDate_Char := to_char(p_asof_date,l_canonical_format);
7235:
7236: BIS_PMV_TIME_LEVELS_PVT.GET_COMPUTED_DATES (
7237: p_region_code => l_RegionCode,