16: l_period_from DATE;
17: l_period_to DATE;
18: l_where_clause varchar2(32000);
19: l_other_account VARCHAR2(1000);
20: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
21: l_classification VARCHAR2(32000);
22: l_view_by varchar2(1000);
23: l_row_type varchar2(10) := 'AC';
24:
88: p_custom_sql := l_sqltext;
89:
90: l_custom_rec.attribute_name := ':l_other_account' ;
91: l_custom_rec.attribute_value:= l_other_account;
92: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
93: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
94:
95: p_custom_output.Extend();
96: p_custom_output(p_custom_output.count) := l_custom_rec;
89:
90: l_custom_rec.attribute_name := ':l_other_account' ;
91: l_custom_rec.attribute_value:= l_other_account;
92: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
93: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
94:
95: p_custom_output.Extend();
96: p_custom_output(p_custom_output.count) := l_custom_rec;
97:
97:
98: IF ( l_account IS NOT NULL) THEN
99: l_custom_rec.attribute_name := ':l_account' ;
100: l_custom_rec.attribute_value:= l_account;
101: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
103:
104: p_custom_output.Extend();
105: p_custom_output(p_custom_output.count) := l_custom_rec;
98: IF ( l_account IS NOT NULL) THEN
99: l_custom_rec.attribute_name := ':l_account' ;
100: l_custom_rec.attribute_value:= l_account;
101: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
102: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
103:
104: p_custom_output.Extend();
105: p_custom_output(p_custom_output.count) := l_custom_rec;
106: END IF;
107:
108: IF ( l_classification IS NOT NULL) THEN
109: l_custom_rec.attribute_name := ':l_classification' ;
110: l_custom_rec.attribute_value:= l_classification;
111: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
112: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
113:
114: p_custom_output.Extend();
115: p_custom_output(p_custom_output.count) := l_custom_rec;
108: IF ( l_classification IS NOT NULL) THEN
109: l_custom_rec.attribute_name := ':l_classification' ;
110: l_custom_rec.attribute_value:= l_classification;
111: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
112: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
113:
114: p_custom_output.Extend();
115: p_custom_output(p_custom_output.count) := l_custom_rec;
116: END IF;
116: END IF;
117:
118: l_custom_rec.attribute_name := ':l_row_type' ;
119: l_custom_rec.attribute_value:= l_row_type;
120: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
121: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
122:
123: p_custom_output.Extend();
124: p_custom_output(p_custom_output.count) := l_custom_rec;
117:
118: l_custom_rec.attribute_name := ':l_row_type' ;
119: l_custom_rec.attribute_value:= l_row_type;
120: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
121: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
122:
123: p_custom_output.Extend();
124: p_custom_output(p_custom_output.count) := l_custom_rec;
125: