APPS.BOM_RESOURCE_SHIFTS_PKG SQL Statements

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

Line: 10

  message_name := 'BOM_CANNOT_DELETE_SHIFT';

Line: 11

  select 1 into dummy from dual where not exists
    (select 1 from bom_resource_changes
     where  department_id = X_Department_Id
     and    resource_id   = X_Resource_Id
     and    shift_num     = X_Shift_Num);

Line: 23

PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                     X_Department_Id                  NUMBER,
                     X_Resource_Id                    NUMBER,
                     X_Shift_Num                      NUMBER,
                     X_Capacity_Units                 NUMBER,
                     X_Last_Update_Date               DATE,
                     X_Last_Updated_By                NUMBER,
                     X_Creation_Date                  DATE,
                     X_Created_By                     NUMBER,
                     X_Last_Update_Login              NUMBER DEFAULT NULL,
                     X_Attribute_Category             VARCHAR2 DEFAULT NULL,
                     X_Attribute1                     VARCHAR2 DEFAULT NULL,
                     X_Attribute2                     VARCHAR2 DEFAULT NULL,
                     X_Attribute3                     VARCHAR2 DEFAULT NULL,
                     X_Attribute4                     VARCHAR2 DEFAULT NULL,
                     X_Attribute5                     VARCHAR2 DEFAULT NULL,
                     X_Attribute6                     VARCHAR2 DEFAULT NULL,
                     X_Attribute7                     VARCHAR2 DEFAULT NULL,
                     X_Attribute8                     VARCHAR2 DEFAULT NULL,
                     X_Attribute9                     VARCHAR2 DEFAULT NULL,
                     X_Attribute10                    VARCHAR2 DEFAULT NULL,
                     X_Attribute11                    VARCHAR2 DEFAULT NULL,
                     X_Attribute12                    VARCHAR2 DEFAULT NULL,
                     X_Attribute13                    VARCHAR2 DEFAULT NULL,
                     X_Attribute14                    VARCHAR2 DEFAULT NULL,
                     X_Attribute15                    VARCHAR2 DEFAULT NULL
 ) IS
   CURSOR C IS SELECT rowid FROM BOM_RESOURCE_SHIFTS
               WHERE department_id = X_Department_Id
                 AND resource_id = X_Resource_Id
                 AND shift_num = X_Shift_Num;

Line: 55

    INSERT INTO BOM_RESOURCE_SHIFTS(
               department_id,
               resource_id,
               shift_num,
	       Capacity_Units,
               last_update_date,
               last_updated_by,
               creation_date,
               created_by,
               last_update_login,
               attribute_category,
               attribute1,
               attribute2,
               attribute3,
               attribute4,
               attribute5,
               attribute6,
               attribute7,
               attribute8,
               attribute9,
               attribute10,
               attribute11,
               attribute12,
               attribute13,
               attribute14,
               attribute15
             ) VALUES (
               X_Department_Id,
               X_Resource_Id,
               X_Shift_Num,
	       X_Capacity_Units,
               X_Last_Update_Date,
               X_Last_Updated_By,
               X_Creation_Date,
               X_Created_By,
               X_Last_Update_Login,
               X_Attribute_Category,
               X_Attribute1,
               X_Attribute2,
               X_Attribute3,
               X_Attribute4,
               X_Attribute5,
               X_Attribute6,
               X_Attribute7,
               X_Attribute8,
               X_Attribute9,
               X_Attribute10,
               X_Attribute11,
               X_Attribute12,
               X_Attribute13,
               X_Attribute14,
               X_Attribute15
             );

Line: 115

END Insert_Row;

Line: 141

  CURSOR C IS SELECT * FROM BOM_RESOURCE_SHIFTS
              WHERE  rowid = X_Rowid
              FOR UPDATE of Department_Id NOWAIT;

Line: 150

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

Line: 218

PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                     X_Department_Id                  NUMBER,
                     X_Resource_Id                    NUMBER,
                     X_Shift_Num                      NUMBER,
                     X_Capacity_Units                 NUMBER,
                     X_Last_Update_Date               DATE,
                     X_Last_Updated_By                NUMBER,
                     X_Last_Update_Login              NUMBER DEFAULT NULL,
                     X_Attribute_Category             VARCHAR2 DEFAULT NULL,
                     X_Attribute1                     VARCHAR2 DEFAULT NULL,
                     X_Attribute2                     VARCHAR2 DEFAULT NULL,
                     X_Attribute3                     VARCHAR2 DEFAULT NULL,
                     X_Attribute4                     VARCHAR2 DEFAULT NULL,
                     X_Attribute5                     VARCHAR2 DEFAULT NULL,
                     X_Attribute6                     VARCHAR2 DEFAULT NULL,
                     X_Attribute7                     VARCHAR2 DEFAULT NULL,
                     X_Attribute8                     VARCHAR2 DEFAULT NULL,
                     X_Attribute9                     VARCHAR2 DEFAULT NULL,
                     X_Attribute10                    VARCHAR2 DEFAULT NULL,
                     X_Attribute11                    VARCHAR2 DEFAULT NULL,
                     X_Attribute12                    VARCHAR2 DEFAULT NULL,
                     X_Attribute13                    VARCHAR2 DEFAULT NULL,
                     X_Attribute14                    VARCHAR2 DEFAULT NULL,
                     X_Attribute15                    VARCHAR2 DEFAULT NULL
 ) IS
BEGIN
 UPDATE BOM_RESOURCE_SHIFTS
 SET
   department_id                     =     X_Department_Id,
   resource_id                       =     X_Resource_Id,
   shift_num                         =     X_Shift_Num,
   Capacity_Units		     =     X_Capacity_Units,
   last_update_date                  =     X_Last_Update_Date,
   last_updated_by                   =     X_Last_Updated_By,
   last_update_login                 =     X_Last_Update_Login,
   attribute_category                =     X_Attribute_Category,
   attribute1                        =     X_Attribute1,
   attribute2                        =     X_Attribute2,
   attribute3                        =     X_Attribute3,
   attribute4                        =     X_Attribute4,
   attribute5                        =     X_Attribute5,
   attribute6                        =     X_Attribute6,
   attribute7                        =     X_Attribute7,
   attribute8                        =     X_Attribute8,
   attribute9                        =     X_Attribute9,
   attribute10                       =     X_Attribute10,
   attribute11                       =     X_Attribute11,
   attribute12                       =     X_Attribute12,
   attribute13                       =     X_Attribute13,
   attribute14                       =     X_Attribute14,
   attribute15                       =     X_Attribute15
   WHERE rowid = X_rowid;

Line: 273

END Update_Row;

Line: 277

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

Line: 284

END Delete_Row;