DBA Data[Home] [Help]

APPS.BIX_PMV_EMC_EVAT_PRTLT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 28: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

24: l_classification VARCHAR2(32000);
25: l_view_by varchar2(1000);
26: l_row_type varchar2(10) := 'AC';
27:
28: l_custom_rec BIS_QUERY_ATTRIBUTES := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
29:
30: BEGIN
31:
32: --

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

149:
150: p_custom_output.EXTEND();
151: l_custom_rec.attribute_name := ':l_max_collect_date';
152: l_custom_rec.attribute_value:= l_max_collect_date;
153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
155: p_custom_output(p_custom_output.count) := l_custom_rec;
156:
157: p_custom_output.EXTEND();

Line 154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

150: p_custom_output.EXTEND();
151: l_custom_rec.attribute_name := ':l_max_collect_date';
152: l_custom_rec.attribute_value:= l_max_collect_date;
153: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
154: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
155: p_custom_output(p_custom_output.count) := l_custom_rec;
156:
157: p_custom_output.EXTEND();
158: l_custom_rec.attribute_name := ':l_period_type_id' ;

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

156:
157: p_custom_output.EXTEND();
158: l_custom_rec.attribute_name := ':l_period_type_id' ;
159: l_custom_rec.attribute_value:= 1;
160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
162: p_custom_output(p_custom_output.count) := l_custom_rec;
163:
164: p_custom_output.EXTEND();

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

157: p_custom_output.EXTEND();
158: l_custom_rec.attribute_name := ':l_period_type_id' ;
159: l_custom_rec.attribute_value:= 1;
160: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
161: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
162: p_custom_output(p_custom_output.count) := l_custom_rec;
163:
164: p_custom_output.EXTEND();
165: l_custom_rec.attribute_name := ':l_other_account' ;

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

163:
164: p_custom_output.EXTEND();
165: l_custom_rec.attribute_name := ':l_other_account' ;
166: l_custom_rec.attribute_value:= l_other_account;
167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
169: p_custom_output(p_custom_output.count) := l_custom_rec;
170:
171: IF ( l_account IS NOT NULL) THEN

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

164: p_custom_output.EXTEND();
165: l_custom_rec.attribute_name := ':l_other_account' ;
166: l_custom_rec.attribute_value:= l_other_account;
167: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
168: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
169: p_custom_output(p_custom_output.count) := l_custom_rec;
170:
171: IF ( l_account IS NOT NULL) THEN
172: l_custom_rec.attribute_name := ':l_account' ;

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

170:
171: IF ( l_account IS NOT NULL) THEN
172: l_custom_rec.attribute_name := ':l_account' ;
173: l_custom_rec.attribute_value:= l_account;
174: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
175: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
176:
177: p_custom_output.Extend();
178: p_custom_output(p_custom_output.count) := l_custom_rec;

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

171: IF ( l_account IS NOT NULL) THEN
172: l_custom_rec.attribute_name := ':l_account' ;
173: l_custom_rec.attribute_value:= l_account;
174: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
175: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
176:
177: p_custom_output.Extend();
178: p_custom_output(p_custom_output.count) := l_custom_rec;
179: END IF;

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

180:
181: IF ( l_classification IS NOT NULL) THEN
182: l_custom_rec.attribute_name := ':l_classification' ;
183: l_custom_rec.attribute_value:= l_classification;
184: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
185: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
186:
187: p_custom_output.Extend();
188: p_custom_output(p_custom_output.count) := l_custom_rec;

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

181: IF ( l_classification IS NOT NULL) THEN
182: l_custom_rec.attribute_name := ':l_classification' ;
183: l_custom_rec.attribute_value:= l_classification;
184: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
185: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
186:
187: p_custom_output.Extend();
188: p_custom_output(p_custom_output.count) := l_custom_rec;
189: END IF;

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

189: END IF;
190:
191: l_custom_rec.attribute_name := ':l_row_type' ;
192: l_custom_rec.attribute_value:= l_row_type;
193: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
194: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
195:
196: p_custom_output.Extend();
197: p_custom_output(p_custom_output.count) := l_custom_rec;

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

190:
191: l_custom_rec.attribute_name := ':l_row_type' ;
192: l_custom_rec.attribute_value:= l_row_type;
193: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
194: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
195:
196: p_custom_output.Extend();
197: p_custom_output(p_custom_output.count) := l_custom_rec;
198: