DBA Data[Home] [Help]

APPS.BIS_RG_SCHEDULES_PVT dependencies on ICX_SEC

Line 87: l_fn_responsibility_id := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));

83:
84: begin
85: l_user_id := pUserId;
86:
87: l_fn_responsibility_id := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));
88: if pApplicationId is null then
89: if cFNDResp%ISOPEN then
90: CLOSE cFNDResp;
91: end if;

Line 169: vScheduleURL := 'OracleApps.RF?F='||icx_call.encrypt2(l_application_id||'*'||l_fn_responsibility_id||'*'||icx_sec.g_security_group_id||'*'||l_customize_id||'**]',

165: end;
166: end if;
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)

Line 170: icx_sec.getID(icx_sec.PV_SESSION_ID))

166: end if;
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

Line 177: ||'&graphType='||pGraphType,icx_sec.getID(icx_sec.PV_SESSION_ID));

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',
181: val => vScheduleURL);

Line 184: ||'&sessionid='||icx_call.encrypt3(icx_sec.getID(icx_sec.PV_SESSION_ID))

180: /*fnd_profile.get(name=>'APPS_SERVLET_AGENT',
181: val => vScheduleURL);
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)

Line 205: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)

201: ||'&reportTitle='||pReportTitle
202: ||'&graphType='||pGraphType;
203:
204: OracleApps.runFunction(c_function_id => l_customize_id
205: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)
206: ,c_parameters => vParams
207: ,p_resp_appl_id => l_application_id
208: ,p_responsibility_id => l_fn_responsibility_id
209: ,p_Security_group_id => icx_sec.g_Security_group_id

Line 209: ,p_Security_group_id => icx_sec.g_Security_group_id

205: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)
206: ,c_parameters => vParams
207: ,p_resp_appl_id => l_application_id
208: ,p_responsibility_id => l_fn_responsibility_id
209: ,p_Security_group_id => icx_sec.g_Security_group_id
210: );
211:
212: end scheduleReports;
213: --jprabhud 09/24/02 - Enh 2470068 Storing of Graphs to FND_LOBS

Line 1254: xsecurityGroupId := icx_sec.g_security_group_id;

1250: xSessionId := pSessionId;
1251: xRespId := pResponsibilityId;
1252: xApplicationId := pApplicationId;
1253: xParams := vParams;
1254: xsecurityGroupId := icx_sec.g_security_group_id;
1255: xWebHtmlCall := lWebHtmlCall;
1256:
1257: else
1258:

Line 1304: xsecurityGroupId := icx_sec.g_security_group_id;

1300: xSessionId := pSessionId;
1301: xRespId := vRespId;
1302: xApplicationId := vApplicationId;
1303: xParams := vParams;
1304: xsecurityGroupId := icx_sec.g_security_group_id;
1305: xWebHtmlCall := lWebHtmlCall;
1306: end if;
1307: end if;
1308:

Line 1448: if not icx_sec.ValidateSession then

1444: where responsibility_id=pRespId;
1445:
1446: BEGIN
1447:
1448: if not icx_sec.ValidateSession then
1449: return;
1450: end if;
1451:
1452: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));

Line 1452: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));

1448: if not icx_sec.ValidateSession then
1449: return;
1450: end if;
1451:
1452: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));
1453: if pApplicationId is null then
1454: if cFNDResp%ISOPEN then
1455: CLOSE cFNDResp;
1456: end if;

Line 1494: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2(''||'*'||pResponsibilityId||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',

1490: end;
1491:
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');

Line 1512: ,p_Security_group_id => icx_sec.g_security_group_id

1508: ,n_session_id => pSessionId
1509: ,c_parameters => vParams
1510: ,p_resp_appl_id => vApplicationId
1511: ,p_responsibility_id => vRespId
1512: ,p_Security_group_id => icx_sec.g_security_group_id
1513: );
1514:
1515: end if;
1516:

Line 1656: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2(pApplicationId||'*'||pResponsibilityId||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',

1652: end;
1653:
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');

Line 1676: ,p_Security_group_id => icx_sec.g_security_group_id

1672: ,n_session_id => pSessionId
1673: ,c_parameters => vParams
1674: ,p_resp_appl_id => vApplicationId
1675: ,p_responsibility_id => vRespId
1676: ,p_Security_group_id => icx_sec.g_security_group_id
1677: );
1678:
1679: end if;
1680: else

Line 1766: if not icx_sec.ValidateSession then

1762: where responsibility_id=pRespId;
1763:
1764: BEGIN
1765:
1766: if not icx_sec.ValidateSession then
1767: return;
1768: end if;
1769:
1770: vRespId := icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID);

Line 1770: vRespId := icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID);

1766: if not icx_sec.ValidateSession then
1767: return;
1768: end if;
1769:
1770: vRespId := icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID);
1771: if cFNDResp%ISOPEN then
1772: CLOSE cFNDResp;
1773: end if;
1774: OPEN cFNDResp(vRespId);

Line 1778: vUserId := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

1774: OPEN cFNDResp(vRespId);
1775: FETCH cFNDResp INTO vApplicationId;
1776: CLOSE cFNDResp;
1777:
1778: vUserId := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
1779:
1780: begin
1781: select user_name
1782: into vUserName

Line 1863: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2('*'||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',

1859: end;
1860:
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');

Line 1864: icx_sec.getID(icx_sec.PV_SESSION_ID))

1860:
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:

Line 1877: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)

1873: '&mainMessage=BIS_UNSUBSCRIBE_CONF'||
1874: '&detailMessage=BIS_UNSUBSCRIBE_CONF_DETAIL';
1875:
1876: OracleApps.runFunction(c_function_id => vPageFunctionId
1877: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)
1878: ,c_parameters => vParams
1879: ,p_resp_appl_id => vApplicationId
1880: ,p_responsibility_id => vRespId
1881: ,p_Security_group_id => icx_sec.g_security_group_id

Line 1881: ,p_Security_group_id => icx_sec.g_security_group_id

1877: ,n_session_id => icx_sec.getID(icx_sec.PV_SESSION_ID)
1878: ,c_parameters => vParams
1879: ,p_resp_appl_id => vApplicationId
1880: ,p_responsibility_id => vRespId
1881: ,p_Security_group_id => icx_sec.g_security_group_id
1882: );
1883:
1884: end if;
1885:

Line 2461: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));

2457: where responsibility_id=pRespId;
2458:
2459: begin
2460:
2461: vRespId := nvl(pResponsibilityId, icx_sec.getid(ICX_SEC.PV_RESPONSIBILITY_ID));
2462: if cFNDResp%ISOPEN then
2463: CLOSE cFNDResp;
2464: end if;
2465: OPEN cFNDResp(vRespId);

Line 2479: vPageURL := 'OracleApps.RF?F='||icx_call.encrypt2(''||'*'||pResponsibilityId||'*'||icx_sec.g_security_group_id||'*'||vPageFunctionId||'**]',pSessionId)

2475: end;
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:

Line 2499: ,p_Security_group_id => icx_sec.g_security_group_id

2495: ,n_session_id => pSessionId
2496: ,c_parameters => vParams
2497: ,p_resp_appl_id => vApplicationId
2498: ,p_responsibility_id => vRespId
2499: ,p_Security_group_id => icx_sec.g_security_group_id
2500: );
2501:
2502: end if;
2503: