APPS.GHG_ORG_PROJECT_MAPPINGS_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_project_mapping_id                     NUMBER,
                      x_facility_id                            NUMBER,
                      x_from_project_id                        NUMBER,
                      x_to_project_id                          NUMBER,
                      x_from_task_number                       VARCHAR2,
                      x_to_task_number                         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: 24

SELECT ROWID
FROM   GHG_org_project_mappings_all
WHERE  project_mapping_id = x_project_mapping_id;

Line: 30

  v_debug_info := 'Inserting into GHG_org_project_mappings_all';

Line: 32

  INSERT INTO GHG_org_project_mappings_all (project_mapping_id,
                                       ghg_organization_id,
                                       from_project_id,
                                       to_project_id,
                                       from_task_number,
                                       to_task_number,
                                       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_project_mapping_id,
                                       x_facility_id,
                                       x_from_project_id,
                                       x_to_project_id,
                                       x_from_task_number,
                                       x_to_task_number,
                                       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: 87

END insert_row;

Line: 89

PROCEDURE update_row (x_rowid                    IN OUT NOCOPY VARCHAR2,
                      x_project_mapping_id                     NUMBER,
                      x_facility_id                            NUMBER,
                      x_from_project_id                        NUMBER,
                      x_to_project_id                          NUMBER,
                      x_from_task_number                       VARCHAR2,
                      x_to_task_number                         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: 112

  UPDATE GHG_org_project_mappings_all
  SET    project_mapping_id = x_project_mapping_id,
         ghg_organization_id = x_facility_id,
         from_project_id = x_from_project_id,
         to_project_id = x_to_project_id,
         from_task_number = x_from_task_number,
         to_task_number = x_to_task_number,
         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: 143

END update_row;

Line: 145

PROCEDURE delete_row (x_project_mapping_id NUMBER) IS

v_row_count NUMBER(15);

Line: 151

  DELETE FROM GHG_org_project_mappings_all
  WHERE  project_mapping_id = x_project_mapping_id;

Line: 158

END delete_row;

Line: 173

                    x_last_updated_by                        NUMBER,
                    x_last_update_date                       DATE,
                    x_last_update_login                      NUMBER) IS

v_debug_info VARCHAR2(100);

Line: 180

SELECT project_mapping_id,
       ghg_organization_id,
       from_project_id,
       to_project_id,
       from_task_number,
       to_task_number,
       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_project_mappings_all
WHERE  rowid = x_rowid
FOR UPDATE of project_mapping_id NOWAIT;

Line: 232

      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;