DBA Data[Home] [Help]

APPS.FII_GL_SRC_INV_PKG dependencies on BISVIEWER_PUB

Line 457: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM7='||

453: from fii_fin_item_hierarchies cat
454: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')
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));

Line 465: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_INV_REV_DET_R&FII_DIM2='||pCategory||'&FII_DIM7='||

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='||
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));

Line 497: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||

493: from fii_fin_item_hierarchies cat
494: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')
495: and cat.child_fin_cat_id=pCategory);
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),

Line 505: bisviewer_pub.showreport(pURLString => 'pFunctionName=FII_GL_EXP_CAT3&FII_DIM9='||pLOB||'&VIEW_BY=VIEW_BY&FII_DIM7='||

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='||
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),

Line 532: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||

528: from fii_fin_item_hierarchies cat
529: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')
530: and cat.child_fin_cat_id=pCategory);
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),