eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_GL_SRC_INV_PKG dependencies on ICX_SEC

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

455: and cat.child_fin_cat_id=pCategory);
456:
457: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM7='||
458: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',
459: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
460: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
461: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
462:
463: elsif pSource = 'Receivables' then

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

456:
457: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM7='||
458: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',
459: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
460: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
461: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
462:
463: elsif pSource = 'Receivables' then
464:

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

457: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM7='||
458: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',
459: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
460: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
461: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
462:
463: elsif pSource = 'Receivables' then
464:
465: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_INV_REV_DET_R&FII_DIM2='||pCategory||'&FII_DIM7='||

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

463: elsif pSource = 'Receivables' then
464:
465: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_INV_REV_DET_R&FII_DIM2='||pCategory||'&FII_DIM7='||
466: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',
467: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
468: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
469: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
470:
471: elsif (pSource = 'FII_GL_EXP_CAT3' OR pSource = 'FII_GL_REV_CAT3' OR pSource = 'FII_GL_COG_CAT3')then

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

464:
465: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_INV_REV_DET_R&FII_DIM2='||pCategory||'&FII_DIM7='||
466: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',
467: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
468: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
469: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
470:
471: elsif (pSource = 'FII_GL_EXP_CAT3' OR pSource = 'FII_GL_REV_CAT3' OR pSource = 'FII_GL_COG_CAT3')then
472:

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

465: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_INV_REV_DET_R&FII_DIM2='||pCategory||'&FII_DIM7='||
466: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',
467: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
468: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
469: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
470:
471: elsif (pSource = 'FII_GL_EXP_CAT3' OR pSource = 'FII_GL_REV_CAT3' OR pSource = 'FII_GL_COG_CAT3')then
472:
473: SELECT DISTINCT next_level_is_leaf

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

496:
497: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||
498: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||
499: '&pParamIds=Y',
500: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
501: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
502: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
503:
504: else

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

497: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||
498: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||
499: '&pParamIds=Y',
500: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
501: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
502: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
503:
504: else
505: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_EXP_CAT3&FII_DIM9='||pLOB||'&VIEW_BY=VIEW_BY&FII_DIM7='||

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

498: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||
499: '&pParamIds=Y',
500: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
501: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
502: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
503:
504: else
505: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_EXP_CAT3&FII_DIM9='||pLOB||'&VIEW_BY=VIEW_BY&FII_DIM7='||
506: pCategory||'&FII_DIM10='||pCostCenter||'&FII_DIM3='||pMonth||'&FII_DIM8='||pCurrency||'&FII_DIM1='||

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

504: else
505: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_EXP_CAT3&FII_DIM9='||pLOB||'&VIEW_BY=VIEW_BY&FII_DIM7='||
506: pCategory||'&FII_DIM10='||pCostCenter||'&FII_DIM3='||pMonth||'&FII_DIM8='||pCurrency||'&FII_DIM1='||
507: pManager||'&AS_OF_DATE='||pAsOfDateValue||'&pParamIds=Y',
508: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
509: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
510: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
511:
512: end if;

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

505: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_EXP_CAT3&FII_DIM9='||pLOB||'&VIEW_BY=VIEW_BY&FII_DIM7='||
506: pCategory||'&FII_DIM10='||pCostCenter||'&FII_DIM3='||pMonth||'&FII_DIM8='||pCurrency||'&FII_DIM1='||
507: pManager||'&AS_OF_DATE='||pAsOfDateValue||'&pParamIds=Y',
508: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
509: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
510: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
511:
512: end if;
513:

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

506: pCategory||'&FII_DIM10='||pCostCenter||'&FII_DIM3='||pMonth||'&FII_DIM8='||pCurrency||'&FII_DIM1='||
507: pManager||'&AS_OF_DATE='||pAsOfDateValue||'&pParamIds=Y',
508: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
509: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
510: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
511:
512: end if;
513:
514: else

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

531:
532: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||
533: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||
534: '&pParamIds=Y',
535: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
536: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
537: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
538:
539: end if;

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

532: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||
533: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||
534: '&pParamIds=Y',
535: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
536: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
537: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
538:
539: end if;
540:

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

533: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||
534: '&pParamIds=Y',
535: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
536: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
537: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID));
538:
539: end if;
540:
541: END;