APPS.RLM_XML_API dependencies on RLM_INTERFACE_LINES_ALL

Line 344: UPDATE rlm_interface_lines_all

340: END IF;
341: --
342: FOR i IN 1..g_SchedItemTab.COUNT LOOP
343: --
344: UPDATE rlm_interface_lines_all
345: SET schedule_item_num = x_SchedItemNum
346: WHERE header_id = x_HeaderID AND
347: NVL(cust_ship_from_org_ext, k_VNULL) = NVL(g_SchedItemTab(i).ship_from_ext, k_VNULL) AND
348: NVL(cust_ship_to_ext, k_VNULL) = NVL(g_SchedItemTab(i).ship_to_ext, k_VNULL) AND

Line 451: FROM rlm_interface_lines_all

447: cust_po_release_num,
448: cust_po_date,
449: commodity_ext,
450: supplier_item_ext
451: FROM rlm_interface_lines_all
452: WHERE header_id = x_HeaderID;
453: --
454: c_ItemAttribsRec t_ItemAttribsRec;
455: --

Line 707: FROM rlm_interface_lines_all

703: v_lineid NUMBER;
704: --
705: CURSOR c_Lines IS
706: SELECT line_id
707: FROM rlm_interface_lines_all
708: WHERE header_id = x_HeaderID
709: ORDER BY schedule_item_num;
710: --
711: BEGIN

Line 723: UPDATE rlm_interface_lines_all

719: FETCH c_Lines INTO v_lineid;
720: --
721: WHILE c_Lines%FOUND LOOP
722: --
723: UPDATE rlm_interface_lines_all
724: SET line_number = v_linenumber
725: WHERE line_id = v_lineid;
726: --
727: v_linenumber := v_linenumber + 1;

Line 769: FROM rlm_interface_lines_all

765: --
766: CURSOR c_Line
767: IS
768: SELECT line_id, flex_bkt_code
769: FROM rlm_interface_lines_all
770: WHERE header_id = x_header_id
771: AND flex_bkt_flag is null;
772: --
773: CURSOR c_Bkt

Line 776: FROM rlm_interface_lines_all

772: --
773: CURSOR c_Bkt
774: IS
775: SELECT line_id, flex_bkt_code, start_date_time, end_date_time
776: FROM rlm_interface_lines_all
777: WHERE header_id = x_header_id
778: AND flex_bkt_flag = 'Y';
779: --
780: BEGIN

Line 811: UPDATE rlm_interface_lines_all

807: IF (l_debug <> -1) THEN
808: rlm_core_sv.dlog(C_DEBUG, 'Match between FLEXBKTID and BKTYPE for line', v_lineID);
809: END IF;
810: --
811: UPDATE rlm_interface_lines_all
812: SET start_date_time = v_start_date,
813: end_date_time = v_end_date
814: WHERE line_id = v_lineID;
815: --

Line 823: UPDATE rlm_interface_lines_all

819: rlm_core_sv.dlog(C_DEBUG, 'v_flexbkt', v_flexbkt);
820: rlm_core_sv.dlog(C_DEBUG, 'Replacing ' || v_flexbkt || ' with FLEXIBLE');
821: END IF;
822: --
823: UPDATE rlm_interface_lines_all
824: SET item_detail_subtype = '3'
825: WHERE line_id = v_lineID;
826: --
827: END IF;

Line 845: DELETE FROM rlm_interface_lines_all

841: END LOOP;
842: --
843: CLOSE c_Line;
844: --
845: DELETE FROM rlm_interface_lines_all
846: WHERE header_id = x_header_id
847: AND flex_bkt_flag = 'Y';
848: --
849: IF (l_debug <> -1) THEN