[Home] [Help]
9780: END IF;
9781: --
9782: SELECT cust_po_number
9783: INTO v_blanket_po
9784: FROM oe_blanket_headers
9785: WHERE order_number = x_Group_rec.setup_terms_rec.blanket_number;
9786: --
9787: IF (l_debug <> -1) THEN
9788: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number', x_Group_rec.setup_terms_rec.blanket_number);
9940: END IF;
9941: --
9942: SELECT start_date_active, end_date_active, on_hold_flag
9943: INTO v_startdate, v_enddate, v_onholdflag
9944: FROM oe_blanket_headers_ext
9945: WHERE order_number = x_Group_rec.setup_terms_rec.blanket_number;
9946: --
9947: IF (l_debug <> -1) THEN
9948: rlm_core_sv.dlog(C_DEBUG, 'Blanket Number',x_Group_rec.setup_terms_rec.blanket_number);