APPS.IBU_ORDER_CAPTURE dependencies on DBMS_SQL

Line 115: l_header_cursor := dbms_sql.open_cursor;

111:
112:
113: l_header_cursor_stmt := 'select ord.source_document_id, ord.org_id, ord.source_document_type_id, ord.price_list_id, ord.transactional_curr_code, ord_src.name ';
114: l_header_cursor_stmt := l_header_cursor_stmt || ' from oe_order_headers_all ord, OE_ORDER_SOURCES ord_src where header_id = :v_a_header_id and ord.source_document_type_id= ord_src.order_source_id(+)' ;
115: l_header_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(l_header_cursor, l_header_cursor_stmt , dbms_sql.NATIVE);
117:
118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);
119:

Line 116: dbms_sql.parse(l_header_cursor, l_header_cursor_stmt , dbms_sql.NATIVE);

112:
113: l_header_cursor_stmt := 'select ord.source_document_id, ord.org_id, ord.source_document_type_id, ord.price_list_id, ord.transactional_curr_code, ord_src.name ';
114: l_header_cursor_stmt := l_header_cursor_stmt || ' from oe_order_headers_all ord, OE_ORDER_SOURCES ord_src where header_id = :v_a_header_id and ord.source_document_type_id= ord_src.order_source_id(+)' ;
115: l_header_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(l_header_cursor, l_header_cursor_stmt , dbms_sql.NATIVE);
117:
118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);
119:
120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);

Line 118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);

114: l_header_cursor_stmt := l_header_cursor_stmt || ' from oe_order_headers_all ord, OE_ORDER_SOURCES ord_src where header_id = :v_a_header_id and ord.source_document_type_id= ord_src.order_source_id(+)' ;
115: l_header_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(l_header_cursor, l_header_cursor_stmt , dbms_sql.NATIVE);
117:
118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);
119:
120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);
121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);

Line 120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);

116: dbms_sql.parse(l_header_cursor, l_header_cursor_stmt , dbms_sql.NATIVE);
117:
118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);
119:
120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);
121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);
123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);
124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);

Line 121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);

117:
118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);
119:
120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);
121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);
123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);
124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);
125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );

Line 122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);

118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);
119:
120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);
121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);
123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);
124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);
125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );
126:

Line 123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);

119:
120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);
121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);
123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);
124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);
125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );
126:
127:

Line 124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);

120: dbms_sql.define_column (l_header_cursor, 1, l_source_document_id);
121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);
123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);
124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);
125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );
126:
127:
128:

Line 125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );

121: dbms_sql.define_column (l_header_cursor, 2, l_org_id);
122: dbms_sql.define_column (l_header_cursor, 3, l_source_document_type_id);
123: dbms_sql.define_column (l_header_cursor, 4, l_pricelist_id);
124: dbms_sql.define_column (l_header_cursor, 5, l_transaction_curr_code, 15);
125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );
126:
127:
128:
129: l_dummy_id := dbms_sql.execute (l_header_cursor);

Line 129: l_dummy_id := dbms_sql.execute (l_header_cursor);

125: dbms_sql.define_column (l_header_cursor, 6, l_quote_source_code, 240 );
126:
127:
128:
129: l_dummy_id := dbms_sql.execute (l_header_cursor);
130:
131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then
132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);

Line 131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then

127:
128:
129: l_dummy_id := dbms_sql.execute (l_header_cursor);
130:
131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then
132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);

Line 132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);

128:
129: l_dummy_id := dbms_sql.execute (l_header_cursor);
130:
131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then
132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);
136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);

Line 133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);

129: l_dummy_id := dbms_sql.execute (l_header_cursor);
130:
131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then
132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);
136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);
137: dbms_sql.column_value (l_header_cursor, 6, l_quote_source_code);

Line 134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);

130:
131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then
132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);
136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);
137: dbms_sql.column_value (l_header_cursor, 6, l_quote_source_code);
138:

Line 135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);

131: if ( dbms_sql.fetch_rows(l_header_cursor)>0 ) then
132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);
136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);
137: dbms_sql.column_value (l_header_cursor, 6, l_quote_source_code);
138:
139:

Line 136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);

132: dbms_sql.column_value(l_header_cursor, 1, l_source_document_id);
133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);
136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);
137: dbms_sql.column_value (l_header_cursor, 6, l_quote_source_code);
138:
139:
140: else

Line 137: dbms_sql.column_value (l_header_cursor, 6, l_quote_source_code);

133: dbms_sql.column_value (l_header_cursor, 2, l_org_id);
134: dbms_sql.column_value (l_header_cursor, 3, l_source_document_type_id);
135: dbms_sql.column_value (l_header_cursor, 4, l_pricelist_id);
136: dbms_sql.column_value (l_header_cursor, 5, l_transaction_curr_code);
137: dbms_sql.column_value (l_header_cursor, 6, l_quote_source_code);
138:
139:
140: else
141: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 332: l_line_cursor := dbms_sql.open_cursor;

328: if (LINE_TBL.count > 0) then
329: for i in LINE_TBL.FIRST..LINE_TBL.LAST loop
330:
331: l_line_cursor_stmt := 'select org_id, ship_from_org_id, inventory_item_id, order_quantity_uom, price_list_id, unit_list_price, unit_selling_price from oe_order_lines_all where line_id=:v_line_id';
332: l_line_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_line_cursor,l_line_cursor_stmt , dbms_sql.NATIVE);
334:
335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );

Line 333: dbms_sql.parse(l_line_cursor,l_line_cursor_stmt , dbms_sql.NATIVE);

329: for i in LINE_TBL.FIRST..LINE_TBL.LAST loop
330:
331: l_line_cursor_stmt := 'select org_id, ship_from_org_id, inventory_item_id, order_quantity_uom, price_list_id, unit_list_price, unit_selling_price from oe_order_lines_all where line_id=:v_line_id';
332: l_line_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_line_cursor,l_line_cursor_stmt , dbms_sql.NATIVE);
334:
335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);

Line 335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );

331: l_line_cursor_stmt := 'select org_id, ship_from_org_id, inventory_item_id, order_quantity_uom, price_list_id, unit_list_price, unit_selling_price from oe_order_lines_all where line_id=:v_line_id';
332: l_line_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_line_cursor,l_line_cursor_stmt , dbms_sql.NATIVE);
334:
335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);

Line 336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );

332: l_line_cursor := dbms_sql.open_cursor;
333: dbms_sql.parse(l_line_cursor,l_line_cursor_stmt , dbms_sql.NATIVE);
334:
335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);
340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);

Line 337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);

333: dbms_sql.parse(l_line_cursor,l_line_cursor_stmt , dbms_sql.NATIVE);
334:
335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);
340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);
341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);

Line 338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);

334:
335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);
340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);
341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);
342:

Line 339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);

335: dbms_sql.define_column (l_line_cursor, 1, l_line_org_id );
336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);
340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);
341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);
342:
343:

Line 340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);

336: dbms_sql.define_column (l_line_cursor, 2, l_ship_from_org_id );
337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);
340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);
341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);
342:
343:
344:

Line 341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);

337: dbms_sql.define_column (l_line_cursor, 3, l_inventory_item_id);
338: dbms_sql.define_column (l_line_cursor, 4, l_ordered_quantity_uom, 3);
339: dbms_sql.define_column (l_line_cursor, 5, l_line_price_list_id);
340: dbms_sql.define_column (l_line_cursor, 6, l_unit_list_price);
341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);
342:
343:
344:
345: dbms_sql.bind_variable(l_line_cursor, ':v_line_id', LINE_TBL(i).LINE_ID) ;

Line 345: dbms_sql.bind_variable(l_line_cursor, ':v_line_id', LINE_TBL(i).LINE_ID) ;

341: dbms_sql.define_column (l_line_cursor, 7, l_unit_selling_price);
342:
343:
344:
345: dbms_sql.bind_variable(l_line_cursor, ':v_line_id', LINE_TBL(i).LINE_ID) ;
346:
347: l_dummy_id := dbms_sql.execute (l_line_cursor);
348:
349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then

Line 347: l_dummy_id := dbms_sql.execute (l_line_cursor);

343:
344:
345: dbms_sql.bind_variable(l_line_cursor, ':v_line_id', LINE_TBL(i).LINE_ID) ;
346:
347: l_dummy_id := dbms_sql.execute (l_line_cursor);
348:
349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then
350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );

Line 349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then

345: dbms_sql.bind_variable(l_line_cursor, ':v_line_id', LINE_TBL(i).LINE_ID) ;
346:
347: l_dummy_id := dbms_sql.execute (l_line_cursor);
348:
349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then
350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);

Line 350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);

346:
347: l_dummy_id := dbms_sql.execute (l_line_cursor);
348:
349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then
350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);

Line 351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );

347: l_dummy_id := dbms_sql.execute (l_line_cursor);
348:
349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then
350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);
355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);

Line 352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);

348:
349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then
350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);
355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);
356: dbms_sql.column_value (l_line_cursor, 7, l_unit_selling_price);

Line 353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);

349: if ( dbms_sql.fetch_rows(l_line_cursor) > 0) then
350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);
355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);
356: dbms_sql.column_value (l_line_cursor, 7, l_unit_selling_price);
357:

Line 354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);

350: dbms_sql.column_value(l_line_cursor, 1, l_line_org_id);
351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);
355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);
356: dbms_sql.column_value (l_line_cursor, 7, l_unit_selling_price);
357:
358:

Line 355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);

351: dbms_sql.column_value (l_line_cursor, 2, l_ship_from_org_id );
352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);
355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);
356: dbms_sql.column_value (l_line_cursor, 7, l_unit_selling_price);
357:
358:
359: else

Line 356: dbms_sql.column_value (l_line_cursor, 7, l_unit_selling_price);

352: dbms_sql.column_value (l_line_cursor, 3, l_inventory_item_id);
353: dbms_sql.column_value (l_line_cursor, 4, l_ordered_quantity_uom);
354: dbms_sql.column_value (l_line_cursor, 5, l_line_price_list_id);
355: dbms_sql.column_value (l_line_cursor, 6, l_unit_list_price);
356: dbms_sql.column_value (l_line_cursor, 7, l_unit_selling_price);
357:
358:
359: else
360: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;