208:
209: l_Target_url := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
210: 'OA_HTML/bistared.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
211: ||'&sessionid='||pSessionId
212: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
213: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
214: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
209: l_Target_url := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
210: 'OA_HTML/bistared.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
211: ||'&sessionid='||pSessionId
212: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
213: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
214: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
210: 'OA_HTML/bistared.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
211: ||'&sessionid='||pSessionId
212: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
213: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
214: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
212: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
213: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
214: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
213: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
214: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
214: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
215: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
216: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(l_dimension1_level_short_name)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
217: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(l_dimension2_level_short_name)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
218: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(l_Dimension3_level_short_name)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
219: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(l_Dimension4_level_short_name)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
220: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(l_dimension5_level_short_name)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
228: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(l_dim6_level_value_id)
221: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(l_Dimension6_level_short_name)
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
228: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(l_dim6_level_value_id)
229: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(l_dim7_level_value_id);
222: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(l_dimension7_level_short_name)
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
228: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(l_dim6_level_value_id)
229: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(l_dim7_level_value_id);
230: l_target := l_target_url||'*'||vTarget||'**'||v_range1_low||'***'||v_range1_high;
223: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(l_dim1_level_Value_id)
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
228: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(l_dim6_level_value_id)
229: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(l_dim7_level_value_id);
230: l_target := l_target_url||'*'||vTarget||'**'||v_range1_low||'***'||v_range1_high;
231: return l_target;
224: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(l_dim2_level_Value_id)
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
228: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(l_dim6_level_value_id)
229: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(l_dim7_level_value_id);
230: l_target := l_target_url||'*'||vTarget||'**'||v_range1_low||'***'||v_range1_high;
231: return l_target;
232: --return 'T_' || vTarget || '_' || v_range1_low || '_' || v_range1_high;
225: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(l_dim3_level_Value_id)
226: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(l_dim4_level_value_id)
227: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(l_dim5_level_value_id)
228: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(l_dim6_level_value_id)
229: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(l_dim7_level_value_id);
230: l_target := l_target_url||'*'||vTarget||'**'||v_range1_low||'***'||v_range1_high;
231: return l_target;
232: --return 'T_' || vTarget || '_' || v_range1_low || '_' || v_range1_high;
233: END GET_TARGET;
988: --jprabhud added enhancement#2184054
989: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
990: vReportURL := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
991: 'OA_HTML/bisviewm.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
992: ||'®ionCode='||BIS_PMV_UTIL.encode(p_region_code)||'&functionName='||BIS_PMV_UTIL.encode(p_function_name)
993: ||'&pSessionId='||vSessionId||'&pUserId='||vUserId||'&pResponsibilityId='||vRespId
994: ||'&fileId='||vFileId||'&pFirstTime=0&pMode=SONAR&nlsLangCode='||p_NlsLangCode;
995:
996: vHTMLPieces := utl_http.request_pieces(url => vReportURL,
1653: --jprabhud added enhancement#2184054
1654: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1655: vReportURL := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
1656: 'OA_HTML/bisviewm.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
1657: ||'®ionCode='||BIS_PMV_UTIL.encode(p_region_code)||'&functionName='||BIS_PMV_UTIL.encode(p_function_name)
1658: ||'&pSessionId='||vSessionId||'&pUserId='||vUserId||'&pResponsibilityId='||vRespId
1659: ||'&fileId='||vFileId||'&pFirstTime=0&pMode=SONAR&nlsLangCode='||p_NlsLangCode;
1660:
1661: else
2064:
2065: l_Target_url := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
2066: 'OA_HTML/bistared.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
2067: ||'&sessionid='||pSessionId
2068: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
2069: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
2070: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2065: l_Target_url := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
2066: 'OA_HTML/bistared.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
2067: ||'&sessionid='||pSessionId
2068: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
2069: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
2070: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2066: 'OA_HTML/bistared.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
2067: ||'&sessionid='||pSessionId
2068: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
2069: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
2070: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2068: ||'&RegionCode='||bis_pmv_util.encode(pRegionCode)
2069: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
2070: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2069: ||'&FunctionName='||bis_pmv_util.encode(pFunctionName)
2070: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2070: ||'&SortInfo='||bis_pmv_util.encode('Sortcolumn2Asc')
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2071: ||'&Measure='||pMeasureShortName||'&PlanId='||pPlanId
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2072: ||'&Dim1Level='|| BIS_PMV_UTIL.encode(pDim1Level)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2073: ||'&Dim2Level='|| BIS_PMV_UTIL.encode(pDim2Level)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2074: ||'&Dim3Level='|| BIS_PMV_UTIL.encode(pDim3Level)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2075: ||'&Dim4Level='|| BIS_PMV_UTIL.encode(pDim4Level)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2076: ||'&Dim5Level='|| BIS_PMV_UTIL.encode(pDim5Level)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2084: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(pDim6LevelValue)
2077: ||'&Dim6Level='|| BIS_PMV_UTIL.encode(pDim6Level)
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2084: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(pDim6LevelValue)
2085: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(pDim7LevelValue);
2078: ||'&Dim7Level='|| BIS_PMV_UTIL.encode(pDim7Level)
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2084: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(pDim6LevelValue)
2085: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(pDim7LevelValue);
2086: l_target_url := l_target_url||'*'||lTarget||'**'||l_range1_low||'***'||l_Range1_high;
2079: ||'&Dim1LevelValue='||BIS_PMV_UTIL.encode(pDim1LevelValue)
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2084: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(pDim6LevelValue)
2085: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(pDim7LevelValue);
2086: l_target_url := l_target_url||'*'||lTarget||'**'||l_range1_low||'***'||l_Range1_high;
2087: return l_target_url;
2080: ||'&Dim2LevelValue='||BIS_PMV_UTIL.encode(pDim2LevelValue)
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2084: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(pDim6LevelValue)
2085: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(pDim7LevelValue);
2086: l_target_url := l_target_url||'*'||lTarget||'**'||l_range1_low||'***'||l_Range1_high;
2087: return l_target_url;
2088:
2081: ||'&Dim3LevelValue='||BIS_PMV_UTIL.encode(pDim3LevelValue)
2082: ||'&Dim4LevelValue='||BIS_PMV_UTIL.encode(pDim4LevelValue)
2083: ||'&Dim5LevelValue='||BIS_PMV_UTIL.encode(pDim5LevelValue)
2084: ||'&Dim6LevelValue='||BIS_PMV_UTIL.encode(pDim6LevelValue)
2085: ||'&Dim7LevelValue='||BIS_PMV_UTIL.encode(pDim7LevelValue);
2086: l_target_url := l_target_url||'*'||lTarget||'**'||l_range1_low||'***'||l_Range1_high;
2087: return l_target_url;
2088:
2089: END GET_TARGET_NEW;