DBA Data[Home] [Help]

APPS.RLM_WF_SV SQL Statements

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

Line: 177

 SELECT hsecs INTO v_start_time from v$timer;
Line: 322

   SELECT hsecs INTO v_end_time FROM v$timer;
Line: 382

       SELECT hsecs INTO l_val_start_time from v$timer;
Line: 391

       SELECT hsecs INTO l_val_end_time FROM v$timer;
Line: 502

      rlm_dp_sv.UpdateGroupPS(v_header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                        'ALL');
Line: 508

      rlm_dp_sv.UpdateHeaderPS(v_header_id,
                     g_Sch_rec.schedule_header_id);
Line: 530

      rlm_dp_sv.UpdateGroupPS(v_header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                        'ALL');
Line: 536

      rlm_dp_sv.UpdateHeaderPS(v_header_id,
                     g_Sch_rec.schedule_header_id);
Line: 590

       SELECT hsecs INTO v_md_start_time FROM v$timer;
Line: 601

        SELECT hsecs INTO v_md_end_time FROM v$timer;
Line: 682

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR);
Line: 752

       SELECT hsecs INTO v_mf_start_time FROM  v$timer;
Line: 763

       SELECT hsecs INTO v_mf_end_time FROM v$timer;
Line: 842

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR);
Line: 916

     SELECT hsecs INTO v_rd_start_time from v$timer;
Line: 927

     SELECT hsecs INTO v_rd_end_time FROM v$timer;
Line: 936

     SELECT hsecs INTO v_rlm_gps_start_time from v$timer; --Bugfix 12863728
Line: 937

     rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                             g_Sch_rec.schedule_header_id,
                             g_Grp_rec,
                             rlm_core_sv.k_PS_PROCESSED);
Line: 944

     SELECT hsecs INTO v_rlm_gps_end_time FROM v$timer; --Bugfix 12863728
Line: 965

     v_rlm_gps_msg_text:='Total Time spent in Update GroupPS call - '|| v_rlm_gps_total ; --Bugfix 12863728
Line: 1033

       rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                               g_Sch_rec.schedule_header_id,
                               g_Grp_rec,
                               rlm_core_sv.k_PS_ERROR);
Line: 1188

	SELECT process_status
	FROM rlm_schedule_headers
	WHERE header_id = p_header_id;
Line: 1193

	SELECT process_status
	FROM rlm_interface_headers
	WHERE header_id = p_header_id;
Line: 1244

       SELECT COUNT(*)
       INTO   x_errors
       FROM   rlm_interface_headers
       WHERE  header_id = v_header_id;
Line: 1590

    select schedule_reference_num, cust_name_ext, sched_generation_date
    into x_Schedule_Num, x_Customer_Name , x_Schedule_Gen_Date
    from rlm_interface_headers
    where header_id = x_Header_Id ;
Line: 1598

      rlm_core_sv.dlog(C_DEBUG,' Successful select');
Line: 1881

PROCEDURE UpdateHeaderPS(
        itemtype    IN VARCHAR2,
        itemkey     IN VARCHAR2,
        actid       IN NUMBER,
        funcmode    IN VARCHAR2,
        resultout   OUT NOCOPY VARCHAR2)
IS
  --
  v_header_id		NUMBER;
Line: 1894

       rlm_core_sv.dpush(C_SDEBUG,'UpdateHeaderPS');
Line: 1920

          SELECT * INTO g_Sch_rec
          FROM rlm_interface_headers
          WHERE header_id = v_header_id;
Line: 1925

       rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
                          g_Sch_rec.schedule_header_id);
Line: 1982

      wf_core.context('RLM_WF_SV','UpdateHeaderPS',
                       itemtype, itemkey,TO_CHAR(actid),funcmode);
Line: 1996

      wf_core.context('RLM_WF_SV','UpdateHeaderPS',
                       itemtype, itemkey,TO_CHAR(actid),funcmode);
Line: 2004

END UpdateHeaderPS;
Line: 2056

       SELECT hsecs INTO v_md_start_time FROM v$timer;
Line: 2066

        SELECT hsecs INTO v_md_end_time FROM v$timer;
Line: 2079

       SELECT hsecs INTO v_mf_start_time FROM v$timer;
Line: 2090

        SELECT hsecs INTO v_mf_end_time FROM v$timer;
Line: 2103

       SELECT hsecs INTO v_rd_start_time FROM v$timer;
Line: 2115

       SELECT hsecs INTO v_rd_end_time FROM v$timer;
Line: 2124

       SELECT hsecs INTO v_rlm_pg_gps_start_time from v$timer; --Bugfix 12863728
Line: 2125

       rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                            g_Sch_rec.schedule_header_id,
                            g_Grp_rec,
                            rlm_core_sv.k_PS_PROCESSED);
Line: 2132

       SELECT hsecs INTO v_rlm_pg_gps_end_time FROM v$timer; --Bugfix 12863728
Line: 2158

       v_rlm_pg_gps_msg_text:='Total Time spent in ProcessGroup Update GroupPS call - '|| v_rlm_pg_gps_total ; --Bugfix 12863728
Line: 2224

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR);
Line: 2269

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR);
Line: 2313

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR);
Line: 2356

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                         'ALL');
Line: 2384

     rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR);
Line: 2550

      rlm_dp_sv.UpdateGroupPS(v_header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                        'ALL');
Line: 2556

      rlm_dp_sv.UpdateHeaderPS(v_header_id,
                     g_Sch_rec.schedule_header_id);
Line: 2644

    SELECT   rih.customer_id,
             ril.ship_from_org_id,
             ril.ship_to_address_id,
             ril.ship_to_site_use_id,
             ril.ship_to_org_id,
             ril.customer_item_id,
             ril.inventory_item_id,
             ril.industry_attribute15,    --Bugfix 12947017
             ril.intrmd_ship_to_id,       --Bugfix 5911991
             ril.intmed_ship_to_org_id,   --Bugfix 5911991
             ril.order_header_id,
             ril.blanket_number,
             min(ril.start_date_time),
             ril.ship_to_customer_id
    FROM     rlm_interface_headers rih,
             rlm_interface_lines_all ril
    WHERE    ril.header_id = v_hdr_id
    AND      ril.org_id = rih.org_id
    AND      ril.header_id = rih.header_id
    AND      ril.process_status in ( rlm_core_sv.k_PS_AVAILABLE,
                                     rlm_core_sv.k_PS_PARTIAL_PROCESSED)
    GROUP BY rih.customer_id,
             ril.ship_from_org_id,
             ril.ship_to_address_id,
             ril.ship_to_site_use_id,
             ril.ship_to_org_id,
             ril.customer_item_id,
             ril.inventory_item_id,
             ril.industry_attribute15,
             ril.intrmd_ship_to_id,       --Bugfix 5911991
             ril.intmed_ship_to_org_id,   --Bugfix 5911991
             ril.order_header_id,
             ril.blanket_number,
             ril.ship_to_customer_id
    ORDER BY min(ril.start_date_time),
             ril.ship_to_address_id,
             ril.customer_item_id;
Line: 2701

       SELECT process_status
       INTO v_tmp_status
       FROM rlm_interface_headers
       WHERE header_id = v_Header_Id;
Line: 2745

               v_child_req_id.delete;
Line: 2906

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                         'ALL');
Line: 3000

      SELECT hsecs INTO l_comp_start_time FROM v$timer;
Line: 3007

      SELECT hsecs INTO l_comp_end_time FROM v$timer;
Line: 3082

      rlm_dp_sv.UpdateGroupPS(v_header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                        'ALL');
Line: 3088

      rlm_dp_sv.UpdateHeaderPS(v_header_id,
                     g_Sch_rec.schedule_header_id);
Line: 3121

      rlm_dp_sv.UpdateGroupPS(g_Sch_rec.header_id,
                    g_Sch_rec.Schedule_header_id,
                    g_Grp_rec,
                    rlm_core_sv.K_PS_PROCESSED,
                    'ALL');
Line: 3127

      rlm_dp_sv.UpdateHeaderPS(g_Sch_rec.header_id,
                     g_Sch_rec.Schedule_header_id);
Line: 3147

      rlm_dp_sv.UpdateGroupPS(v_header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                        'ALL');
Line: 3153

      rlm_dp_sv.UpdateHeaderPS(v_header_id,
                     g_Sch_rec.schedule_header_id);
Line: 3173

      rlm_dp_sv.UpdateGroupPS(v_header_id,
                        g_Sch_rec.schedule_header_id,
                        g_Grp_rec,
                        rlm_core_sv.k_PS_ERROR,
                        'ALL');
Line: 3179

      rlm_dp_sv.UpdateHeaderPS(v_header_id,
                     g_Sch_rec.schedule_header_id);
Line: 3345

  SELECT user_name
  FROM fnd_user
  WHERE user_id = v_user_id;
Line: 3422

  SELECT display_name
  FROM wf_roles
  WHERE name =
	(
	SELECT 'FND_RESP' || r.application_id || ':' || r.responsibility_id
	FROM fnd_responsibility_vl r
	WHERE r.responsibility_id = v_resp_id
	AND r.application_id = v_appl_id);
Line: 3496

	SELECT process_status
	FROM rlm_schedule_headers
	WHERE header_id = p_header_id;
Line: 3501

	SELECT process_status
	FROM rlm_interface_headers
	WHERE header_id = p_header_id;