APPS.AMS_WEBMARKETING_PVT SQL Statements

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

Line: 148

	    SELECT  AMS_WEB_PLCE_CITEM_ASSOC_S.NEXTVAL
	      FROM dual;

Line: 152

	      SELECT 1
	      FROM AMS_WEB_PLCE_CITEM_ASSOC
	      WHERE PLACEMENT_CITEM_ID = l_id;

Line: 158

		SELECT  civ.CONTENT_ITEM_ID c_item_id ,civ.CITEM_VERSION_ID c_version_id
		FROM  IBC_COMPOUND_RELATIONS cr, IBC_ATTRIBUTE_TYPES_VL attr, IBC_CONTENT_TYPES_VL ct,IBC_CITEM_VERSIONS_VL civ,
		IBC_CONTENT_ITEMS ci WHERE
		cr.ATTRIBUTE_TYPE_CODE = attr.ATTRIBUTE_TYPE_CODE AND
		cr.CONTENT_TYPE_CODE = attr.CONTENT_TYPE_CODE AND
		ct.CONTENT_TYPE_CODE = ci.CONTENT_TYPE_CODE AND
		ci.CONTENT_ITEM_ID = civ.CONTENT_ITEM_ID AND
		cr.CONTENT_ITEM_ID = civ.CONTENT_ITEM_ID AND
		ci.LIVE_CITEM_VERSION_ID = civ.CITEM_VERSION_ID AND
		civ.CITEM_VERSION_STATUS = 'APPROVED' AND
		cr.CITEM_VERSION_ID = l_citem_version_id;

Line: 171

		SELECT LIVE_CITEM_VERSION_ID
		   FROM IBC_CONTENT_ITEMS  WHERE CONTENT_ITEM_ID = l_content_item_id;

Line: 221

		       -- Invoke table handler(AMS_WEB_PLCE_CITEM_ASSOC_PKG.INSERT_ROW)

			    l_simple := 'N';

Line: 244

			AMS_WEB_CITEM_ASSOC_PKG.Insert_Row(
			  px_placement_citem_id   => l_placement_citem_id,
			  p_placement_mp_id  =>   p_placement_mp_id,
			  p_content_item_id   =>  citem_rec.c_item_id,
			  p_citem_version_id   => citem_rec.c_version_id,
			  p_created_by  =>   FND_GLOBAL.USER_ID,
			  p_creation_date  =>   SYSDATE,
			  p_last_updated_by =>  FND_GLOBAL.USER_ID,
			  p_last_update_date  =>  SYSDATE,
			  p_last_update_login   => FND_GLOBAL.CONC_LOGIN_ID,
			  px_object_version_number  => l_object_version_number,
			  p_return_status        => x_return_status,
			  p_msg_count           => x_msg_data,
			  p_msg_data         =>   x_msg_data);

Line: 291

			AMS_WEB_CITEM_ASSOC_PKG.Insert_Row(
			  px_placement_citem_id   => l_placement_citem_id,
			  p_placement_mp_id  =>   p_placement_mp_id,
			  p_content_item_id   =>  p_content_item_id,
			  p_citem_version_id   => l_citem_ver_id,
			  p_created_by  =>   FND_GLOBAL.USER_ID,
			  p_creation_date  =>   SYSDATE,
			  p_last_updated_by =>  FND_GLOBAL.USER_ID,
			  p_last_update_date  =>  SYSDATE,
			  p_last_update_login   => FND_GLOBAL.CONC_LOGIN_ID,
			  px_object_version_number  => l_object_version_number,
			  p_return_status        => x_return_status,
			  p_msg_count           => x_msg_data,
			  p_msg_data         =>   x_msg_data);

Line: 442

	      SELECT 1
	      FROM AMS_WEB_PLACEMENTS_B
	      WHERE PLACEMENT_ID = l_id;

Line: 448

		SELECT site_id
		FROM ams_iba_pl_sites_b
		WHERE site_ref_code = l_site_ref_code;

Line: 453

		SELECT site_id
		FROM ams_iba_pl_sites_b
		WHERE site_id = l_site_id;

Line: 459

	      SELECT 1
	      FROM AMS_WEB_PLCE_CTYPE_ASSOC
	      WHERE PLACEMENT_ID = l_id;

Line: 464

	      SELECT 1
	      FROM AMS_CAMPAIGNS_ALL_B
	      WHERE CAMPAIGN_ID = l_id;

Line: 469

	      SELECT 1
	      FROM AMS_CAMPAIGN_SCHEDULES_B
	      WHERE SCHEDULE_ID = l_id;

Line: 616

 SELECT  CITEM_VER_ID
   FROM  IBC_CITEMS_V
  WHERE CITEM_ID = p_content_item_id;

Line: 643

 select auto_publish_flag from ams_web_placements_b where placement_id = p_placement_id;

Line: 692

	    SELECT  AMS_WEB_PLCE_MP_B_S.NEXTVAL
	      FROM dual;

Line: 696

	    SELECT  AMS_WEB_PLCE_CITEM_ASSOC_S.NEXTVAL
	      FROM dual;

Line: 700

	      SELECT 1
	      FROM AMS_WEB_PLCE_MP_B
	      WHERE PLACEMENT_MP_ID = l_id;

Line: 705

	      SELECT 1
	      FROM AMS_WEB_PLCE_CITEM_ASSOC
	      WHERE PLACEMENT_CITEM_ID = l_id;

Line: 710

	      SELECT 1
	      FROM AMS_MEDIA_B
	      WHERE MEDIA_ID = l_id;

Line: 819

		 AMS_WEB_PLCE_MP_PKG.INSERT_ROW(
			  x_rowid  => l_rowid,
			  x_placement_mp_id  => l_placement_mp_id,
			  x_placement_id => p_web_mp_rec.placement_id,
			  x_content_item_id => p_web_mp_rec.content_item_id,
			  x_citem_version_id => l_citem_version_id,
			  x_display_priority => p_web_mp_rec.display_priority,
			  x_publish_flag => l_publish_flag,
			  x_max_recommendations => p_web_mp_rec.max_recommendations,
			  x_object_used_by_id => p_web_mp_rec.object_used_by_id,
			  x_object_used_by =>  p_web_mp_rec.object_used_by,
			  x_security_group_id => null,
			  x_object_version_number => l_object_version_number,
			  x_attribute_category => null,
			  x_attribute1 => null,
			  x_attribute2 => null,
			  x_attribute3 => null,
			  x_attribute4 => null,
			  x_attribute5 => null,
			  x_attribute6 => null,
			  x_attribute7 => null,
			  x_attribute8 => null,
			  x_attribute9 => null,
			  x_attribute10 => null,
			  x_attribute11 => null,
			  x_attribute12 => null,
			  x_attribute13 => null,
			  x_attribute14 => null,
			  x_attribute15 => null,
			  x_content_type_code => l_content_type_code ,
			  x_placement_mp_title => p_web_mp_rec.placement_mp_title,
			  x_creation_date => sysdate ,
			  x_created_by =>  fnd_global.user_id,
			  x_last_update_date => sysdate,
			  x_last_updated_by => fnd_global.user_id,
			  x_last_update_login => fnd_global.conc_login_id );

Line: 995

		SELECT content_type_code
		FROM ams_web_plce_mp_b
		WHERE placement_mp_id = l_placement_mp_id;

Line: 1000

	      SELECT 1
	      FROM AMS_WEB_PLCE_MP_B
	      WHERE PLACEMENT_MP_ID = l_placement_mp_id;

Line: 1007

	 	 SELECT CONTENT_TYPE_CODE from
		    IBC_CONTENT_ITEMS WHERE CONTENT_ITEM_ID = l_content_item_id AND CONTENT_ITEM_STATUS = 'APPROVED';

Line: 1124

 	       SELECT sched.schedule_id
	       FROM  AMS_CAMPAIGN_SCHEDULES_B SCHED, AMS_WEB_PLCE_MP_B MP
	       WHERE SCHED.SCHEDULE_ID = MP.OBJECT_USED_BY_ID AND SCHED.SCHEDULE_ID =  L_CAMPAIGN_ACTIVITY_ID;

Line: 1129

  	       SELECT activity_id FROM ams_campaign_schedules_b where SCHEDULE_ID=l_schedule_id;

Line: 1132

	       SELECT Assn.content_item_id , Citem.live_citem_version_id
		FROM   IBC_ASSOCIATIONS  Assn, IBC_CONTENT_ITEMS Citem
		WHERE  Assn.ASSOCIATED_OBJECT_VAL1 = TO_CHAR(l_campaign_activity_id)
	        AND  Assn.CONTENT_ITEM_ID    = Citem.CONTENT_ITEM_ID
	       AND Citem.CONTENT_ITEM_STATUS <> 'APPROVED'
	       AND Assn.ASSOCIATION_TYPE_CODE  in ('AMS_PLCE') ;