APPS.IGI_SAP_GROUP_PKG SQL Statements

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

Line: 14

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Group_Id                       IN OUT NOCOPY NUMBER,
                       X_Group_Name                     VARCHAR2,
                       X_Org_Id                         NUMBER,  /* bug # 5905278 start SIA R12 Uptake*/
                       X_Creation_Date                  DATE,
                       X_Created_By                     NUMBER,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
 CURSOR C IS SELECT rowid FROM IGI_SAP_GROUP
                 WHERE group_id = X_Group_Id;

Line: 26

    CURSOR C2 IS SELECT igi_igi_sap_group_s.nextval FROM sys.dual;

Line: 33

   INSERT INTO IGI_SAP_GROUP(
              group_id,
              group_name,
              org_id,          /* bug # 5905278 start SIA R12 Uptake */
              creation_date,
              created_by,
              last_update_login,
              last_update_date,
              last_updated_by
             ) VALUES (
              X_Group_Id,
              X_Group_Name,
              X_Org_Id,        /* bug # 5905278 start SIA R12 Uptake */
              X_Creation_Date,
              X_Created_By,
              X_Last_Update_Login,
              X_Last_Update_Date,
              X_Last_Updated_By
             );

Line: 59

  END Insert_Row;

Line: 65

        SELECT *
 	FROM	IGI_SAP_GROUP
        WHERE  rowid = X_Rowid
        FOR UPDATE of Group_Id NOWAIT;

Line: 75

      FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 99

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Group_Id                       NUMBER,
                       X_Group_Name                     VARCHAR2,
                       X_Last_Update_Login              NUMBER,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER
  ) IS
  BEGIN
 	UPDATE IGI_SAP_GROUP
    SET
       group_id                        =     X_Group_Id,
       group_name                      =     X_Group_Name,
       last_update_login               =     X_Last_Update_Login,
       last_update_date                =     X_Last_Update_Date,
       last_updated_by                 =     X_Last_Updated_By
    WHERE rowid = X_Rowid;

Line: 118

  END Update_Row;

Line: 119

  PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
  BEGIN
    DELETE FROM IGI_SAP_GROUP
    WHERE rowid = X_Rowid;

Line: 126

  END Delete_Row;