APPS.FII_AP_DRILL_ACROSS dependencies on ICX_SEC

Line 36: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

32:
33: pC := pCurrency;
34: bisviewer_pub.showreport(pURLString => 'pFunctionName='||p1||'&pParameterDisplayOnly=Y&ORGANIZATION+FII_OPERATING_UNITS='||pOU||'&SUPPLIER+POA_SUPPLIERS='||pSu||'&CURRENCY+FII_CURRENCIES='||pC||'&FII_REPORT_SOURCE='||p2||'&AS_OF_DATE='||pD||
35: '&pParamIds=Y',
36: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
37: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
38: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
39: /* addding the logic below to implement drill in Electronic Invoice trend report*/
40:

Line 37: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

33: pC := pCurrency;
34: bisviewer_pub.showreport(pURLString => 'pFunctionName='||p1||'&pParameterDisplayOnly=Y&ORGANIZATION+FII_OPERATING_UNITS='||pOU||'&SUPPLIER+POA_SUPPLIERS='||pSu||'&CURRENCY+FII_CURRENCIES='||pC||'&FII_REPORT_SOURCE='||p2||'&AS_OF_DATE='||pD||
35: '&pParamIds=Y',
36: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
37: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
38: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
39: /* addding the logic below to implement drill in Electronic Invoice trend report*/
40:
41:

Line 38: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));

34: bisviewer_pub.showreport(pURLString => 'pFunctionName='||p1||'&pParameterDisplayOnly=Y&ORGANIZATION+FII_OPERATING_UNITS='||pOU||'&SUPPLIER+POA_SUPPLIERS='||pSu||'&CURRENCY+FII_CURRENCIES='||pC||'&FII_REPORT_SOURCE='||p2||'&AS_OF_DATE='||pD||
35: '&pParamIds=Y',
36: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
37: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
38: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
39: /* addding the logic below to implement drill in Electronic Invoice trend report*/
40:
41:
42: ELSIF pSource = 'FII_AP_E_INV_ENT_DTL' THEN

Line 77: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

73:
74:
75: bisviewer_pub.showreport(pURLString => 'pFunctionName='||p1||'&pParameterDisplayOnly=Y&ORGANIZATION+FII_OPERATING_UNITS='||pOU||'&SUPPLIER+POA_SUPPLIERS='||pSu||'&CURRENCY+FII_CURRENCIES='||pC||pP||'&FII_REPORT_SOURCE='||p2||'&AS_OF_DATE='||pD||'
76: &pParamIds=Y',
77: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
78: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
79: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
80:
81: END IF;

Line 78: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

74:
75: bisviewer_pub.showreport(pURLString => 'pFunctionName='||p1||'&pParameterDisplayOnly=Y&ORGANIZATION+FII_OPERATING_UNITS='||pOU||'&SUPPLIER+POA_SUPPLIERS='||pSu||'&CURRENCY+FII_CURRENCIES='||pC||pP||'&FII_REPORT_SOURCE='||p2||'&AS_OF_DATE='||pD||'
76: &pParamIds=Y',
77: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
78: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
79: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
80:
81: END IF;
82:

Line 79: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));

75: bisviewer_pub.showreport(pURLString => 'pFunctionName='||p1||'&pParameterDisplayOnly=Y&ORGANIZATION+FII_OPERATING_UNITS='||pOU||'&SUPPLIER+POA_SUPPLIERS='||pSu||'&CURRENCY+FII_CURRENCIES='||pC||pP||'&FII_REPORT_SOURCE='||p2||'&AS_OF_DATE='||pD||'
76: &pParamIds=Y',
77: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
78: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
79: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
80:
81: END IF;
82:
83: END drill_across;