167:
168: /*
169: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',
170: icx_sec.getID(icx_sec.PV_SESSION_ID))
171: ||'&P='||icx_call.encrypt2('regionCode='||bis_pmv_util.encode(pRegionCode)
172: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
173: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
174: ||'&requestType='||pRequestType
175: ||'&plugId='||pPlugId
168: /*
169: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',
170: icx_sec.getID(icx_sec.PV_SESSION_ID))
171: ||'&P='||icx_call.encrypt2('regionCode='||bis_pmv_util.encode(pRegionCode)
172: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
173: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
174: ||'&requestType='||pRequestType
175: ||'&plugId='||pPlugId
176: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
169: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',
170: icx_sec.getID(icx_sec.PV_SESSION_ID))
171: ||'&P='||icx_call.encrypt2('regionCode='||bis_pmv_util.encode(pRegionCode)
172: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
173: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
174: ||'&requestType='||pRequestType
175: ||'&plugId='||pPlugId
176: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
177: ||'&graphType='||pGraphType,icx_sec.getID(icx_sec.PV_SESSION_ID));
172: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
173: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
174: ||'&requestType='||pRequestType
175: ||'&plugId='||pPlugId
176: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
177: ||'&graphType='||pGraphType,icx_sec.getID(icx_sec.PV_SESSION_ID));
178: */
179:
180: /*fnd_profile.get(name=>'APPS_SERVLET_AGENT',
182: vScheduleURL := FND_WEB_CONFIG.trail_slash(vScheduleURL)||
183: 'bissched.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
184: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))
185: ||'&responsibilityId='||pResponsibilityId
186: ||'®ionCode='||bis_pmv_util.encode(pRegionCode)
187: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
188: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
189: ||'&requestType='||pRequestType
190: ||'&plugId='||pPlugId
183: 'bissched.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
184: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))
185: ||'&responsibilityId='||pResponsibilityId
186: ||'®ionCode='||bis_pmv_util.encode(pRegionCode)
187: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
188: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
189: ||'&requestType='||pRequestType
190: ||'&plugId='||pPlugId
191: ||'&graphType='||pGraphType;*/
184: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))
185: ||'&responsibilityId='||pResponsibilityId
186: ||'®ionCode='||bis_pmv_util.encode(pRegionCode)
187: ||'&functionName='||bis_pmv_util.encode(pFunctionName)
188: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
189: ||'&requestType='||pRequestType
190: ||'&plugId='||pPlugId
191: ||'&graphType='||pGraphType;*/
192:
194:
195: -- mdamle 11/01/2002 - Added encode
196: vParams := 'regionCode='|| pRegionCode
197: ||'&functionName='||pFunctionName
198: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
199: ||'&requestType='||pRequestType
200: ||'&plugId='||pPlugId
201: ||'&reportTitle='||pReportTitle
202: ||'&graphType='||pGraphType;
1235: from fnd_form_functions
1236: where function_name = 'BIS_SCHEDULE_PAGE';
1237: vParams := 'regionCode='|| pRegionCode
1238: ||'&functionName='||pFunctionName
1239: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
1240: ||'&requestType='||pRequestType
1241: ||'&plugId='||pPlugId
1242: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
1243: ||'&graphType='||pGraphType
1238: ||'&functionName='||pFunctionName
1239: ||'&parmPrint='||bis_pmv_util.encode(pParmPrint)
1240: ||'&requestType='||pRequestType
1241: ||'&plugId='||pPlugId
1242: ||'&reportTitle='||bis_pmv_util.encode(pReportTitle)
1243: ||'&graphType='||pGraphType
1244: ||'&sessionId='||pSessionId
1245: ||'&userId='||pUserId
1246: ||'&respId='||vRespId
1278:
1279: end if;
1280: -- rcmuthuk Bug Fix:2799113. Moved parmPrint param to last.
1281: -- ksadagop Bug Fix:3182441. Encoded header and reportTitle
1282: vParams := 'header='||bis_pmv_util.encode(vReportName)||
1283: '&schedule='||vSchedule||
1284: '®ionCode='||pRegionCode||
1285: '&functionName='||pFunctionName||
1286: '&sessionId='||pSessionId||
1286: '&sessionId='||pSessionId||
1287: '&userId='||pUserId||
1288: '&respId='||vRespId||
1289: '&appId='||vApplicationId||
1290: '&reportTitle='||bis_pmv_util.encode(vReportName)||
1291: '&requestType='||vRequestType||
1292: '&plugId='||pPlugId||
1293: '&nextRun='||vNextRun||
1294: '&lastRun='||vLastRun||
1492: if vPageFunctionId is not null then
1493: /*
1494: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2(''||'*'||pResponsibilityId||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',
1495: pSessionId)
1496: ||'&P='||icx_call.encrypt2('header='||bis_pmv_util.encode(vReportName)||
1497: '&mainMessage=BIS_SCHED_EXPIRED_ERR'||
1498: '&detailMessage=BIS_SCHED_EXPIRED_ERR_DETAIL');
1499:
1500: owa_util.redirect_url(vPageURL);
1654: if vPageFunctionId is not null then
1655: /*
1656: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2(pApplicationId||'*'||pResponsibilityId||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',
1657: pSessionId)
1658: ||'&P='||icx_call.encrypt2('header='||bis_pmv_util.encode(vReportName)||
1659: '&mainMessage=BIS_SUBSCRIBE_CONF'||
1660: '&detailMessage=BIS_SUBSCRIBE_CONF_DETAIL');
1661: owa_util.redirect_url(vPageURL);
1662: */
1861: if vPageFunctionId is not null then
1862: /*
1863: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2('*'||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',
1864: icx_sec.getID(icx_sec.PV_SESSION_ID))
1865: ||'&P='||icx_call.encrypt2('header='||bis_pmv_util.encode(vReportName)||
1866: '&mainMessage=BIS_UNSUBSCRIBE_CONF'||
1867: '&detailMessage=BIS_UNSUBSCRIBE_CONF_DETAIL');
1868:
1869: owa_util.redirect_url(vPageURL);
1934: ,pFunctionName=>pFunctionName
1935: ,pSessionId=>pSessionId
1936: ,pUserId=>pUserId
1937: ,pResponsibilityId=>pResponsibilityId
1938: ,pReportTitle=>bis_pmv_util.encode(pReportTitle)
1939: ,pApplicationId=>pApplicationId
1940: ,pParmPrint => pParmPrint
1941: ,pRequestType => pRequestType
1942: ,pPlugId => pPlugId
2476:
2477: if vPageFunctionId is not null then
2478: /*
2479: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2(''||'*'||pResponsibilityId||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',pSessionId)
2480: ||'&P='||icx_call.encrypt2('header='||bis_pmv_util.encode(pReportName)||
2481: '&mainMessage=BIS_SCHEDULE_ERR'||
2482: '&detailMessage=BIS_SCHEDULE_ERR_DETAIL');
2483:
2484:
2538: exception
2539: when others then null;
2540: end;
2541:
2542: vRegion := BIS_PMV_UTIL.getReportRegion(vFunctionName);
2543: -- mdamle 01/03/2002 - Added plug_id to TL - multiple plugs on a page - will have their respective title link functions
2544: -- mdamle 09/30/2002 - Use the Fwk implementation for the Title link in Web Portlets.
2545: if vType <> 'WEBPORTLET' then
2546: -- P1 Bug 3902169 : Do not pass javascript in the title
2543: -- mdamle 01/03/2002 - Added plug_id to TL - multiple plugs on a page - will have their respective title link functions
2544: -- mdamle 09/30/2002 - Use the Fwk implementation for the Title link in Web Portlets.
2545: if vType <> 'WEBPORTLET' then
2546: -- P1 Bug 3902169 : Do not pass javascript in the title
2547: -- vTitle := ''||p_title||BIS_PMV_UTIL.getAppendTitle(vRegion);
2548: vTitle := p_title||BIS_PMV_UTIL.getAppendTitle(vRegion);
2549:
2550: --Title limit = 100 in icx_portlet_customizations table
2551: vTitle := substr(vTitle, 1, 96);
2544: -- mdamle 09/30/2002 - Use the Fwk implementation for the Title link in Web Portlets.
2545: if vType <> 'WEBPORTLET' then
2546: -- P1 Bug 3902169 : Do not pass javascript in the title
2547: -- vTitle := ''||p_title||BIS_PMV_UTIL.getAppendTitle(vRegion);
2548: vTitle := p_title||BIS_PMV_UTIL.getAppendTitle(vRegion);
2549:
2550: --Title limit = 100 in icx_portlet_customizations table
2551: vTitle := substr(vTitle, 1, 96);
2552: