862:
863: begin
864: l_user_id := pUserId;
865:
866: l_fn_responsibility_id := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));
867: if pApplicationId is null then
868: if cFNDResp%ISOPEN then
869: CLOSE cFNDResp;
870: end if;
944: end;
945: end if;
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)
945: end if;
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
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',
960: val => vScheduleURL);
959: /*fnd_profile.get(name=>'APPS_SERVLET_AGENT',
960: val => vScheduleURL);
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)
980: ||'&reportTitle='||pReportTitle
981: ||'&graphType='||pGraphType;
982:
983: OracleApps.runFunction(c_function_id => l_customize_id
984: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)
985: ,c_parameters => vParams
986: ,p_resp_appl_id => l_application_id
987: ,p_responsibility_id => l_fn_responsibility_id
988: ,p_Security_group_id => icx_sec.g_Security_group_id
984: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)
985: ,c_parameters => vParams
986: ,p_resp_appl_id => l_application_id
987: ,p_responsibility_id => l_fn_responsibility_id
988: ,p_Security_group_id => icx_sec.g_Security_group_id
989: );
990:
991: end scheduleReports;
992: