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.PJI_PMV_ENGINE dependencies on BIS_PMV_PARAMETERS_PUB

Line 5282: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

5278: PJI_UTILS.RESET_SSWA_SESSION_CACHE;
5279: Write2FWKLog('Entering Generate_SQL...','Generate_SQL');
5280: END IF;
5281:
5282: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
5283:
5284: IF p_PA_DEBUG_MODE = 'Y' THEN
5285: Write2FWKLog('Before Calling Init...','Generate_SQL');
5286: END IF;

Line 5313: l_PMV_Rec.attribute_name:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

5309: Write2FWKLog('After calling Construct_SELECT_Clause.','Generate_SQL');
5310: END IF;
5311:
5312: IF l_View_BY IS NOT NULL THEN
5313: l_PMV_Rec.attribute_name:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
5314: l_PMV_Rec.attribute_value:=l_View_BY;
5315: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
5316:
5317: l_PMV_Output.EXTEND();

Line 5315: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

5311:
5312: IF l_View_BY IS NOT NULL THEN
5313: l_PMV_Rec.attribute_name:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
5314: l_PMV_Rec.attribute_value:=l_View_BY;
5315: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
5316:
5317: l_PMV_Output.EXTEND();
5318: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5319:

Line 5441: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

5437:
5438: IF l_Exists_Flag = 'N' THEN
5439: l_PMV_Rec.attribute_name:=':'||l_Substitute_Var;
5440: l_PMV_Rec.attribute_value:=l_Report_Parameters;
5441: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5442:
5443: IF l_Substitute_Var = 'PJI_AS_OF_DATE' THEN
5444: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
5445: ELSE

Line 5444: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

5440: l_PMV_Rec.attribute_value:=l_Report_Parameters;
5441: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5442:
5443: IF l_Substitute_Var = 'PJI_AS_OF_DATE' THEN
5444: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
5445: ELSE
5446: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5447: END IF;
5448:

Line 5446: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

5442:
5443: IF l_Substitute_Var = 'PJI_AS_OF_DATE' THEN
5444: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
5445: ELSE
5446: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5447: END IF;
5448:
5449: l_PMV_Output.EXTEND();
5450: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;

Line 5468: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

5464: Write2FWKLog('No View BY is specified. Hence substituting the view by with a dummy value.','Generate_SQL');
5465: END IF;
5466: l_PMV_Rec.attribute_name:=':PJI_VIEW_BY';
5467: l_PMV_Rec.attribute_value:='XX';
5468: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5469: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5470: l_PMV_Output.EXTEND();
5471: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5472: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;

Line 5469: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

5465: END IF;
5466: l_PMV_Rec.attribute_name:=':PJI_VIEW_BY';
5467: l_PMV_Rec.attribute_value:='XX';
5468: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5469: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5470: l_PMV_Output.EXTEND();
5471: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5472: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;
5473: l_PLSQL_Driver_Params:=REPLACE(l_PLSQL_Driver_Params,'<>',':PJI_VIEW_BY');

Line 5484: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

5480: Write2FWKLog('Defaulting the period type to view by time dimension.','Generate_SQL');
5481: END IF;
5482: l_PMV_Rec.attribute_name:=':PJI_PERIOD_TYPE';
5483: l_PMV_Rec.attribute_value:=SUBSTR(l_View_By,INSTR(l_View_By,'+')+1);
5484: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5485: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5486: l_PMV_Output.EXTEND();
5487: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5488: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;

Line 5485: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

5481: END IF;
5482: l_PMV_Rec.attribute_name:=':PJI_PERIOD_TYPE';
5483: l_PMV_Rec.attribute_value:=SUBSTR(l_View_By,INSTR(l_View_By,'+')+1);
5484: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5485: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5486: l_PMV_Output.EXTEND();
5487: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5488: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;
5489: l_PLSQL_Driver_Params:=REPLACE(l_PLSQL_Driver_Params,'<>',':PJI_PERIOD_TYPE');

Line 5577: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

5573: PJI_UTILS.RESET_SSWA_SESSION_CACHE;
5574: Write2FWKLog('Entering Generate_SQL...','Generate_SQL');
5575: END IF;
5576:
5577: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
5578:
5579: FOR i IN p_page_parameter_tbl.first..p_page_parameter_tbl.last LOOP
5580: IF p_page_parameter_tbl(i).parameter_name = 'VIEW_BY' THEN
5581: IF p_PA_DEBUG_MODE = 'Y' THEN

Line 5601: l_PMV_Rec.attribute_name:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

5597: Write2FWKLog('After calling Construct_SELECT_Clause.','Generate_SQL');
5598: END IF;
5599:
5600: IF l_View_BY IS NOT NULL THEN
5601: l_PMV_Rec.attribute_name:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
5602: l_PMV_Rec.attribute_value:=l_View_BY;
5603: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
5604:
5605: l_PMV_Output.EXTEND();

Line 5603: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;

5599:
5600: IF l_View_BY IS NOT NULL THEN
5601: l_PMV_Rec.attribute_name:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
5602: l_PMV_Rec.attribute_value:=l_View_BY;
5603: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
5604:
5605: l_PMV_Output.EXTEND();
5606: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5607:

Line 5736: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

5732:
5733: IF l_Exists_Flag = 'N' THEN
5734: l_PMV_Rec.attribute_name:=':'||l_Substitute_Var;
5735: l_PMV_Rec.attribute_value:=l_Report_Parameters;
5736: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5737:
5738: IF l_Substitute_Var = 'PJI_AS_OF_DATE' THEN
5739: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
5740: ELSE

Line 5739: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

5735: l_PMV_Rec.attribute_value:=l_Report_Parameters;
5736: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5737:
5738: IF l_Substitute_Var = 'PJI_AS_OF_DATE' THEN
5739: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
5740: ELSE
5741: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5742: END IF;
5743:

Line 5741: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

5737:
5738: IF l_Substitute_Var = 'PJI_AS_OF_DATE' THEN
5739: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
5740: ELSE
5741: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5742: END IF;
5743:
5744: l_PMV_Output.EXTEND();
5745: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;

Line 5763: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

5759: Write2FWKLog('No View BY is specified. Hence substituting the view by with a dummy value.','Generate_SQL');
5760: END IF;
5761: l_PMV_Rec.attribute_name:=':PJI_VIEW_BY';
5762: l_PMV_Rec.attribute_value:='XX';
5763: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5764: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5765: l_PMV_Output.EXTEND();
5766: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5767: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;

Line 5764: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

5760: END IF;
5761: l_PMV_Rec.attribute_name:=':PJI_VIEW_BY';
5762: l_PMV_Rec.attribute_value:='XX';
5763: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5764: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5765: l_PMV_Output.EXTEND();
5766: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5767: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;
5768: l_PLSQL_Driver_Params:=REPLACE(l_PLSQL_Driver_Params,'<>',':PJI_VIEW_BY');

Line 5779: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

5775: Write2FWKLog('Defaulting the period type to view by time dimension.','Generate_SQL');
5776: END IF;
5777: l_PMV_Rec.attribute_name:=':PJI_PERIOD_TYPE';
5778: l_PMV_Rec.attribute_value:=SUBSTR(l_View_By,INSTR(l_View_By,'+')+1);
5779: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5780: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5781: l_PMV_Output.EXTEND();
5782: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5783: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;

Line 5780: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

5776: END IF;
5777: l_PMV_Rec.attribute_name:=':PJI_PERIOD_TYPE';
5778: l_PMV_Rec.attribute_value:=SUBSTR(l_View_By,INSTR(l_View_By,'+')+1);
5779: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
5780: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
5781: l_PMV_Output.EXTEND();
5782: l_PMV_Output(l_PMV_Rec_Ctr):=l_PMV_Rec;
5783: l_PMV_Rec_Ctr:=l_PMV_Rec_Ctr+1;
5784: l_PLSQL_Driver_Params:=REPLACE(l_PLSQL_Driver_Params,'<>',':PJI_PERIOD_TYPE');