APPS.RLM_BLANKET_SV dependencies on RLM_BLANKET_RSO

Line 137: -- * -99 if it found an orphan RSO in rlm_blanket_rso table.

133: --
134: -- Bug 4901148 : QueryRSO() returns one of the following values
135: -- * A valid RSO Header ID, corresponding to a record in oe_order_headers
136: -- * -1 if the RSO Header is closed
137: -- * -99 if it found an orphan RSO in rlm_blanket_rso table.
138: -- * NULL if no RSO encompasses the request date of the line.
139: --
140: IF (v_rso_hdr_id IS NOT NULL) THEN
141: --{

Line 285: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

281: --
282: CURSOR rlm_rso_pi IS
283: SELECT max(decode(oe.open_flag, 'Y', rso_hdr_id, 'N', -1, -99)),
284: effective_start_date, effective_end_date
285: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe
286: WHERE customer_id = p_customer_id AND
287: rlm.blanket_number = x_Group_rec.setup_terms_rec.blanket_number AND
288: customer_item_id = p_cust_item_id AND
289: rlm.rso_hdr_id = oe.header_id(+)

Line 296: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

292: --
293: CURSOR rlm_rso_ai IS
294: SELECT max(decode(oe.open_flag, 'Y', rso_hdr_id, 'N', -1, -99)),
295: effective_start_date, effective_end_date
296: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe
297: WHERE customer_id = p_customer_id AND
298: rlm.blanket_number = x_Group_rec.setup_terms_rec.blanket_number AND
299: rlm.customer_item_id = k_NNULL AND
300: rlm.rso_hdr_id = oe.header_id(+)

Line 571: INSERT INTO RLM_BLANKET_RSO

567: IF (l_debug <> -1) THEN
568: rlm_core_sv.dlog(C_DEBUG, 'v_customer_item_id', v_customer_item_id);
569: END IF;
570: --
571: INSERT INTO RLM_BLANKET_RSO
572: (
573: customer_id, blanket_number, rso_hdr_id,
574: customer_item_id, effective_start_date, effective_end_date
575: )