946:
947: /*
948: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',
949: icx_sec.getID(icx_sec.PV_SESSION_ID))
950: ||'&P='||icx_call.encrypt2('regionCode='||bis_pmv_util.encode(pRegionCode)
951: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
952: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
953: ||'&requestType='||pRequestType
954: ||'&plugId='||pPlugId
947: /*
948: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',
949: icx_sec.getID(icx_sec.PV_SESSION_ID))
950: ||'&P='||icx_call.encrypt2('regionCode='||bis_pmv_util.encode(pRegionCode)
951: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
952: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
953: ||'&requestType='||pRequestType
954: ||'&plugId='||pPlugId
955: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
948: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',
949: icx_sec.getID(icx_sec.PV_SESSION_ID))
950: ||'&P='||icx_call.encrypt2('regionCode='||bis_pmv_util.encode(pRegionCode)
951: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
952: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
953: ||'&requestType='||pRequestType
954: ||'&plugId='||pPlugId
955: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
956: ||'&graphType='||pGraphType,icx_sec.getID(icx_sec.PV_SESSION_ID));
951: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
952: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
953: ||'&requestType='||pRequestType
954: ||'&plugId='||pPlugId
955: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
956: ||'&graphType='||pGraphType,icx_sec.getID(icx_sec.PV_SESSION_ID));
957: */
958:
959: /*fnd_profile.get(name=>'APPS_SERVLET_AGENT',
961: vScheduleURL := FND_WEB_CONFIG.trail_slash(vScheduleURL)||
962: 'bissched.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
963: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))
964: ||'&responsibilityId='||pResponsibilityId
965: ||'®ionCode='||bis_pmv_util.encode(pRegionCode)
966: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
967: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
968: ||'&requestType='||pRequestType
969: ||'&plugId='||pPlugId
962: 'bissched.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
963: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))
964: ||'&responsibilityId='||pResponsibilityId
965: ||'®ionCode='||bis_pmv_util.encode(pRegionCode)
966: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
967: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
968: ||'&requestType='||pRequestType
969: ||'&plugId='||pPlugId
970: ||'&graphType='||pGraphType;*/
963: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))
964: ||'&responsibilityId='||pResponsibilityId
965: ||'®ionCode='||bis_pmv_util.encode(pRegionCode)
966: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
967: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
968: ||'&requestType='||pRequestType
969: ||'&plugId='||pPlugId
970: ||'&graphType='||pGraphType;*/
971:
973:
974: -- mdamle 11/01/2002 - Added encode
975: vParams := 'regionCode='|| pRegionCode
976: ||'&functionName='||pFunctionName
977: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
978: ||'&requestType='||pRequestType
979: ||'&plugId='||pPlugId
980: ||'&reportTitle='||pReportTitle
981: ||'&graphType='||pGraphType;
1231: Dim7LevelValue in varchar2 default null) return varchar2 is
1232: vTargetParm varchar2(2000);
1233:
1234: begin
1235: vTargetParm := Display||'TARGET&Measure='||bis_pmv_util.encode(Measure)
1236: ||'&PlanId='||bis_pmv_util.encode(PlanId)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1232: vTargetParm varchar2(2000);
1233:
1234: begin
1235: vTargetParm := Display||'TARGET&Measure='||bis_pmv_util.encode(Measure)
1236: ||'&PlanId='||bis_pmv_util.encode(PlanId)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1233:
1234: begin
1235: vTargetParm := Display||'TARGET&Measure='||bis_pmv_util.encode(Measure)
1236: ||'&PlanId='||bis_pmv_util.encode(PlanId)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1234: begin
1235: vTargetParm := Display||'TARGET&Measure='||bis_pmv_util.encode(Measure)
1236: ||'&PlanId='||bis_pmv_util.encode(PlanId)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1235: vTargetParm := Display||'TARGET&Measure='||bis_pmv_util.encode(Measure)
1236: ||'&PlanId='||bis_pmv_util.encode(PlanId)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1236: ||'&PlanId='||bis_pmv_util.encode(PlanId)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1237: ||'&Dim1Level='||bis_pmv_util.encode(Dim1Level)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1238: ||'&Dim2Level='||bis_pmv_util.encode(Dim2Level)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1239: ||'&Dim3Level='||bis_pmv_util.encode(Dim3Level)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1240: ||'&Dim4Level='||bis_pmv_util.encode(Dim4Level)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1241: ||'&Dim5Level='||bis_pmv_util.encode(Dim5Level)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1249: ||'&Dim6LevelValue='||bis_pmv_util.encode(Dim6LevelValue)
1242: ||'&Dim6Level='||bis_pmv_util.encode(Dim6Level)
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1249: ||'&Dim6LevelValue='||bis_pmv_util.encode(Dim6LevelValue)
1250: ||'&Dim7LevelValue='||bis_pmv_util.encode(Dim7LevelValue);
1243: ||'&Dim7Level='||bis_pmv_util.encode(Dim7Level)
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1249: ||'&Dim6LevelValue='||bis_pmv_util.encode(Dim6LevelValue)
1250: ||'&Dim7LevelValue='||bis_pmv_util.encode(Dim7LevelValue);
1251: return vTargetParm;
1244: ||'&Dim1LevelValue='||bis_pmv_util.encode(Dim1LevelValue)
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1249: ||'&Dim6LevelValue='||bis_pmv_util.encode(Dim6LevelValue)
1250: ||'&Dim7LevelValue='||bis_pmv_util.encode(Dim7LevelValue);
1251: return vTargetParm;
1252: end getTargetParm;
1245: ||'&Dim2LevelValue='||bis_pmv_util.encode(Dim2LevelValue)
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1249: ||'&Dim6LevelValue='||bis_pmv_util.encode(Dim6LevelValue)
1250: ||'&Dim7LevelValue='||bis_pmv_util.encode(Dim7LevelValue);
1251: return vTargetParm;
1252: end getTargetParm;
1253:
1246: ||'&Dim3LevelValue='||bis_pmv_util.encode(Dim3LevelValue)
1247: ||'&Dim4LevelValue='||bis_pmv_util.encode(Dim4LevelValue)
1248: ||'&Dim5LevelValue='||bis_pmv_util.encode(Dim5LevelValue)
1249: ||'&Dim6LevelValue='||bis_pmv_util.encode(Dim6LevelValue)
1250: ||'&Dim7LevelValue='||bis_pmv_util.encode(Dim7LevelValue);
1251: return vTargetParm;
1252: end getTargetParm;
1253:
1254: procedure getTotalDimValue(pDimSource in varchar2,