APPS.GHG_SYSTEM_PARAMETERS_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_po_match_emission_date                 VARCHAR2,
                      x_receipt_match_emission_date            VARCHAR2,
                      x_org_id                                 NUMBER,
                      x_set_of_books_id                        NUMBER,
                      x_gps_mandatory                          VARCHAR2,
                      x_id_flex_id                             NUMBER,
                      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: 20

SELECT ROWID
FROM   GHG_system_parameters_all
WHERE  org_id = x_org_id;

Line: 26

  v_debug_info := 'Inserting into GHG_system_parameters_all';

Line: 28

  INSERT INTO GHG_system_parameters_all (po_match_emission_date,
                                             receipt_match_emission_date,
                                             org_id,
                                             set_of_books_id,
                                             gps_mandatory,
                                             id_flex_id,
                                             created_by,
                                             creation_date,
                                             last_updated_by,
                                             last_update_date,
                                             last_update_login)
  VALUES                                    (x_po_match_emission_date,
                                             x_receipt_match_emission_date,
                                             x_org_id,
                                             x_set_of_books_id,
                                             x_gps_mandatory,
                                             x_id_flex_id,
                                             x_created_by,
                                             x_creation_date,
                                             x_last_updated_by,
                                             x_last_update_date,
                                             x_last_update_login);

Line: 75

END insert_row;

Line: 77

PROCEDURE update_row (x_rowid                    IN OUT NOCOPY VARCHAR2,
                      x_po_match_emission_date                 VARCHAR2,
                      x_receipt_match_emission_date            VARCHAR2,
                      x_org_id                                 NUMBER,
                      x_set_of_books_id                        NUMBER,
                      x_gps_mandatory                          VARCHAR2,
                      x_id_flex_id                             NUMBER,
                      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: 96

  UPDATE GHG_system_parameters_all
  SET    po_match_emission_date = x_po_match_emission_date,
         receipt_match_emission_date = x_receipt_match_emission_date,
         org_id = x_org_id,
         set_of_books_id = x_set_of_books_id,
         gps_mandatory = x_gps_mandatory,
         id_flex_id = x_id_flex_id,
         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: 123

END update_row;

Line: 125

PROCEDURE delete_row (x_org_id NUMBER) IS

v_row_count NUMBER(15);

Line: 131

  DELETE FROM GHG_system_parameters_all
  WHERE  org_id = x_org_id;

Line: 138

END delete_row;

Line: 149

                    x_last_updated_by                        NUMBER,
                    x_last_update_date                       DATE,
                    x_last_update_login                      NUMBER) IS

v_debug_info VARCHAR2(100);

Line: 156

SELECT po_match_emission_date,
       receipt_match_emission_date,
       org_id,
       set_of_books_id,
       gps_mandatory,
       id_flex_id,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date,
       last_update_login
FROM   GHG_system_parameters_all
WHERE  rowid = x_rowid
FOR UPDATE of org_id NOWAIT;

Line: 200

      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;