APPS.OE_OE_FORM_LINE dependencies on DUAL

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

1156: , p_date_format_mask IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS'
1157: , x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1158: , x_old_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
1159: , x_line_val_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Val_Tbl_Type
1160: --, x_dualum_ind OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1161: --, x_grade_ctl OUT NOCOPY NUMBER --OPM 02/JUN/00 INVCONV
1162: , x_process_warehouse_flag OUT NOCOPY VARCHAR2 --OPM 02/JUN/00
1163: --, x_ont_pricing_qty_source OUT NOCOPY NUMBER --OPM 2046190
1164: , x_ont_pricing_qty_source OUT NOCOPY VARCHAR2 -- INVCONV

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

2215: (x_line_tbl(1).inventory_item_id
2216: ,x_line_tbl(1).ship_from_org_id
2217: );
2218:
2219: -- x_dualum_ind := l_x_item_rec_type.dualum_ind; INVCONV
2220: -- x_grade_ctl := l_x_item_rec_type.grade_ctl; INVCONV
2221: x_process_warehouse_flag := l_x_item_rec_type.process_warehouse_flag;
2222: x_ont_pricing_qty_source := l_x_item_rec_type.ont_pricing_qty_source; -- OPM 2046190
2223: x_grade_control_flag := l_x_item_rec_type.grade_control_flag; -- INVCONV

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

5316: OE_Order_Cache.Load_Item (p_line_rec.inventory_item_id
5317: ,p_line_rec.ship_from_org_id
5318: ,p_line_rec.org_id); -- R12.MOAC
5319:
5320: -- x_process_controls_rec.dualum_ind := l_item_rec.dualum_ind; -- INVCONV
5321: -- x_process_controls_rec.grade_ctl := l_item_rec.grade_ctl; -- INVCONV
5322: x_process_controls_rec.process_warehouse_flag
5323: := l_item_rec.process_warehouse_flag;
5324: x_process_controls_rec.ont_pricing_qty_source := l_item_rec.ont_pricing_qty_source; -- OPM 2046190

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

5871: END IF;
5872: l_x_line_tbl(i).change_reason := p_change_reason_code;
5873: l_x_line_tbl(i).change_comments := p_change_comments;
5874: -- Bug# 4008409
5875: -- Pass ship_from_org_id for the update line since the Dual UOM control for the item can be different
5876: -- l_x_line_tbl(i).ship_from_org_id := x_line_tbl_type(i).ship_from_org_id;
5877: ELSE
5878: IF l_line_id is not null then
5879: l_x_line_tbl(i).split_from_line_id:=l_line_id;

Line 6472: FROM DUAL;

6468: --
6469: BEGIN
6470: SELECT OE_ORDER_LINES_S.NEXTVAL
6471: INTO x_line_id
6472: FROM DUAL;
6473:
6474: SELECT NVL(MAX(LINE_NUMBER)+1,1)
6475: INTO x_line_number
6476: FROM OE_ORDER_LINES_ALL