83:
84:
85: -- Local Variables.
86:
87: l_mo_line_row ic_txn_request_lines%ROWTYPE;
88: l_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
89: ll_mo_line_rec GMI_MOVE_ORDER_GLOBAL.mo_line_rec;
90: l_mo_line_tbl GMI_MOVE_ORDER_GLOBAL.mo_line_tbl;
91: -- HW BUG#:3142323
106: l_warning EXCEPTION;
107:
108: CURSOR move_order_line_cur(p_mo_line_id NUMBER) IS
109: SELECT *
110: FROM ic_txn_request_lines
111: WHERE line_id = p_mo_line_id;
112:
113: CURSOR move_order_line_cur2(p_delivery_detail_id NUMBER) IS
114: SELECT ic.*
112:
113: CURSOR move_order_line_cur2(p_delivery_detail_id NUMBER) IS
114: SELECT ic.*
115: FROM wsh_delivery_details wsh,
116: ic_txn_request_lines ic
117: WHERE ic.line_id = wsh.move_order_line_id
118: AND wsh.delivery_detail_id = p_delivery_detail_id;
119:
120: -- Bug 3274586