DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_EVAG_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 21: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

17: l_current_report_start_date DATE;
18: l_previous_as_of_date DATE;
19: l_period_type_id NUMBER;
20: l_time_id_column VARCHAR2(1000);
21: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
22: l_classification VARCHAR2(32000);
23: l_where_clause VARCHAR2(32000);
24: l_view_by varchar2(1000);
25: l_row_type varchar2(10) := 'AC';

Line 150: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;

146: END IF;
147:
148: p_custom_sql := l_sqltext;
149:
150: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
151: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
152: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
153:
154: p_custom_output.EXTEND();

Line 151: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;

147:
148: p_custom_sql := l_sqltext;
149:
150: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
151: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.View_By_Type;
152: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
153:
154: p_custom_output.EXTEND();
155: p_custom_output(p_custom_output.COUNT) := l_custom_rec;

Line 160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

156:
157: IF ( l_account IS NOT NULL) THEN
158: l_custom_rec.attribute_name := ':l_account' ;
159: l_custom_rec.attribute_value:= l_account;
160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
162:
163: p_custom_output.Extend();
164: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

157: IF ( l_account IS NOT NULL) THEN
158: l_custom_rec.attribute_name := ':l_account' ;
159: l_custom_rec.attribute_value:= l_account;
160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
162:
163: p_custom_output.Extend();
164: p_custom_output(p_custom_output.count) := l_custom_rec;
165: END IF;

Line 170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

166:
167: IF ( l_classification IS NOT NULL) THEN
168: l_custom_rec.attribute_name := ':l_classification' ;
169: l_custom_rec.attribute_value:= l_classification;
170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
171: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
172:
173: p_custom_output.Extend();
174: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 171: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

167: IF ( l_classification IS NOT NULL) THEN
168: l_custom_rec.attribute_name := ':l_classification' ;
169: l_custom_rec.attribute_value:= l_classification;
170: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
171: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
172:
173: p_custom_output.Extend();
174: p_custom_output(p_custom_output.count) := l_custom_rec;
175: END IF;

Line 179: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

175: END IF;
176:
177: l_custom_rec.attribute_name := ':l_row_type' ;
178: l_custom_rec.attribute_value:= l_row_type;
179: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
180: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
181:
182: p_custom_output.Extend();
183: p_custom_output(p_custom_output.count) := l_custom_rec;

Line 180: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

176:
177: l_custom_rec.attribute_name := ':l_row_type' ;
178: l_custom_rec.attribute_value:= l_row_type;
179: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
180: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
181:
182: p_custom_output.Extend();
183: p_custom_output(p_custom_output.count) := l_custom_rec;
184: