APPS.GHG_SIC_MAPPING_PKG SQL Statements

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

Line: 4

PROCEDURE insert_row (x_rowid                    IN OUT NOCOPY VARCHAR2,
                      x_sic_mapping_id                         NUMBER,
                      x_ghg_organization_id                    NUMBER,
                      x_sic_code                               VARCHAR2,
                      x_division_code                          VARCHAR2,
                      x_org_id                                 NUMBER,
                      x_set_of_books_id                        NUMBER,
                      x_start_date                             DATE,
                      x_end_date                               DATE,
                      x_created_by                             NUMBER,
                      x_creation_date                          DATE,
                      x_last_updated_by                        NUMBER,
                      x_last_update_date                       DATE,
                      x_last_update_login                      NUMBER) IS

v_debug_info VARCHAR2(100);

Line: 22

SELECT ROWID
FROM   GHG_ORG_SIC_MAPPINGS_ALL
WHERE  sic_mapping_id = x_sic_mapping_id;

Line: 28

  v_debug_info := 'Inserting into GHG_ORG_SIC_MAPPINGS_ALL';

Line: 30

  INSERT INTO GHG_ORG_SIC_MAPPINGS_ALL (sic_mapping_id,
                                          ghg_organization_id,
                                          sic_code,
                                          division_code,
                                          org_id,
                                          set_of_books_id,
                                          start_date,
                                          end_date,
                                          created_by,
                                          creation_date,
                                          last_updated_by,
                                          last_update_date,
                                          last_update_login)
  VALUES                                 (x_sic_mapping_id,
                                          x_ghg_organization_id,
                                          x_sic_code,
                                          x_division_code,
                                          x_org_id,
                                          x_set_of_books_id,
                                          x_start_date,
                                          x_end_date,
                                          x_created_by,
                                          x_creation_date,
                                          x_last_updated_by,
                                          x_last_update_date,
                                          x_last_update_login);

Line: 84

END insert_row;

Line: 86

PROCEDURE update_row (x_rowid                    IN OUT NOCOPY VARCHAR2,
                      x_sic_mapping_id                         NUMBER,
                      x_ghg_organization_id                    NUMBER,
                      x_sic_code                               VARCHAR2,
                      x_division_code                          VARCHAR2,
                      x_org_id                                 NUMBER,
                      x_set_of_books_id                        NUMBER,
                      x_start_date                             DATE,
                      x_end_date                               DATE,
                      x_created_by                             NUMBER,
                      x_creation_date                          DATE,
                      x_last_updated_by                        NUMBER,
                      x_last_update_date                       DATE,
                      x_last_update_login                      NUMBER) IS

v_debug_info VARCHAR2(100);

Line: 107

  UPDATE GHG_ORG_SIC_MAPPINGS_ALL
  SET    sic_mapping_id = x_sic_mapping_id,
         ghg_organization_id = x_ghg_organization_id,
         sic_code = x_sic_code,
         division_code = x_division_code,
         org_id = x_org_id,
         set_of_books_id = x_set_of_books_id,
         start_date = x_start_date,
         end_date = x_end_date,
         created_by = x_created_by,
         creation_date = x_creation_date,
         last_updated_by = x_last_updated_by,
         last_update_date = x_last_update_date,
         last_update_login = x_last_update_login
  WHERE  rowid = x_rowid;

Line: 136

END update_row;

Line: 138

PROCEDURE delete_row (x_sic_mapping_id VARCHAR2) IS

BEGIN

  DELETE FROM GHG_ORG_SIC_MAPPINGS_ALL
  WHERE  sic_mapping_id = x_sic_mapping_id;

Line: 149

END delete_row;

Line: 162

                    x_last_updated_by                        NUMBER,
                    x_last_update_date                       DATE,
                    x_last_update_login                      NUMBER) IS

v_debug_info VARCHAR2(100);

Line: 169

SELECT sic_mapping_id,
       ghg_organization_id,
       sic_code,
       division_code,
       org_id,
       set_of_books_id,
       start_date,
       end_date,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date,
       last_update_login
FROM   GHG_ORG_SIC_MAPPINGS_ALL
WHERE  rowid = x_rowid
FOR UPDATE of sic_mapping_id NOWAIT;

Line: 217

      AND ((recinfo.last_updated_by = x_last_updated_by) OR (recinfo.last_updated_by IS NULL AND x_last_updated_by IS NULL))
      AND ((recinfo.last_update_date = x_last_update_date) OR (recinfo.last_update_date IS NULL AND x_last_update_date IS NULL))
      AND ((recinfo.last_update_login = x_last_update_login) OR (recinfo.last_update_login IS NULL AND x_last_update_login IS NULL))  ) THEN
        NULL;