DBA Data[Home] [Help]

APPS.IBE_BI_CART_ORD_PVT dependencies on BIS_PMV_PARAMETERS_PUB

Line 31: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

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

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

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:

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

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' ;

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

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:

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

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' ;

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

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:

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

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:

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

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:

Line 201: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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' ;

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

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:

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

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' ;

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

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:

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

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