APPS.RLM_AD_SV dependencies on RLM_INTERFACE_LINES_ALL

Line 312: FROM rlm_interface_lines_all

308: item_detail_type,
309: order_header_id,
310: blanket_number,
311: org_id
312: FROM rlm_interface_lines_all
313: WHERE header_id = x_InterfaceHeaderId
314: AND process_status = rlm_core_sv.k_PS_AVAILABLE ;
315: --
316: v_count NUMBER := 0;

Line 340: UPDATE rlm_interface_lines_all

336: IF c_rec.org_id IS NULL THEN
337: RAISE e_NullOrgID;
338: END IF;
339: --
340: UPDATE rlm_interface_lines_all
341: SET schedule_line_id = rlm_schedule_lines_s.nextval
342: WHERE header_id = c_rec.interface_header_id
343: AND line_id = c_rec.interface_line_id
344: AND schedule_line_id IS NULL

Line 844: FROM rlm_interface_lines_all

840: SHIP_DEL_RULE_NAME,
841: BLANKET_NUMBER,
842: ORG_ID,
843: SHIP_TO_CUSTOMER_ID
844: FROM rlm_interface_lines_all
845: WHERE header_id = x_InterfaceHeaderId
846: AND line_id = c_rec.interface_line_id
847: AND process_status = rlm_core_sv.k_PS_AVAILABLE ;
848: --

Line 877: UPDATE rlm_interface_lines_all

873: /*** Item Detail Type =5 means it is Test Transaction ****/
874: --
875: IF c_rec.item_detail_type IN ('3','5') THEN
876: --
877: UPDATE rlm_interface_lines_all
878: SET process_status = rlm_core_sv.k_PS_PROCESSED
879: WHERE header_id = x_InterfaceHeaderId
880: AND line_id = c_rec.interface_line_id
881: AND process_status = rlm_core_sv.k_PS_AVAILABLE;