DBA Data[Home] [Help]

APPS.PJI_PMV_PROFITABILITY_TREND dependencies on BIS_PMV_PARAMETERS_PUB

Line 98: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

94: ', <>'||
95: ', NULL'
96: );
97:
98: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
99: l_PMV_Rec.attribute_name:=':PJI_EXTRA_BND_01';
100: l_PMV_Rec.attribute_value:='FISCAL';
101: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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

97:
98: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
99: l_PMV_Rec.attribute_name:=':PJI_EXTRA_BND_01';
100: l_PMV_Rec.attribute_value:='FISCAL';
101: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
103:
104: x_PMV_Output.EXTEND();
105: x_PMV_Output(x_PMV_Output.COUNT):=l_PMV_Rec;

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

98: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
99: l_PMV_Rec.attribute_name:=':PJI_EXTRA_BND_01';
100: l_PMV_Rec.attribute_value:='FISCAL';
101: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
103:
104: x_PMV_Output.EXTEND();
105: x_PMV_Output(x_PMV_Output.COUNT):=l_PMV_Rec;
106:

Line 189: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

185: ', NULL'||
186: ', <> '
187: );
188:
189: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
190: l_PMV_Rec.attribute_name:=':PJI_EXTRA_BND_01';
191: l_PMV_Rec.attribute_value:='FISCAL';
192: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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

188:
189: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
190: l_PMV_Rec.attribute_name:=':PJI_EXTRA_BND_01';
191: l_PMV_Rec.attribute_value:='FISCAL';
192: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
194:
195: x_PMV_Output.EXTEND();
196: x_PMV_Output(x_PMV_Output.COUNT):=l_PMV_Rec;

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

189: l_PMV_Rec:=BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
190: l_PMV_Rec.attribute_name:=':PJI_EXTRA_BND_01';
191: l_PMV_Rec.attribute_value:='FISCAL';
192: l_PMV_Rec.attribute_type:=BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_PMV_Rec.attribute_data_type:=BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
194:
195: x_PMV_Output.EXTEND();
196: x_PMV_Output(x_PMV_Output.COUNT):=l_PMV_Rec;
197: END Get_SQL_PJI_REP_PP8;