eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.B_STD_OP_RES_PKG SQL Statements

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

Line: 5


PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Standard_Operation_Id               NUMBER,
                     X_Resource_Id                         NUMBER,
                     X_Activity_Id                         NUMBER DEFAULT NULL,
                     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_Resource_Seq_Num                    NUMBER,
                     X_Usage_Rate_Or_Amount                NUMBER,
                     X_Usage_Rate_Or_Amount_Inverse        NUMBER,
                     X_Basis_Type                          NUMBER,
                     X_Autocharge_Type                     NUMBER,
                     X_Standard_Rate_Flag                  NUMBER,
                     X_Assigned_Units                      NUMBER DEFAULT NULL,
                     X_Schedule_Flag                       NUMBER,
                     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
          Insert_Row(X_Rowid                             => X_Rowid,
                     X_Standard_Operation_Id             => X_Standard_Operation_Id,
                     X_Resource_Id                       => X_Resource_Id,
		     X_Substitute_Group_Num              => NULL,
                     X_Activity_Id                       => X_Activity_Id,
                     X_Last_Update_Date                  => X_Last_Update_Date,
                     X_Last_Updated_By                   => X_Last_Updated_By,
                     X_Creation_Date                     => X_Creation_Date,
                     X_Created_By                        => X_Created_By,
                     X_Last_Update_Login                 => X_Last_Update_Login,
                     X_Resource_Seq_Num                  => X_Resource_Seq_Num,
                     X_Usage_Rate_Or_Amount              => X_Usage_Rate_Or_Amount,
                     X_Usage_Rate_Or_Amount_Inverse      => X_Usage_Rate_Or_Amount_Inverse,
                     X_Basis_Type                        => X_Basis_Type,
                     X_Autocharge_Type                   => X_Autocharge_Type,
                     X_Standard_Rate_Flag                => X_Standard_Rate_Flag,
                     X_Assigned_Units                    => X_Assigned_Units,
                     X_Schedule_Flag                     => X_Schedule_Flag,
                     X_Attribute_Category                => X_Attribute_Category,
                     X_Attribute1                        => X_Attribute1,
                     X_Attribute2                        => X_Attribute2,
                     X_Attribute3                        => X_Attribute3,
                     X_Attribute4                        => X_Attribute4,
                     X_Attribute5                        => X_Attribute5,
                     X_Attribute6                        => X_Attribute6,
                     X_Attribute7                        => X_Attribute7,
                     X_Attribute8                        => X_Attribute8,
                     X_Attribute9                        => X_Attribute9,
                     X_Attribute10                       => X_Attribute10,
                     X_Attribute11                       => X_Attribute11,
                     X_Attribute12                       => X_Attribute12,
                     X_Attribute13                       => X_Attribute13,
                     X_Attribute14                       => X_Attribute14,
                     X_Attribute15                       => X_Attribute15,
                     X_SCHEDULE_SEQ_NUM                  => NULL, -- Bug#14550670
                     X_PRINCIPLE_FLAG                    => NULL -- Bug#14550670
  );

Line: 79


END Insert_Row;

Line: 81


PROCEDURE Insert_Row(X_Rowid                        IN OUT NOCOPY VARCHAR2,
                     X_Standard_Operation_Id               NUMBER,
                     X_Resource_Id                         NUMBER,
		     X_Substitute_Group_Num                NUMBER,
                     X_Activity_Id                         NUMBER DEFAULT NULL,
                     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_Resource_Seq_Num                    NUMBER,
                     X_Usage_Rate_Or_Amount                NUMBER,
                     X_Usage_Rate_Or_Amount_Inverse        NUMBER,
                     X_Basis_Type                          NUMBER,
                     X_Autocharge_Type                     NUMBER,
                     X_Standard_Rate_Flag                  NUMBER,
                     X_Assigned_Units                      NUMBER DEFAULT NULL,
                     X_Schedule_Flag                       NUMBER,
                     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,
                     X_SCHEDULE_SEQ_NUM                    NUMBER DEFAULT NULL, -- Bug#14550670
                     X_PRINCIPLE_FLAG                      NUMBER DEFAULT NULL  -- Bug#14550670
 ) IS
   CURSOR C IS SELECT rowid FROM BOM_STD_OP_RESOURCES
             WHERE standard_operation_id = X_Standard_Operation_Id
             AND   resource_seq_num = X_Resource_Seq_Num;

Line: 123


  INSERT INTO BOM_STD_OP_RESOURCES(
          standard_operation_id,
          resource_id,
	  substitute_group_num,
          activity_id,
          last_update_date,
          last_updated_by,
          creation_date,
          created_by,
          last_update_login,
          resource_seq_num,
          usage_rate_or_amount,
          usage_rate_or_amount_inverse,
          basis_type,
          autocharge_type,
          standard_rate_flag,
          assigned_units,
          schedule_flag,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          schedule_seq_num,  -- Bug#14550670
          principle_flag     -- Bug#14550670
         ) VALUES (
          X_Standard_Operation_Id,
          X_Resource_Id,
	  X_Substitute_Group_Num,
          X_Activity_Id,
          X_Last_Update_Date,
          X_Last_Updated_By,
          X_Creation_Date,
          X_Created_By,
          X_Last_Update_Login,
          X_Resource_Seq_Num,
          X_Usage_Rate_Or_Amount,
          X_Usage_Rate_Or_Amount_Inverse,
          X_Basis_Type,
          X_Autocharge_Type,
          X_Standard_Rate_Flag,
          X_Assigned_Units,
          X_Schedule_Flag,
          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,
          X_Schedule_Seq_Num, -- Bug#14550670
          X_Principle_Flag    -- Bug#14550670

  );

Line: 205


END Insert_Row;

Line: 307


      SELECT *
      FROM   BOM_STD_OP_RESOURCES
      WHERE  rowid = X_Rowid
      FOR UPDATE of Standard_Operation_Id, Substitute_Group_Num NOWAIT;

Line: 317


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

Line: 422


PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Standard_Operation_Id               NUMBER,
                     X_Resource_Id                         NUMBER,
                     X_Activity_Id                         NUMBER DEFAULT NULL,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Last_Update_Login                   NUMBER DEFAULT NULL,
                     X_Resource_Seq_Num                    NUMBER,
                     X_Usage_Rate_Or_Amount                NUMBER,
                     X_Usage_Rate_Or_Amount_Inverse        NUMBER,
                     X_Basis_Type                          NUMBER,
                     X_Autocharge_Type                     NUMBER,
                     X_Standard_Rate_Flag                  NUMBER,
                     X_Assigned_Units                      NUMBER DEFAULT NULL,
                     X_Schedule_Flag                       NUMBER,
                     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_Row(X_Rowid                               => X_Rowid,
                     X_Standard_Operation_Id               => X_Standard_Operation_Id,
                     X_Resource_Id                         => X_Resource_Id,
		     X_Substitute_Group_Num                => NULL,
                     X_Activity_Id                         => X_Activity_Id,
                     X_Last_Update_Date                    => X_Last_Update_Date,
                     X_Last_Updated_By                     => X_Last_Updated_By,
                     X_Last_Update_Login                   => X_Last_Update_Login,
                     X_Resource_Seq_Num                    => X_Resource_Seq_Num,
                     X_Usage_Rate_Or_Amount                => X_Usage_Rate_Or_Amount,
                     X_Usage_Rate_Or_Amount_Inverse        => X_Usage_Rate_Or_Amount_Inverse,
                     X_Basis_Type                          => X_Basis_Type,
                     X_Autocharge_Type                     => X_Autocharge_Type,
                     X_Standard_Rate_Flag                  => X_Standard_Rate_Flag,
                     X_Assigned_Units                      => X_Assigned_Units,
                     X_Schedule_Flag                       => X_Schedule_Flag,
                     X_Attribute_Category                  => X_Attribute_Category,
                     X_Attribute1                            => X_Attribute1,
                     X_Attribute2                            => X_Attribute2,
                     X_Attribute3                            => X_Attribute3,
                     X_Attribute4                            => X_Attribute4,
                     X_Attribute5                            => X_Attribute5,
                     X_Attribute6                            => X_Attribute6,
                     X_Attribute7                            => X_Attribute7,
                     X_Attribute8                            => X_Attribute8,
                     X_Attribute9                            => X_Attribute9,
                     X_Attribute10                           => X_Attribute10,
                     X_Attribute11                           => X_Attribute11,
                     X_Attribute12                           => X_Attribute12,
                     X_Attribute13                           => X_Attribute13,
                     X_Attribute14                           => X_Attribute14,
                     X_Attribute15                           => X_Attribute15,
                     X_SCHEDULE_SEQ_NUM                      => NULL, -- Bug#14550670
                     X_PRINCIPLE_FLAG                        => NULL  -- Bug#14550670
);

Line: 491


END Update_Row;

Line: 493


PROCEDURE Update_Row(X_Rowid                               VARCHAR2,
                     X_Standard_Operation_Id               NUMBER,
                     X_Resource_Id                         NUMBER,
		     X_Substitute_Group_Num                NUMBER,
                     X_Activity_Id                         NUMBER DEFAULT NULL,
                     X_Last_Update_Date                    DATE,
                     X_Last_Updated_By                     NUMBER,
                     X_Last_Update_Login                   NUMBER DEFAULT NULL,
                     X_Resource_Seq_Num                    NUMBER,
                     X_Usage_Rate_Or_Amount                NUMBER,
                     X_Usage_Rate_Or_Amount_Inverse        NUMBER,
                     X_Basis_Type                          NUMBER,
                     X_Autocharge_Type                     NUMBER,
                     X_Standard_Rate_Flag                  NUMBER,
                     X_Assigned_Units                      NUMBER DEFAULT NULL,
                     X_Schedule_Flag                       NUMBER,
                     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,
                     X_SCHEDULE_SEQ_NUM                    NUMBER DEFAULT NULL, -- Bug#14550670
                     X_PRINCIPLE_FLAG                      NUMBER DEFAULT NULL  -- Bug#14550670
) IS
BEGIN
  UPDATE BOM_STD_OP_RESOURCES
  SET
    standard_operation_id                     =    X_Standard_Operation_Id,
    resource_id                               =    X_Resource_Id,
    substitute_group_num                      =    X_Substitute_Group_Num,
    activity_id                               =    X_Activity_Id,
    last_update_date                          =    X_Last_Update_Date,
    last_updated_by                           =    X_Last_Updated_By,
    last_update_login                         =    X_Last_Update_Login,
    resource_seq_num                          =    X_Resource_Seq_Num,
    usage_rate_or_amount                      =    X_Usage_Rate_Or_Amount,
    usage_rate_or_amount_inverse              =    X_Usage_Rate_Or_Amount_Inverse,
    basis_type                                =    X_Basis_Type,
    autocharge_type                           =    X_Autocharge_Type,
    standard_rate_flag                        =    X_Standard_Rate_Flag,
    assigned_units                            =    X_Assigned_Units,
    schedule_flag                             =    X_Schedule_Flag,
    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,
    schedule_seq_num                          =    X_Schedule_Seq_Num, -- Bug#14550670
    principle_flag                            =    X_Principle_Flag   -- Bug#14550670
  WHERE rowid = X_rowid;

Line: 570


END Update_Row;

Line: 572


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

Line: 580


END Delete_Row;

Line: 587


  SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
    (SELECT 1 FROM BOM_STD_OP_RESOURCES
     WHERE Standard_Operation_Id = X_Standard_Operation_Id
       AND Resource_Seq_Num = X_Resource_Seq_Num
       AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
    );