APPS.RLM_XML_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

  SELECT hsecs INTO l_Timer FROM v$timer;

Line: 332

  g_SchedItemTab.DELETE;

Line: 344

    UPDATE rlm_interface_lines_all
    SET schedule_item_num = x_SchedItemNum
    WHERE header_id = x_HeaderID AND
	  NVL(cust_ship_from_org_ext, k_VNULL) = NVL(g_SchedItemTab(i).ship_from_ext, k_VNULL)  AND
	  NVL(cust_ship_to_ext, k_VNULL)       = NVL(g_SchedItemTab(i).ship_to_ext, k_VNULL)    AND
	  NVL(cust_bill_to_ext, k_VNULL)       = NVL(g_SchedItemTab(i).bill_to_ext, k_VNULL)    AND
	  NVL(customer_item_ext, k_VNULL)      = NVL(g_SchedItemTab(i).cust_item_ext, k_VNULL)  AND
	  NVL(item_description_ext, k_VNULL)   = NVL(g_SchedItemTab(i).item_desc_ext, k_VNULL)  AND
	  NVL(customer_dock_code, k_VNULL)     = NVL(g_SchedItemTab(i).cust_dock_code, k_VNULL) AND
	  NVL(hazard_code_ext, k_VNULL)	       = NVL(g_SchedItemTab(i).hazrd_code_ext, k_VNULL) AND
	  NVL(customer_item_revision, k_VNULL) = NVL(g_SchedItemTab(i).cust_item_rev, k_VNULL)  AND
	  NVL(item_note_text, k_VNULL)	       = NVL(g_SchedItemTab(i).item_note_text, k_VNULL) AND
	  NVL(cust_po_number, k_VNULL)	       = NVL(g_SchedItemTab(i).cust_po_num, k_VNULL)    AND
	  NVL(cust_po_line_num, k_VNULL)       = NVL(g_SchedItemTab(i).cust_po_linnum, k_VNULL) AND
	  NVL(cust_po_release_num, k_VNULL)    = NVL(g_SchedItemTab(i).cust_po_relnum, k_VNULL) AND
          NVL(cust_po_date, k_DNULL)	       = NVL(g_SchedItemTab(i).cust_po_date, k_DNULL)   AND
	  NVL(commodity_ext, k_VNULL)	       = NVL(g_SchedItemTab(i).commodity_ext, k_VNULL)  AND
	  NVL(supplier_item_ext, k_VNULL)      = NVL(g_SchedItemTab(i).sup_item_ext, k_VNULL);

Line: 364

    UPDATE rlm_interface_headers_all
    SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),
        sched_horizon_end_date = TRUNC(sched_horizon_end_date) + 0.99999
    WHERE header_id = x_HeaderID;

Line: 372

       rlm_core_sv.dlog(C_DEBUG, '# of rows updated', SQL%ROWCOUNT);

Line: 436

    SELECT cust_ship_from_org_ext,
	   cust_ship_to_ext,
           cust_bill_to_ext,
	   customer_item_ext,
	   item_description_ext,
	   customer_dock_code,
	   hazard_code_ext,
	   customer_item_revision,
	   item_note_text,
	   cust_po_number,
	   cust_po_line_num,
	   cust_po_release_num,
	   cust_po_date,
	   commodity_ext,
	   supplier_item_ext
   FROM rlm_interface_lines_all
   WHERE header_id = x_HeaderID;

Line: 469

      InsertItemAttribRec(c_ItemAttribsRec);

Line: 663

PROCEDURE InsertItemAttribRec(x_ItemAttribsRec IN t_ItemAttribsRec) IS
  --
  v_Index	NUMBER;

Line: 670

     rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.InsertItemAttribs');

Line: 695

END InsertItemAttribRec;

Line: 698

PROCEDURE UpdateLineNumbers(x_HeaderID IN     NUMBER,
			    x_ErrCode  IN OUT NOCOPY NUMBER,
			    x_ErrMsg   IN OUT NOCOPY VARCHAR2) IS
  --
  v_linenumber NUMBER := 1;

Line: 706

    SELECT line_id
    FROM rlm_interface_lines_all
    WHERE header_id = x_HeaderID
    ORDER BY schedule_item_num;

Line: 714

     rlm_core_sv.dpush(C_SDEBUG, 'RLM_XML_API.UpdateLineNumbers');

Line: 723

    UPDATE rlm_interface_lines_all
    SET line_number = v_linenumber
    WHERE line_id = v_lineid;

Line: 744

     x_ErrMsg := x_ErrMsg || ' Unknown error in UpdateLineNumbers';

Line: 746

        rlm_core_sv.dlog(C_DEBUG,'RLM_ERROR', 'Unknown Error in UpdateLineNumbers');

Line: 751

END UpdateLineNumbers;

Line: 768

     SELECT line_id, flex_bkt_code
     FROM rlm_interface_lines_all
     WHERE header_id = x_header_id
     AND   flex_bkt_flag is null;

Line: 775

     SELECT line_id, flex_bkt_code, start_date_time, end_date_time
     FROM rlm_interface_lines_all
     WHERE header_id = x_header_id
     AND   flex_bkt_flag = 'Y';

Line: 811

        UPDATE rlm_interface_lines_all
        SET start_date_time = v_start_date,
            end_date_time   = v_end_date
        WHERE line_id = v_lineID;

Line: 823

          UPDATE rlm_interface_lines_all
          SET item_detail_subtype = '3'
          WHERE line_id = v_lineID;

Line: 845

  DELETE FROM rlm_interface_lines_all
  WHERE header_id = x_header_id
  AND  flex_bkt_flag = 'Y';

Line: 929

 SELECT standard_id
 INTO v_StdID
 FROM ecx_standards_b
 WHERE standard_code = p_msgStd
 AND   standard_type = v_stdType;

Line: 939

 SELECT ext_process_id
 INTO v_ExtProcessID
 FROM ecx_ext_processes
 WHERE standard_id = v_StdID
 AND ext_type = p_txnType
 AND ext_subtype = p_txnSubtype
 AND direction = v_Direction;

Line: 1059

 SELECT party_site_id, party_id
 INTO v_PartySiteID, v_party_id
 FROM ecx_tp_headers
 WHERE tp_header_id IN (SELECT DISTINCT tp_header_id
                        FROM ecx_tp_details
                        WHERE source_tp_location_code = v_SourceTPLocCode
                        AND   ext_process_id          = v_ExtProcessID);

Line: 1072

 SELECT cust_acct_site_id, cust_account_id
 INTO v_CustacctSiteId, v_CustAccountId
 FROM hz_cust_acct_sites_all
 WHERE party_site_id = v_PartySiteID
 AND ece_tp_location_code = v_SourceTPLocCode;