27: END IF;
28:
29: --initializing the variables
30:
31: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
32: l_global_primary := '''FII_GLOBAL1''';
33: l_global_secondary := '''FII_GLOBAL2''';
34:
35: FOR i IN p_pmv_parameters.FIRST..p_pmv_parameters.LAST
174: x_custom_output.Extend(6);
175:
176: l_custom_rec.attribute_name := ':l_asof_date' ;
177: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');
178: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
179: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
180:
181: x_custom_output(1) := l_custom_rec;
182:
175:
176: l_custom_rec.attribute_name := ':l_asof_date' ;
177: l_custom_rec.attribute_value:= to_char(l_asof_date,'dd/mm/yyyy');
178: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
179: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
180:
181: x_custom_output(1) := l_custom_rec;
182:
183: l_custom_rec.attribute_name := ':l_prev_date' ;
181: x_custom_output(1) := l_custom_rec;
182:
183: l_custom_rec.attribute_name := ':l_prev_date' ;
184: l_custom_rec.attribute_value:= to_char(l_prev_date,'dd/mm/yyyy');
185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
187:
188: x_custom_output(2) := l_custom_rec;
189:
182:
183: l_custom_rec.attribute_name := ':l_prev_date' ;
184: l_custom_rec.attribute_value:= to_char(l_prev_date,'dd/mm/yyyy');
185: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
186: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
187:
188: x_custom_output(2) := l_custom_rec;
189:
190: l_custom_rec.attribute_name := ':l_currency_code' ;
188: x_custom_output(2) := l_custom_rec;
189:
190: l_custom_rec.attribute_name := ':l_currency_code' ;
191: l_custom_rec.attribute_value:= l_currency_code;
192: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
194:
195: x_custom_output(3) := l_custom_rec;
196:
189:
190: l_custom_rec.attribute_name := ':l_currency_code' ;
191: l_custom_rec.attribute_value:= l_currency_code;
192: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
193: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
194:
195: x_custom_output(3) := l_custom_rec;
196:
197:
196:
197:
198: l_custom_rec.attribute_name := ':l_record_type_id' ;
199: l_custom_rec.attribute_value:= l_record_type_id;
200: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
201: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
202:
203: x_custom_output(4) := l_custom_rec;
204:
197:
198: l_custom_rec.attribute_name := ':l_record_type_id' ;
199: l_custom_rec.attribute_value:= l_record_type_id;
200: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
201: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
202:
203: x_custom_output(4) := l_custom_rec;
204:
205: l_custom_rec.attribute_name := ':l_global_primary' ;
203: x_custom_output(4) := l_custom_rec;
204:
205: l_custom_rec.attribute_name := ':l_global_primary' ;
206: l_custom_rec.attribute_value:= l_global_primary;
207: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
208: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
209:
210: x_custom_output(5) := l_custom_rec;
211:
204:
205: l_custom_rec.attribute_name := ':l_global_primary' ;
206: l_custom_rec.attribute_value:= l_global_primary;
207: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
208: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
209:
210: x_custom_output(5) := l_custom_rec;
211:
212: l_custom_rec.attribute_name := ':l_global_secondary' ;
210: x_custom_output(5) := l_custom_rec;
211:
212: l_custom_rec.attribute_name := ':l_global_secondary' ;
213: l_custom_rec.attribute_value:= l_global_secondary;
214: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
215: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
216:
217: x_custom_output(6) := l_custom_rec;
218:
211:
212: l_custom_rec.attribute_name := ':l_global_secondary' ;
213: l_custom_rec.attribute_value:= l_global_secondary;
214: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
215: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
216:
217: x_custom_output(6) := l_custom_rec;
218:
219: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN