APPS.RLM_BLANKET_SV dependencies on RLM_BLANKET_RSO

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

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

Line 281: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

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

Line 292: FROM RLM_BLANKET_RSO rlm, OE_ORDER_HEADERS oe

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

Line 567: INSERT INTO RLM_BLANKET_RSO

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