APPS.CHV_SCHEDULE_ITEMS_PKG_S1 SQL Statements

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

Line: 44

        SELECT *
        FROM   CHV_SCHEDULE_ITEMS
        WHERE  rowid = X_Rowid
        FOR UPDATE of Schedule_Id NOWAIT;

Line: 55

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

Line: 164

   PROCEDURE NAME:  update_row()

=============================================================================*/
  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Item_Confirm_Status            VARCHAR2,
                       X_Rebuild_Flag                   VARCHAR2,
                       X_Last_Update_Date               DATE,
                       X_Last_Updated_By                NUMBER,
                       X_Last_Update_Login              NUMBER,
 		       X_Attribute_Category             VARCHAR2,
                       X_Attribute1                     VARCHAR2,
                       X_Attribute2                     VARCHAR2,
                       X_Attribute3                     VARCHAR2,
                       X_Attribute4                     VARCHAR2,
                       X_Attribute5                     VARCHAR2,
                       X_Attribute6                     VARCHAR2,
                       X_Attribute7                     VARCHAR2,
                       X_Attribute8                     VARCHAR2,
                       X_Attribute9                     VARCHAR2,
                       X_Attribute10                    VARCHAR2,
                       X_Attribute11                    VARCHAR2,
                       X_Attribute12                    VARCHAR2,
                       X_Attribute13                    VARCHAR2,
                       X_Attribute14                    VARCHAR2,
                       X_Attribute15                    VARCHAR2
                      ) IS

 BEGIN

   UPDATE CHV_SCHEDULE_ITEMS
   SET
     item_confirm_status               =     X_Item_Confirm_Status,
     rebuild_flag                      =     X_Rebuild_Flag,
     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: 222

  END Update_Row;

Line: 226

   PROCEDURE NAME:  delete_row1()

=============================================================================*/
PROCEDURE delete_row1(X_RowId                   VARCHAR2,
                      X_Schedule_Item_Id        NUMBER,
                      X_Schedule_Id             NUMBER
                     ) IS

BEGIN


  CHV_ITEM_ORDERS_PKG_S1.delete_row(X_Schedule_Id,
				    X_Schedule_Item_Id) ;

Line: 240

  CHV_HORIZ_SCHEDULES_PKG_S1.delete_row(X_Schedule_Id,
	                 	        X_Schedule_Item_Id) ;

Line: 243

  CHV_AUTHORIZATIONS_PKG_S1.delete_row(X_Schedule_Item_Id) ;

Line: 245

  /* After the data is deleted from the child tables
  ** delete from the items table.
  */

  DELETE FROM chv_schedule_items
   WHERE rowid            =  X_Rowid ;

Line: 256

END delete_row1 ;

Line: 260

   PROCEDURE NAME:  delete_row2()

=============================================================================*/
PROCEDURE delete_row2(X_Schedule_Id       NUMBER
                     ) IS

Cursor C1 is SELECT rowid, schedule_item_id
              FROM  CHV_SCHEDULE_ITEMS
              WHERE schedule_id = X_Schedule_Id ;

Line: 274

   /*  Execute procedure to actually delete the records */

   CHV_SCHEDULE_ITEMS_PKG_S1.delete_row1(Itemrec.rowid,
				         Itemrec.Schedule_Item_Id,
                                         X_Schedule_Id
					) ;

Line: 282

END delete_row2 ;