APPS.GHG_INTERESTED_PARTIES_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_entity_detail_id                       NUMBER,
                      x_facility_id                            NUMBER,
                      x_controlling_company                    VARCHAR2,
                      x_operational_control                    VARCHAR2,
                      x_equity_share                           VARCHAR2,
                      x_start_date                             DATE,
                      x_end_date                               DATE,
                      x_org_id                                 NUMBER,
                      x_set_of_books_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: 23

SELECT ROWID
FROM   GHG_interested_parties_all
WHERE  interested_party_id = x_entity_detail_id;

Line: 29

  v_debug_info := 'Inserting into GHG_interested_parties_all';

Line: 31

  INSERT INTO GHG_interested_parties_all (interested_party_id,
                                          ghg_organization_id,
                                          controlling_organization_id,
                                          operational_control,
                                          equity_share,
                                          start_date,
                                          end_date,
                                          org_id,
                                          set_of_books_id,
                                          created_by,
                                          creation_date,
                                          last_updated_by,
                                          last_update_date,
                                          last_update_login)
  VALUES                                 (x_entity_detail_id,
                                          x_facility_id,
                                          x_controlling_company,
                                          x_operational_control,
                                          x_equity_share,
                                          x_start_date,
                                          x_end_date,
                                          x_org_id,
                                          x_set_of_books_id,
                                          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_entity_detail_id                       NUMBER,
                      x_facility_id                            NUMBER,
                      x_controlling_company                    VARCHAR2,
                      x_operational_control                    VARCHAR2,
                      x_equity_share                           VARCHAR2,
                      x_start_date                             DATE,
                      x_end_date                               DATE,
                      x_org_id                                 NUMBER,
                      x_set_of_books_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: 108

  UPDATE GHG_interested_parties_all
  SET    interested_party_id = x_entity_detail_id,
         ghg_organization_id = x_facility_id,
         controlling_organization_id = x_controlling_company,
         operational_control = x_operational_control,
         equity_share = x_equity_share,
         start_date = x_start_date,
         end_date = x_end_date,
         org_id = x_org_id,
         set_of_books_id = x_set_of_books_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: 138

END update_row;

Line: 140

PROCEDURE delete_row (x_entity_detail_id NUMBER) IS

v_row_count NUMBER(15);

Line: 146

  DELETE FROM GHG_interested_parties_all
  WHERE  interested_party_id = x_entity_detail_id;

Line: 153

END delete_row;

Line: 167

                    x_last_updated_by                        NUMBER,
                    x_last_update_date                       DATE,
                    x_last_update_login                      NUMBER) IS

v_debug_info VARCHAR2(100);

Line: 174

SELECT interested_party_id,
       ghg_organization_id,
       controlling_organization_id,
       operational_control,
       equity_share,
       start_date,
       end_date,
       org_id,
       set_of_books_id,
       created_by,
       creation_date,
       last_updated_by,
       last_update_date,
       last_update_login
FROM   GHG_interested_parties_all
WHERE  rowid = x_rowid
FOR UPDATE of ghg_organization_id NOWAIT;

Line: 224

      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;