APPS.OE_SCHEDULE_GRP SQL Statements

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

Line: 21

Procedure Update_reservation(p_index IN NUMBER,
                             x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line: 23

Procedure Update_Scheduling_Results
(p_x_sch_tbl     IN OUT NOCOPY sch_tbl_type,
 p_request_id    IN  Number,
 x_return_status OUT NOCOPY Varchar2)
IS
 l_old_org_id    Number := -99;

Line: 40

  oe_debug_pub.add('Entering oe_schedule_grp.update_scheduling_results' || p_x_sch_tbl.count ,1);

Line: 110

       g_sch_tbl.delete;

Line: 120

  oe_debug_pub.add('Exiting oe_schedule_grp.update_scheduling_results' ||
                                             x_return_status,1);

Line: 137

      ,   'update_scheduling_results'
       );

Line: 140

END Update_Scheduling_Results;

Line: 175

    OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line: 384

	      SELECT shippable_item_flag
	      INTO   l_shippable_flag
	      FROM   MTL_SYSTEM_ITEMS
	      WHERE  INVENTORY_ITEM_ID = g_sch_tbl(I).inventory_item_id
	      AND    ORGANIZATION_ID = nvl(g_sch_tbl(I).ship_from_org_id, l_line_rec.ship_from_org_id);

Line: 509

           g_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 616

       l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 678

    g_line_tbl(J).change_comments := 'ASCP UPDATE';

Line: 706

    OE_Schedule_GRP.G_ISO_Planning_Update := TRUE;

Line: 708

      oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to TRUE',5);

Line: 804

        OE_Config_Pvt.OE_MODIFY_INC_ITEMS_TBL.DELETE;

Line: 813

    OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line: 815

      oe_debug_pub.add(' Setting global OE_Schedule_GRP.G_ISO_Planning_Update to FALSE',5);

Line: 828

       Update_reservation(p_index => I,
                          x_return_status => x_return_status);

Line: 840

  g_line_tbl.delete;

Line: 841

  g_old_line_tbl.delete;

Line: 847

    OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line: 851

    g_line_tbl.delete;

Line: 852

    g_old_line_tbl.delete;

Line: 856

    OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line: 860

    g_line_tbl.delete;

Line: 861

    g_old_line_tbl.delete;

Line: 865

    OE_Schedule_GRP.G_ISO_Planning_Update := FALSE;

Line: 869

    g_line_tbl.delete;

Line: 870

    g_old_line_tbl.delete;

Line: 973

          FND_MESSAGE.SET_NAME('ONT', 'ONT_SCH_LOOP_CANT_UPDATE');

Line: 1180

 Select line_id,ato_line_id,item_type_code
 From   oe_order_lines_all
 Where  ship_set_id = p_ship_set_id;

Line: 1185

 Select line_id,ato_line_id,item_type_code
 From   oe_order_lines_all
 Where  arrival_set_id = p_arrival_set_id;

Line: 1190

 Select line_id,ato_line_id,item_type_code
 From   oe_order_lines_all
 Where  top_model_line_id = p_top_model_line_id;

Line: 1399

Procedure Update_reservation(p_index IN NUMBER,
                             x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
IS
BEGIN

  IF (NOT OE_GLOBALS.Equal(g_line_tbl(p_index).ship_from_org_id,
                          g_old_line_tbl(p_index).ship_from_org_id))
  OR  ( NOT OE_GLOBALS.Equal(g_line_tbl(p_index).inventory_item_id, g_old_line_tbl(p_index).inventory_item_id)
        AND nvl(g_line_tbl(p_index).booked_flag, 'N') = 'N'
      ) -- OR clause added for ER 6110708
  THEN

     OE_SCHEDULE_UTIL.Unreserve_Line
       (p_line_rec              => g_old_line_tbl(p_index),
        p_quantity_to_unreserve => g_old_line_tbl(p_index).reserved_quantity,
        x_return_status         => x_return_status);

Line: 1425

     OE_CONFIG_SCHEDULE_PVT.Update_Reservation
     ( p_line_rec      => g_line_tbl(p_index)
      ,p_old_line_rec  => g_old_line_tbl(p_index)
      ,x_return_status => x_return_status);

Line: 1448

END Update_Reservation;