APPS.JTF_PHYSICALMAP_GRP dependencies on JTF_DSP_LGL_PHYS_MAP

Line 59: SELECT JTF_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;

55:
56: l_index NUMBER;
57:
58: CURSOR lgl_phys_map_id_seq IS
59: SELECT JTF_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;
60:
61: BEGIN
62:
63: -- Standard start of API savepoint

Line 101: DELETE FROM JTF_DSP_LGL_PHYS_MAP

97: RAISE FND_API.g_exc_error;
98: END IF;
99:
100: -- Delete all the existing mappings
101: DELETE FROM JTF_DSP_LGL_PHYS_MAP
102: WHERE ( (attachment_id = p_attachment_id)
103: AND (default_site = l_default_msite)
104: AND (msite_id = p_msite_id) );
105: ELSE

Line 115: DELETE FROM JTF_DSP_LGL_PHYS_MAP

111: RAISE FND_API.g_exc_error;
112: END IF;
113:
114: -- Delete all the existing mappings
115: DELETE FROM JTF_DSP_LGL_PHYS_MAP
116: WHERE ( (attachment_id = p_attachment_id)
117: AND (default_site = g_yes) );
118: END IF;
119:

Line 133: INSERT INTO JTF_DSP_LGL_PHYS_MAP (

129: OPEN lgl_phys_map_id_seq;
130: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
131: CLOSE lgl_phys_map_id_seq;
132:
133: INSERT INTO JTF_DSP_LGL_PHYS_MAP (
134: lgl_phys_map_id,
135: object_version_number,
136: last_update_date,
137: last_updated_by,

Line 181: INSERT INTO JTF_DSP_LGL_PHYS_MAP (

177: OPEN lgl_phys_map_id_seq;
178: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
179: CLOSE lgl_phys_map_id_seq;
180:
181: INSERT INTO JTF_DSP_LGL_PHYS_MAP (
182: lgl_phys_map_id,
183: object_version_number,
184: last_update_date,
185: last_updated_by,

Line 637: DELETE FROM JTF_DSP_LGL_PHYS_MAP

633: p_lgl_phys_map_id_tbl(l_index)) THEN
634: RAISE FND_API.g_exc_error;
635: END IF;
636:
637: DELETE FROM JTF_DSP_LGL_PHYS_MAP
638: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);
639: IF SQL%NOTFOUND THEN
640: -- RAISE JTF_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 761: DELETE FROM JTF_DSP_LGL_PHYS_MAP

757: SAVEPOINT delete_attachment_grp;
758:
759: -- API body
760:
761: DELETE FROM JTF_DSP_LGL_PHYS_MAP
762: WHERE attachment_id = p_attachment_id;
763:
764: EXCEPTION
765:

Line 802: DELETE FROM JTF_DSP_LGL_PHYS_MAP

798: SAVEPOINT delete_deliverable_grp;
799:
800: -- API body
801:
802: DELETE FROM JTF_DSP_LGL_PHYS_MAP
803: WHERE item_id = p_deliverable_id;
804:
805: EXCEPTION
806:

Line 843: DELETE FROM JTF_DSP_LGL_PHYS_MAP

839: SAVEPOINT delete_msite_grp;
840:
841: -- API body
842:
843: DELETE FROM JTF_DSP_LGL_PHYS_MAP
844: WHERE ( (msite_id = p_msite_id) AND (default_site = g_no) );
845:
846: EXCEPTION
847:

Line 886: DELETE FROM JTF_DSP_LGL_PHYS_MAP

882: SAVEPOINT delete_msite_language_grp;
883:
884: -- API body
885:
886: DELETE FROM JTF_DSP_LGL_PHYS_MAP
887: WHERE msite_id = p_msite_id
888: AND default_site = g_no
889: AND default_language = g_no
890: AND language_code NOT IN (SELECT language_code

Line 965: DELETE FROM JTF_DSP_LGL_PHYS_MAP

961: SAVEPOINT delete_one_ath_msite_grp;
962:
963: -- Check if it is all-sites
964: IF p_msite_id_tbl(l_index) IS NULL THEN
965: DELETE FROM JTF_DSP_LGL_PHYS_MAP
966: WHERE ( (attachment_id = p_attachment_id)
967: AND (default_site = g_yes) );
968: ELSE
969: DELETE FROM JTF_DSP_LGL_PHYS_MAP

Line 969: DELETE FROM JTF_DSP_LGL_PHYS_MAP

965: DELETE FROM JTF_DSP_LGL_PHYS_MAP
966: WHERE ( (attachment_id = p_attachment_id)
967: AND (default_site = g_yes) );
968: ELSE
969: DELETE FROM JTF_DSP_LGL_PHYS_MAP
970: WHERE ( (attachment_id = p_attachment_id)
971: AND (msite_id = p_msite_id_tbl(l_index))
972: AND (default_site = g_no) );
973: END IF;

Line 1065: DELETE FROM JTF_DSP_LGL_PHYS_MAP

1061: SAVEPOINT delete_dlv_all_all_grp;
1062:
1063: -- API body
1064:
1065: DELETE FROM JTF_DSP_LGL_PHYS_MAP
1066: WHERE item_id = p_deliverable_id
1067: AND default_site = g_yes
1068: AND default_language = g_yes;
1069: