APPS.RLM_AD_SV dependencies on RLM_INTERFACE_LINES

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;

Line 1042: UPDATE rlm_interface_lines

1038: END IF;
1039: --
1040: IF c_rec.edi_test_indicator = 'T' THEN
1041: --
1042: UPDATE rlm_interface_lines
1043: SET process_status = rlm_core_sv.k_PS_PROCESSED
1044: WHERE header_id = x_InterfaceHeaderId
1045: AND process_status = rlm_core_sv.k_PS_AVAILABLE;
1046: --