APPS.WIP_LEADTIME_TEMP_PKG SQL Statements

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

Line: 10

select to_seq_num
from   bom_operation_networks_v
where  routing_sequence_id = p_routing_sequence_id
and    from_seq_num = p_seq_num
and    transition_type = 1 ;

Line: 18

select distinct operation_seq_num
from   bom_operation_sequences
where  routing_sequence_id = p_routing_sequence_id
and    implementation_date is not null ;

Line: 29

procedure insert_temp (p_routing_seq_id number,
                       p_from_op number,
                       p_order number)
is
begin
   insert into wip_leadtime_temp  ( routing_sequence_id,
                                    operation_seq_num,
                                    network_order
                                  )
                           values ( p_routing_seq_id,
                                    p_from_op,
                                    p_order
                                  );

Line: 43

end insert_temp ;

Line: 53

     select distinct from_seq_num
     into   l_from_op
     from   bom_operation_networks_v a
     where  routing_sequence_id = p_routing_sequence_id
     and    not exists  (select 1
                         from   bom_operation_networks_v b
                         where  a.routing_sequence_id = b.routing_sequence_id
                         and    b.to_seq_num = a.from_seq_num
                         and    b.transition_type = 1
                         )
     and    a.transition_type = 1 ;

Line: 66

      fnd_file.put_line (fnd_file.log, 'Inserting into wip_leadtime_temp for Network routing ' || p_routing_sequence_id );

Line: 70

     insert_temp(p_routing_sequence_id, l_from_op, l_order)  ;

Line: 76

               fnd_file.put_line (fnd_file.log, 'Inserting into wip_leadtime_temp for Non Network routing ' || p_routing_sequence_id );          end if ;

Line: 81

                  insert_temp(p_routing_sequence_id, routing_rec.operation_seq_num, l_order)  ;

Line: 103

      insert_temp(p_routing_sequence_id, l_from_op, l_order)  ;

Line: 118

function wip_delete_leadtime_temp (p_debug_level IN number) return number
as
begin

  delete wip_leadtime_temp  ;

Line: 124

     fnd_file.put_line (fnd_file.log, 'Deleted rows ' || sql%ROWCOUNT  ||' from wip_leadtime_temp '  );

Line: 133

end wip_delete_leadtime_temp ;