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: 235

         ,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: 245

 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: 280

                (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: 285

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

Line: 315

          ,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: 345

                (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: 350

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

Line: 387

            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: 400

 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: 458

                 (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: 463

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

Line: 499

               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,
               p_return_status  OUT NOCOPY VARCHAR2, --Added for bug 8437166
               p_msg_data  OUT NOCOPY VARCHAR2  --Added for bug 8437166
               )

      IS
            l_message_list          ERROR_HANDLER.Error_Tbl_Type;

Line: 522

                            ,p_last_update_date     =>  p_last_update_date
                            ,p_last_updated_by      =>  p_last_updated_by
                            ,p_creation_date        =>  p_creation_date
                            ,p_created_by           =>  p_created_by
                            ,p_last_update_login    =>  p_last_update_login
                            ,p_component_seq_id     =>  p_component_seq_id
                            );

Line: 594

          ,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: 625

                (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: 631

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

Line: 671

           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: 734

                 (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: 739

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

Line: 777

           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_return_status  OUT NOCOPY VARCHAR2, --Added for bug 9108842
           p_msg_data  OUT NOCOPY VARCHAR2  --Added for bug 9108842
          )
        IS
     		 l_message_list  	ERROR_HANDLER.Error_Tbl_Type;

Line: 801

							p_last_update_date      								=>     p_last_update_date         ,
							p_last_updated_by       								=>     p_last_updated_by          ,
							p_creation_date         								=>     p_creation_date            ,
							p_created_by            								=>     p_created_by               ,
							p_last_update_login     								=>     p_last_update_login
		          );