APPS.IGR_INFTYP_PKG_IT_CRM_PKG SQL Statements

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

Line: 3

  PROCEDURE insert_row(
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count OUT NOCOPY NUMBER,
    x_msg_data OUT NOCOPY VARCHAR2,
    x_deliverable_kit_item_id IN OUT NOCOPY NUMBER,
    x_deliverable_kit_id IN NUMBER,
    x_deliverable_kit_part_id IN NUMBER
  ) AS
  CURSOR c IS SELECT 'X' FROM AMS_P_DELIV_KIT_ITEMS_V WHERE
    deliverable_kit_part_id = x_deliverable_kit_part_id AND
    deliverable_kit_id = x_deliverable_kit_id ;

Line: 42

  END insert_row;

Line: 44

  PROCEDURE delete_row(
    x_return_status OUT NOCOPY VARCHAR2,
    x_msg_count OUT NOCOPY NUMBER,
    x_msg_data OUT NOCOPY VARCHAR2,
    x_deliverable_kit_item_id IN NUMBER
  ) AS
   CURSOR c IS SELECT object_version_number,deliverable_kit_id from AMS_DELIV_KIT_ITEMS
    WHERE deliverable_kit_item_id = x_deliverable_kit_item_id;

Line: 60

    SELECT 1
    FROM   igr_i_ityp_pkgs_v
    WHERE  info_type_id = l_info_type_id;

Line: 65

    SELECT a.*
    FROM   ams_p_deliverables_v a
    WHERE  a.deliverable_id = l_info_type_id;

Line: 70

    SELECT rowid
    FROM   igr_i_pkg_item
    WHERE  package_item_id = l_info_type_id;

Line: 81

    AMS_DelivKitItem_PUB.Delete_DelivKitItem(
      p_api_version_number      => 1.0,
      x_return_status           => x_return_status,
      x_msg_count               => x_msg_count,
      x_msg_data                => x_msg_data,
      p_deliv_kit_item_id       => x_deliverable_kit_item_id,
      p_object_version_number   => l_object_version_number
    );

Line: 98

       Deliverabl Kit Items (Pkg Item )associated with the Information type are Deleted
       Then The CRM API will Automatically set the Kit Flag to 'N' which should be
       reset to 'Y' which is a valid one for Information Type
       This change was made as part of the Bug 2819945  */

       OPEN c_package_items( l_info_type_id);

Line: 115

	   IGR_I_PKG_ITEM_CRM_PKG.update_row (
	     x_rowid                  => l_row_id,
	     x_return_status	      => x_return_status,
	     x_msg_count	      => x_msg_count,
	     x_msg_data		      => x_msg_data,
	     x_package_item_id        => rec_info_details.deliverable_id,
	     x_package_item           => rec_info_details.deliverable_name,
	     x_description            => rec_info_details.description,
	     x_publish_ss_ind         => 'N',
	     x_kit_flag               => 'Y',
	     x_actual_avail_from_date => IGS_GE_DATE.IGSDATE(rec_info_details.actual_avail_from_date),
	     x_actual_avail_to_date   => IGS_GE_DATE.IGSDATE(rec_info_details.actual_avail_to_date)
	    );

Line: 133

  END delete_row;