APPS.JTF_PHYSICALMAP_GRP SQL Statements

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

Line: 59

		SELECT JTF_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;

Line: 100

		-- Delete all the existing mappings
		DELETE FROM JTF_DSP_LGL_PHYS_MAP
			WHERE ( (attachment_id = p_attachment_id)
			AND (default_site = l_default_msite)
			AND (msite_id = p_msite_id) );

Line: 114

		-- Delete all the existing mappings
		DELETE FROM JTF_DSP_LGL_PHYS_MAP
			WHERE ( (attachment_id = p_attachment_id)
			AND (default_site = g_yes) );

Line: 133

			INSERT INTO JTF_DSP_LGL_PHYS_MAP (
				lgl_phys_map_id,
				object_version_number,
				last_update_date,
				last_updated_by,
				creation_date,
				created_by,
				last_update_login,
				msite_id,
				language_code,
				attachment_id,
				item_id,
				default_site,
				default_language
			) VALUES (
				l_lgl_phys_map_id,
				1,
				SYSDATE,
				FND_GLOBAL.user_id,
				SYSDATE,
				FND_GLOBAL.user_id,
				FND_GLOBAL.login_id,
				l_msite_id,
				l_language_code,
				p_attachment_id,
				l_deliverable_id,
				l_default_msite,
				l_default_lang);

Line: 181

				INSERT INTO JTF_DSP_LGL_PHYS_MAP (
		    			lgl_phys_map_id,
					object_version_number,
		    			last_update_date,
		    			last_updated_by,
		    			creation_date,
		    			created_by,
		    			last_update_login,
		    			msite_id,
		    			language_code,
		    			attachment_id,
					item_id,
					default_site,
					default_language
	    			) VALUES (
		    			l_lgl_phys_map_id,
					1,
		    			SYSDATE,
		    			FND_GLOBAL.user_id,
		    			SYSDATE,
		    			FND_GLOBAL.user_id,
		    			FND_GLOBAL.login_id,
		    			l_msite_id,
					p_language_code_tbl(l_index),
					p_attachment_id,
					l_deliverable_id,
					l_default_msite,
					l_default_lang
	    			);

Line: 460

			l_language_code_tbl.DELETE(1, l_count);

Line: 463

				l_language_code_tbl.DELETE(
					p_msite_lang_tbl(l_index1).lang_count + 1,
					l_language_code_tbl.COUNT);

Line: 588

PROCEDURE delete_physicalmap(
	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_lgl_phys_map_id_tbl    IN   LGL_PHYS_MAP_ID_TBL_TYPE) IS

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

Line: 605

	SAVEPOINT delete_physicalmap_grp;

Line: 637

			DELETE FROM JTF_DSP_LGL_PHYS_MAP
				WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);

Line: 701

    		ROLLBACK TO delete_physicalmap_grp;

Line: 710

     	ROLLBACK TO delete_physicalmap_grp;

Line: 719

      	ROLLBACK TO delete_physicalmap_grp;

Line: 732

END delete_physicalmap;

Line: 748

PROCEDURE delete_attachment(
	p_attachment_id          IN   NUMBER) IS

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

Line: 757

   	SAVEPOINT delete_attachment_grp;

Line: 761

	DELETE FROM JTF_DSP_LGL_PHYS_MAP
		WHERE attachment_id = p_attachment_id;

Line: 767

      	ROLLBACK TO delete_attachment_grp;

Line: 773

END delete_attachment;

Line: 789

PROCEDURE delete_deliverable(
	p_deliverable_id         IN   NUMBER) IS

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

Line: 798

	SAVEPOINT delete_deliverable_grp;

Line: 802

	DELETE FROM JTF_DSP_LGL_PHYS_MAP
		WHERE item_id = p_deliverable_id;

Line: 808

		ROLLBACK TO delete_deliverable_grp;

Line: 814

END delete_deliverable;

Line: 830

PROCEDURE delete_msite(
	p_msite_id			IN	NUMBER) IS

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

Line: 839

	SAVEPOINT delete_msite_grp;

Line: 843

	DELETE FROM JTF_DSP_LGL_PHYS_MAP
		WHERE ( (msite_id = p_msite_id) AND (default_site = g_no) );

Line: 849

		ROLLBACK TO delete_msite_grp;

Line: 855

END delete_msite;

Line: 873

PROCEDURE delete_msite_language(
	p_msite_id               IN   NUMBER) IS

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

Line: 882

	SAVEPOINT delete_msite_language_grp;

Line: 886

	DELETE FROM JTF_DSP_LGL_PHYS_MAP
		WHERE msite_id = p_msite_id
		AND default_site = g_no
		AND default_language = g_no
		AND language_code NOT IN (SELECT language_code
		FROM JTF_MSITE_LANGUAGES WHERE msite_id = p_msite_id);

Line: 896

		ROLLBACK TO delete_msite_language_grp;

Line: 902

END delete_msite_language;

Line: 919

PROCEDURE delete_attachment_msite(
	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_attachment_id          IN   NUMBER,
	p_msite_id_tbl           IN   MSITE_ID_TBL_TYPE) IS

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

Line: 935

	SAVEPOINT delete_attachment_msite_grp;

Line: 961

			SAVEPOINT delete_one_ath_msite_grp;

Line: 965

				DELETE FROM JTF_DSP_LGL_PHYS_MAP
					WHERE ( (attachment_id = p_attachment_id)
					AND (default_site = g_yes) );

Line: 969

				DELETE FROM JTF_DSP_LGL_PHYS_MAP
					WHERE ( (attachment_id = p_attachment_id)
					AND (msite_id = p_msite_id_tbl(l_index))
					AND (default_site = g_no) );

Line: 978

				ROLLBACK TO delete_one_ath_msite_grp;

Line: 1005

		ROLLBACK TO delete_attachment_msite_grp;

Line: 1014

		ROLLBACK TO delete_attachment_msite_grp;

Line: 1023

		ROLLBACK TO delete_attachment_msite_grp;

Line: 1037

END delete_attachment_msite;

Line: 1052

PROCEDURE delete_dlv_all_all(
	p_deliverable_id         IN   NUMBER) IS

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

Line: 1061

	SAVEPOINT delete_dlv_all_all_grp;

Line: 1065

	DELETE FROM JTF_DSP_LGL_PHYS_MAP
		WHERE item_id = p_deliverable_id
		AND default_site = g_yes
		AND default_language = g_yes;

Line: 1073

		ROLLBACK TO delete_dlv_all_all_grp;

Line: 1079

END delete_dlv_all_all;