APPS.BOM_BUSINESS_EVENT_PKG SQL Statements

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

Line: 41

    p_Parameter_List.DELETE;

Line: 217

         ,p_last_update_date IN DATE DEFAULT SYSDATE
         ,p_last_updated_by IN NUMBER DEFAULT NULL
         ,p_creation_date IN DATE DEFAULT SYSDATE
         ,p_created_by  IN NUMBER DEFAULT NULL
         ,p_last_update_login IN NUMBER DEFAULT NULL
         )
         IS
         l_parameter_list      wf_parameter_list_t := wf_parameter_list_t();

Line: 227

 SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
    FROM bom_structures_b
    WHERE bill_sequence_id =  p_Event_Entity_Parent_Id;

Line: 262

                (p_parameter_name => 'LAST_UPDATE_DATE'
                ,p_value    => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
                ,p_parameter_list => l_parameter_list);

Line: 267

                (p_parameter_name => 'LAST_UPDATED_BY'
                ,p_value    => p_last_updated_by
                ,p_parameter_list => l_parameter_list);

Line: 297

          ,p_last_update_date IN DATE DEFAULT SYSDATE
          ,p_last_updated_by IN NUMBER DEFAULT NULL
          ,p_creation_date IN DATE DEFAULT SYSDATE
          ,p_created_by  IN NUMBER DEFAULT NULL
          ,p_last_update_login IN NUMBER DEFAULT NULL
          )
         IS
         l_parameter_list      wf_parameter_list_t := wf_parameter_list_t();

Line: 327

                (p_parameter_name => 'LAST_UPDATE_DATE'
                ,p_value          =>  to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
                ,p_parameter_list => l_parameter_list);

Line: 332

                (p_parameter_name => 'LAST_UPDATED_BY'
                ,p_value          =>  p_last_updated_by
                ,p_parameter_list => l_parameter_list);

Line: 369

            p_last_update_date IN DATE DEFAULT SYSDATE,
            p_last_updated_by IN NUMBER DEFAULT NULL,
            p_creation_date IN DATE DEFAULT SYSDATE,
            p_created_by  IN NUMBER DEFAULT NULL,
            p_last_update_login IN NUMBER DEFAULT NULL,
            p_component_seq_id IN NUMBER DEFAULT NULL
            )

   IS
    l_parameter_list      wf_parameter_list_t := wf_parameter_list_t();

Line: 382

 SELECT common_bill_sequence_id INTO l_common_bill_sequence_id
    FROM bom_structures_b
    WHERE bill_sequence_id =  p_Event_Entity_Parent_Id;

Line: 440

                 (p_parameter_name => 'LAST_UPDATE_DATE'
                 ,p_value    => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
                 ,p_parameter_list => l_parameter_list);

Line: 445

                  (p_parameter_name => 'LAST_UPDATED_BY'
                   ,p_value    => p_last_updated_by
                   ,p_parameter_list => l_parameter_list);

Line: 520

          ,p_last_update_date IN DATE DEFAULT SYSDATE
          ,p_last_updated_by IN NUMBER DEFAULT NULL
          ,p_creation_date IN DATE DEFAULT SYSDATE
          ,p_created_by  IN NUMBER DEFAULT NULL
          ,p_last_update_login IN NUMBER DEFAULT NULL
         )
         IS
         l_parameter_list      wf_parameter_list_t := wf_parameter_list_t();

Line: 551

                (p_parameter_name => 'LAST_UPDATE_DATE'
                ,p_value          =>  to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
                ,p_parameter_list => l_parameter_list);

Line: 557

                (p_parameter_name => 'LAST_UPDATED_BY'
                ,p_value          =>  p_last_updated_by
                ,p_parameter_list => l_parameter_list);

Line: 597

           p_last_update_date IN DATE DEFAULT SYSDATE,
           p_last_updated_by IN NUMBER  DEFAULT NULL,
           p_creation_date IN DATE DEFAULT SYSDATE,
           p_created_by  IN NUMBER DEFAULT NULL,
           p_last_update_login IN NUMBER DEFAULT NULL
           )

    IS
           l_parameter_list      wf_parameter_list_t := wf_parameter_list_t();

Line: 660

                 (p_parameter_name => 'LAST_UPDATE_DATE'
                 ,p_value   => to_char(p_last_update_date,'dd-mon-yyyy hh24:mi:ss')
                 ,p_parameter_list => l_parameter_list);

Line: 665

                 (p_parameter_name => 'LAST_UPDATED_BY'
                  ,p_value    => p_last_updated_by
                  ,p_parameter_list => l_parameter_list);