APPS.JTF_DELIVERABLE_GRP SQL Statements

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

Line: 187

			|| 'AND item_id NOT IN (SELECT item_id FROM jtf_dsp_tpl_ctg '
			|| 'WHERE category_id = :ctg_id) ';

Line: 198

	sql_stmt := 'SELECT COUNT(*) ' || sql_cond;

Line: 300

		|| 'SELECT item_id, access_name, item_name, deliverable_type_code, '

		--modified by G. Zhang 05/17/01 5:42PM
		|| 'applicable_to_code, description, keyword, file_name, file_id, '

		|| 'object_version_number '
		|| 'BULK COLLECT INTO :id_tbl, :acc_tbl, :dsp_tbl, :type_tbl, '

		--modified by G. Zhang 05/17/01 5:42PM
		|| ':appl_tbl, :desc_tbl, :key_tbl, :file_tbl, :file_id_tbl, :version_tbl '

		|| 'FROM (SELECT * '
		|| sql_cond
		|| 'ORDER BY item_name ) '
		|| 'WHERE ROWNUM <= :row_num '
		|| '; END;';

Line: 679

	l_operation_type VARCHAR2(10) := 'INSERT';

Line: 729

			l_item_rec.last_update_date := NULL;

Line: 730

			l_item_rec.last_updated_by := NULL;

Line: 731

          	l_item_rec.last_update_login := NULL;

Line: 760

				-- Update an existing deliverable
				l_operation_type := 'UPDATE';

Line: 764

			IF (l_operation_type = 'INSERT') THEN
				l_item_rec.deliverable_type_code
					:= TRIM(p_deliverable_rec.item_type);

Line: 810

				JTF_AMV_ITEM_PUB.update_item(
					p_api_version       => g_amv_api_version,
					x_return_status     => l_return_status,
					x_msg_count         => x_msg_count,
					x_msg_data          => x_msg_data,
					p_item_rec          => l_item_rec
				);

Line: 824

				-- Delete existing keywords
				JTF_AMV_ITEM_PUB.delete_itemkeyword(
					p_api_version		=> g_amv_api_version,
					x_return_status	=> l_return_status,
					x_msg_count		=> x_msg_count,
					x_msg_data		=> x_msg_data,
					p_item_id	=> p_deliverable_rec.deliverable_id,
					p_keyword_tab		=> NULL
				);

Line: 857

				-- update the object_version_number
				p_deliverable_rec.object_version_number :=
					p_deliverable_rec.object_version_number + 1;

Line: 1096

	l_operation_type VARCHAR2(10) := 'INSERT';

Line: 1098

	l_delete_mapping VARCHAR2(1) := FND_API.g_false;

Line: 1135

		-- Update an existing deliverable
		l_operation_type := 'UPDATE';

Line: 1167

	-- Update/Create default attachment for all-site and all-language

  BEGIN

	SAVEPOINT save_one_attachment_grp;

Line: 1173

	IF l_operation_type = 'INSERT' THEN

		-- Create an attachment for all-site and all-language if any
		IF TRIM(p_dlv_ath_rec.ath_file_name) IS NOT NULL THEN
			l_create_attachment := FND_API.g_true;

Line: 1184

		-- Update the default attachment for the existing deliverable

		IF TRIM(p_dlv_ath_rec.ath_file_name) IS NULL THEN
			l_delete_mapping := FND_API.g_true;

Line: 1192

			-- If so, validate it! Update all-site and all-lang mappings
			-- if it's the new default
			-- If not, delete all-site and all-lang mappings if any
			-- and create the new attachment with all-site and all-lang
			-- mappings

			--modified by G. Zhang 05/23/01 10:57AM
			l_attachment_id := JTF_DSPMGRVALIDATION_GRP.check_attachment_exists(
			  p_dlv_ath_rec.deliverable_id,p_dlv_ath_rec.ath_file_id,p_dlv_ath_rec.ath_file_name);

Line: 1214

					l_delete_mapping := FND_API.g_true;

Line: 1221

				l_delete_mapping := FND_API.g_true;

Line: 1257

	IF l_delete_mapping = FND_API.g_true THEN
		-- Delete all-site and all-lang mapping for this deliverable
		JTF_PhysicalMap_GRP.delete_dlv_all_all(
			p_deliverable_id         => p_dlv_ath_rec.deliverable_id
		);

Line: 1521

PROCEDURE delete_deliverable (
     p_api_version            IN   NUMBER,
	p_init_msg_list          IN   VARCHAR2 := FND_API.g_false,
	p_commit                 IN   VARCHAR2  := FND_API.g_false,
	x_return_status          OUT  VARCHAR2,
	x_msg_count              OUT  NUMBER,
	x_msg_data               OUT  VARCHAR2,
	p_dlv_id_ver_tbl		IN OUT DLV_ID_VER_TBL_TYPE ) IS

	l_api_name CONSTANT VARCHAR2(30) := 'delete_deliverable';

Line: 1540

	SAVEPOINT delete_deliverable_grp;

Line: 1568

			SAVEPOINT delete_one_deliverable_grp;

Line: 1576

			-- Delete from the section tables
			JTF_DSP_SECTION_GRP.update_deliverable_to_null(
				p_api_version			=> p_api_version,
				p_deliverable_id =>	p_dlv_id_ver_tbl(l_index).deliverable_id,
				x_return_status		=> l_return_status,
				x_msg_count			=> x_msg_count,
				x_msg_data			=> x_msg_data
			);

Line: 1591

			-- Delete all the associated display contexts
			JTF_DisplayContext_GRP.delete_deliverable(
				p_dlv_id_ver_tbl(l_index).deliverable_id
			);

Line: 1596

			-- Delete all the associated template categories
			JTF_TplCategory_GRP.delete_deliverable(
				p_dlv_id_ver_tbl(l_index).deliverable_id
			);

Line: 1601

			-- Delete all the associated logical contents
			JTF_LogicalContent_GRP.delete_deliverable(
				p_dlv_id_ver_tbl(l_index).deliverable_id
			);

Line: 1606

			-- Delete all the associated physical_site_language mappings
			JTF_PhysicalMap_GRP.delete_deliverable(
				p_dlv_id_ver_tbl(l_index).deliverable_id
			);

Line: 1611

			-- Delete the item
			JTF_AMV_ITEM_PUB.delete_item(
				p_api_version		=> g_amv_api_version,
				x_return_status	=> l_return_status,
				x_msg_count		=> x_msg_count,
				x_msg_data		=> x_msg_data,
				p_item_id			=> p_dlv_id_ver_tbl(l_index).deliverable_id
			);

Line: 1632

				ROLLBACK TO delete_one_deliverable_grp;

Line: 1640

				ROLLBACK TO delete_one_deliverable_grp;

Line: 1646

				ROLLBACK TO delete_one_deliverable_grp;

Line: 1676

		ROLLBACK TO delete_deliverable_grp;

Line: 1685

		ROLLBACK TO delete_deliverable_grp;

Line: 1694

		ROLLBACK TO delete_deliverable_grp;

Line: 1707

END delete_deliverable;