APPS.IGR_I_PKG_ITEM_CRM_PKG SQL Statements

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

Line: 6

 PROCEDURE insert_row (
   x_rowid IN OUT NOCOPY VARCHAR2,
   x_return_status OUT NOCOPY VARCHAR2,
   x_msg_count OUT NOCOPY NUMBER,
   x_msg_data OUT NOCOPY VARCHAR2,
   x_package_item_id IN OUT NOCOPY NUMBER,
   x_package_item IN VARCHAR2,
   x_description IN VARCHAR2,
   x_publish_ss_ind IN VARCHAR2,
   x_kit_flag IN VARCHAR2,
   x_object_version_number IN NUMBER,
   x_actual_avail_from_date IN DATE,
   x_actual_avail_to_date IN DATE,
   x_mode IN VARCHAR2
   )AS
  /*
  || Created By : [email protected]
  || Created On : 22-JAN-2003
  || Purpose : Handles the INSERT DML logic for the table.
  || Known limitations, enhancements or remarks :
  || Change History :
  || Who When What
  || (reverse chronological order - newest change first)
  */
   l_deliv_rec ams_deliverable_pvt.deliv_rec_type;

Line: 33

   x_last_update_date DATE;

Line: 34

   x_last_updated_by NUMBER;

Line: 35

   x_last_update_login NUMBER;

Line: 37

   CURSOR c IS SELECT 'X' FROM AMS_P_DELIVERABLES_V WHERE DELIVERABLE_NAME = x_package_item;

Line: 41

   x_last_update_date := SYSDATE;

Line: 43

     x_last_updated_by := 1;

Line: 44

     x_last_update_login := 0;

Line: 46

     x_last_updated_by := fnd_global.user_id;

Line: 47

     IF(x_last_updated_by IS NULL) THEN
        x_last_updated_by := -1;

Line: 50

     x_last_update_login := fnd_global.login_id;

Line: 51

     IF (x_last_update_login IS NULL) THEN
       x_last_update_login := -1;

Line: 99

   l_deliv_rec.last_update_date := sysdate;

Line: 100

   l_deliv_rec.last_updated_by := fnd_profile.value('user_id');

Line: 103

   l_deliv_rec.last_update_login := fnd_profile.value('user_id');

Line: 127

     IGR_I_PKG_ITEM_Pkg.Insert_Row(
       X_RowId => x_rowid,
       X_Package_Item_Id => x_package_item_id,
       X_Publish_Ss_Ind => x_publish_ss_ind
     );

Line: 133

 END insert_row;

Line: 155

   CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B
   WHERE DELIVERABLE_ID = x_package_item_id;

Line: 189

 PROCEDURE update_row (
   x_rowid IN VARCHAR2,
   x_return_status OUT NOCOPY VARCHAR2,
   x_msg_count OUT NOCOPY NUMBER,
   x_msg_data OUT NOCOPY VARCHAR2,
   x_package_item_id IN OUT NOCOPY NUMBER,
   x_package_item IN VARCHAR2,
   x_description IN VARCHAR2,
   x_publish_ss_ind IN VARCHAR2,
   x_kit_flag IN VARCHAR2,
   x_actual_avail_from_date IN DATE,
   x_actual_avail_to_date IN DATE,
   x_mode IN VARCHAR2
   )AS
  /*
  || Created By : [email protected]
  || Created On : 22-JAN-2003
  || Purpose : Handles the UPDATE DML logic for the table.
  || Known limitations, enhancements or remarks :
  || Change History :
  || Who When What
  || (reverse chronological order - newest change first)
  */
   l_deliv_rec ams_deliverable_pvt.deliv_rec_type;

Line: 216

   x_last_updated_by NUMBER;

Line: 217

   x_last_update_login NUMBER;

Line: 219

   CURSOR c_get_obj_num IS SELECT object_version_number from AMS_DELIVERABLES_ALL_B
   WHERE DELIVERABLE_ID = x_package_item_id;

Line: 225

     x_last_updated_by := 1;

Line: 226

     x_last_update_login := 0;

Line: 228

     x_last_updated_by := fnd_global.user_id;

Line: 229

     IF x_last_updated_by IS NULL THEN
       x_last_updated_by := -1;

Line: 232

     x_last_update_login := fnd_global.login_id;

Line: 233

     IF (x_last_update_login IS NULL) THEN
       x_last_update_login := -1;

Line: 253

   AMS_DELIVERABLE_PUB.update_DELIVERABLE(
     P_API_VERSION_NUMBER => 1.0,
     P_INIT_MSG_LIST => FND_API.G_TRUE,
     P_COMMIT => FND_API.G_FALSE,
     P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
     x_return_status => x_return_status,
     x_msg_count => x_msg_count,
     x_msg_data => x_msg_data,
     p_deliv_rec => l_deliv_rec
   );

Line: 272

     igr_i_pkg_item_pkg.update_row(
       X_RowId => x_rowid,
       X_Package_Item_Id => x_package_item_id,
       X_Publish_Ss_Ind => x_publish_ss_ind
     );

Line: 278

 END update_row;