APPS.OE_OE_FORM_LINE dependencies on DUAL

Line 1141: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV

1137: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1138: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1139: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1140: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1141: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1142: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1143: , x_process_warehouse_flag OUT NOCOPY VARCHAR2 --OPM 02/JUN/00
1144: --, x_ont_pricing_qty_source OUT NOCOPY NUMBER --OPM 2046190
1145: , x_ont_pricing_qty_source OUT NOCOPY VARCHAR2 -- INVCONV

Line 2159: -- x_dualum_ind := l_x_item_rec_type.dualum_ind; INVCONV

2155: (x_line_tbl(1).inventory_item_id
2156: ,x_line_tbl(1).ship_from_org_id
2157: );
2158:
2159: -- x_dualum_ind := l_x_item_rec_type.dualum_ind; INVCONV
2160: -- x_grade_ctl := l_x_item_rec_type.grade_ctl; INVCONV
2161: x_process_warehouse_flag := l_x_item_rec_type.process_warehouse_flag;
2162: x_ont_pricing_qty_source := l_x_item_rec_type.ont_pricing_qty_source; -- OPM 2046190
2163: x_grade_control_flag := l_x_item_rec_type.grade_control_flag; -- INVCONV

Line 5042: -- x_process_controls_rec.dualum_ind := l_item_rec.dualum_ind; -- INVCONV

5038: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5039: ,p_line_rec.ship_from_org_id
5040: ,p_line_rec.org_id); -- R12.MOAC
5041:
5042: -- x_process_controls_rec.dualum_ind := l_item_rec.dualum_ind; -- INVCONV
5043: -- x_process_controls_rec.grade_ctl := l_item_rec.grade_ctl; -- INVCONV
5044: x_process_controls_rec.process_warehouse_flag
5045: := l_item_rec.process_warehouse_flag;
5046: x_process_controls_rec.ont_pricing_qty_source := l_item_rec.ont_pricing_qty_source; -- OPM 2046190

Line 5574: -- Pass ship_from_org_id for the update line since the Dual UOM control for the item can be different

5570: END IF;
5571: l_x_line_tbl(i).change_reason := p_change_reason_code;
5572: l_x_line_tbl(i).change_comments := p_change_comments;
5573: -- Bug# 4008409
5574: -- Pass ship_from_org_id for the update line since the Dual UOM control for the item can be different
5575: l_x_line_tbl(i).ship_from_org_id := x_line_tbl_type(i).ship_from_org_id;
5576: ELSE
5577: IF l_line_id is not null then
5578: l_x_line_tbl(i).split_from_line_id:=l_line_id;

Line 6105: FROM DUAL;

6101: --
6102: BEGIN
6103: SELECT OE_ORDER_LINES_S.NEXTVAL
6104: INTO x_line_id
6105: FROM DUAL;
6106:
6107: SELECT NVL(MAX(LINE_NUMBER)+1,1)
6108: INTO x_line_number
6109: FROM OE_ORDER_LINES_ALL