eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_PHYSICALMAP_GRP dependencies on IBE_DSP_LGL_PHYS_MAP

Line 60: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;

56: l_index NUMBER;
57: l_seed_data_exists Boolean := false;
58:
59: CURSOR lgl_phys_map_id_seq IS
60: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;
61:
62: BEGIN
63:
64: -- Standard start of API savepoint

Line 105: DELETE FROM IBE_DSP_LGL_PHYS_MAP

101: RAISE FND_API.g_exc_error;
102: END IF;
103:
104: -- Delete all the existing mappings
105: DELETE FROM IBE_DSP_LGL_PHYS_MAP
106: WHERE ( (attachment_id = p_attachment_id)
107: AND (default_site = l_default_msite)
108: AND (msite_id = p_msite_id) );
109: ELSE

Line 125: FROM IBE_DSP_LGL_PHYS_MAP

121: IF l_language_code IS NULL THEN
122: l_seed_data_exists := true;
123: BEGIN
124: SELECT lgl_phys_map_id INTO l_lgl_phys_map_id
125: FROM IBE_DSP_LGL_PHYS_MAP
126: WHERE attachment_id = p_attachment_id
127: AND default_site = g_yes
128: AND default_language = g_yes
129: AND lgl_phys_map_id < 10000;

Line 140: DELETE FROM IBE_DSP_LGL_PHYS_MAP

136:
137:
138: -- Delete all the existing mappings
139: IF l_seed_data_exists = false THEN -- Added by YAXU, don't delete the seeded physicalMap
140: DELETE FROM IBE_DSP_LGL_PHYS_MAP
141: WHERE ( (attachment_id = p_attachment_id)
142: AND (default_site = g_yes)
143: AND (lgl_phys_map_id > 10000) );
144: END IF;

Line 161: INSERT INTO IBE_DSP_LGL_PHYS_MAP (

157: OPEN lgl_phys_map_id_seq;
158: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
159: CLOSE lgl_phys_map_id_seq;
160:
161: INSERT INTO IBE_DSP_LGL_PHYS_MAP (
162: lgl_phys_map_id,
163: object_version_number,
164: last_update_date,
165: last_updated_by,

Line 209: INSERT INTO IBE_DSP_LGL_PHYS_MAP (

205: OPEN lgl_phys_map_id_seq;
206: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
207: CLOSE lgl_phys_map_id_seq;
208:
209: INSERT INTO IBE_DSP_LGL_PHYS_MAP (
210: lgl_phys_map_id,
211: object_version_number,
212: last_update_date,
213: last_updated_by,

Line 677: DELETE FROM IBE_DSP_LGL_PHYS_MAP

673: p_lgl_phys_map_id_tbl(l_index)) THEN
674: RAISE FND_API.g_exc_error;
675: END IF;
676:
677: DELETE FROM IBE_DSP_LGL_PHYS_MAP
678: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);
679: IF SQL%NOTFOUND THEN
680: -- RAISE IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 801: DELETE FROM IBE_DSP_LGL_PHYS_MAP

797: SAVEPOINT delete_attachment_grp;
798:
799: -- API body
800:
801: DELETE FROM IBE_DSP_LGL_PHYS_MAP
802: WHERE attachment_id = p_attachment_id;
803:
804: EXCEPTION
805:

Line 846: from ibe_dsp_lgl_phys_map a, jtf_amv_attachments b

842:
843:
844: CURSOR attachment_ids IS
845: SELECT distinct b.attachment_id
846: from ibe_dsp_lgl_phys_map a, jtf_amv_attachments b
847: where a.item_id = p_deliverable_id
848: and a.attachment_id = b.attachment_id
849: and b.attachment_used_by_id = -1
850: and (b.file_id <=0 or b.file_id is null)

Line 884: DELETE FROM IBE_DSP_LGL_PHYS_MAP

880: end loop;
881: close attachment_ids;
882:
883: -- delete the mappings
884: DELETE FROM IBE_DSP_LGL_PHYS_MAP
885: WHERE item_id = p_deliverable_id;
886:
887: EXCEPTION
888:

Line 925: DELETE FROM IBE_DSP_LGL_PHYS_MAP

921: SAVEPOINT delete_msite_grp;
922:
923: -- API body
924:
925: DELETE FROM IBE_DSP_LGL_PHYS_MAP
926: WHERE ( (msite_id = p_msite_id) AND (default_site = g_no) );
927:
928: EXCEPTION
929:

Line 968: DELETE FROM IBE_DSP_LGL_PHYS_MAP

964: SAVEPOINT delete_msite_language_grp;
965:
966: -- API body
967:
968: DELETE FROM IBE_DSP_LGL_PHYS_MAP
969: WHERE msite_id = p_msite_id
970: AND default_site = g_no
971: AND default_language = g_no
972: AND language_code NOT IN (SELECT language_code

Line 1047: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1043: SAVEPOINT delete_one_ath_msite_grp;
1044:
1045: -- Check if it is all-sites
1046: IF p_msite_id_tbl(l_index) IS NULL THEN
1047: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1048: WHERE ( (attachment_id = p_attachment_id)
1049: AND (default_site = g_yes) );
1050: ELSE
1051: DELETE FROM IBE_DSP_LGL_PHYS_MAP

Line 1051: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1047: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1048: WHERE ( (attachment_id = p_attachment_id)
1049: AND (default_site = g_yes) );
1050: ELSE
1051: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1052: WHERE ( (attachment_id = p_attachment_id)
1053: AND (msite_id = p_msite_id_tbl(l_index))
1054: AND (default_site = g_no) );
1055: END IF;

Line 1147: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1143: SAVEPOINT delete_dlv_all_all_grp;
1144:
1145: -- API body
1146:
1147: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1148: WHERE item_id = p_deliverable_id
1149: AND default_site = g_yes
1150: AND default_language = g_yes;
1151:

Line 1203: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;

1199: l_seed_data_exists Boolean := false;
1200: l_object_version_number NUMBER;
1201:
1202: CURSOR lgl_phys_map_id_seq IS
1203: SELECT IBE_DSP_LGL_PHYS_MAP_S1.NEXTVAL FROM DUAL;
1204: BEGIN
1205: SAVEPOINT SAVE_PHYSICALMAP;
1206: l_deliverable_id := p_deliverable_id;
1207: l_msite_type := 'SITE';

Line 1258: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1254:
1255: IF (l_ocm_integration IS NULL)
1256: OR (l_ocm_integration = 'N') THEN
1257: -- Delete all the mappings fro the minisites, added by YAXU
1258: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1259: WHERE ((item_id = l_deliverable_id)
1260: AND (attachment_id = l_attachment_id)
1261: AND (content_item_key is null)
1262: AND (default_site = l_default_msite)

Line 1287: FROM IBE_DSP_LGL_PHYS_MAP

1283: THEN
1284: BEGIN
1285: SELECT lgl_phys_map_id, object_version_number
1286: INTO l_seed_lgl_phys_map_id,l_object_version_number
1287: FROM IBE_DSP_LGL_PHYS_MAP
1288: WHERE item_id = l_deliverable_id
1289: AND content_item_key = l_old_content_item_key
1290: AND attachment_id = -1
1291: AND default_site = g_yes

Line 1302: FROM IBE_DSP_LGL_PHYS_MAP

1298: ELSE
1299: BEGIN
1300: SELECT lgl_phys_map_id, object_version_number
1301: INTO l_seed_lgl_phys_map_id,l_object_version_number
1302: FROM IBE_DSP_LGL_PHYS_MAP
1303: WHERE item_id = l_deliverable_id
1304: AND attachment_id = l_attachment_id
1305: AND content_item_key is null
1306: AND default_site = g_yes

Line 1321: INSERT INTO IBE_DSP_LGL_PHYS_MAP (

1317: THEN
1318: OPEN lgl_phys_map_id_seq;
1319: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
1320: CLOSE lgl_phys_map_id_seq;
1321: INSERT INTO IBE_DSP_LGL_PHYS_MAP (
1322: lgl_phys_map_id, object_version_number, last_update_date,
1323: last_updated_by, creation_date, created_by,
1324: last_update_login, msite_id, language_code,
1325: attachment_id, item_id, default_site,

Line 1337: UPDATE IBE_DSP_LGL_PHYS_MAP

1333: IF((l_ocm_integration IS NOT NULL)
1334: AND (l_ocm_integration = 'Y')
1335: AND (p_old_content_key <> p_new_content_key))
1336: THEN
1337: UPDATE IBE_DSP_LGL_PHYS_MAP
1338: SET attachment_id = l_attachment_id,
1339: content_item_key = l_content_item_key,
1340: object_version_number = l_object_version_number+1,
1341: last_update_date = SYSDATE,

Line 1367: INSERT INTO IBE_DSP_LGL_PHYS_MAP (

1363: END IF;
1364: OPEN lgl_phys_map_id_seq;
1365: FETCH lgl_phys_map_id_seq INTO l_lgl_phys_map_id;
1366: CLOSE lgl_phys_map_id_seq;
1367: INSERT INTO IBE_DSP_LGL_PHYS_MAP (
1368: lgl_phys_map_id, object_version_number, last_update_date,
1369: last_updated_by, creation_date, created_by,
1370: last_update_login, msite_id, language_code,
1371: attachment_id, item_id, default_site,

Line 1551: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1547: IF (l_ocm_integration IS NOT NULL)
1548: AND (l_ocm_integration = 'Y') THEN
1549: -- delete all the exisitng mapping for the p_old_content_key
1550: l_old_content_item_key := p_old_content_key;
1551: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1552: WHERE ((attachment_id = -1)
1553: AND (item_id = p_deliverable_id)
1554: AND (content_item_key = l_old_content_item_key)
1555: AND (lgl_phys_map_id >=10000));

Line 1561: UPDATE IBE_DSP_LGL_PHYS_MAP

1557: IF(p_old_content_key <> p_new_content_key) -- modified by YAXU to update the mapping
1558: THEN
1559: l_old_attachment_id := TO_NUMBER(p_old_content_key);
1560: l_attachment_id := TO_NUMBER(p_new_content_key);
1561: UPDATE IBE_DSP_LGL_PHYS_MAP
1562: set attachment_id = l_attachment_id,
1563: last_update_date = SYSDATE,
1564: last_updated_by = FND_GLOBAL.user_id,
1565: last_update_login = FND_GLOBAL.login_id

Line 1683: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1679: := FND_PROFILE.value('IBE_M_USE_CONTENT_INTEGRATION');
1680: IF (l_ocm_integration IS NOT NULL)
1681: AND (l_ocm_integration = 'Y') THEN
1682: l_content_item_key := p_content_key;
1683: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1684: WHERE attachment_id = -1
1685: AND content_item_key = l_content_item_key
1686: AND item_id = l_deliverable_id;
1687: ELSE

Line 1689: DELETE FROM IBE_DSP_LGL_PHYS_MAP

1685: AND content_item_key = l_content_item_key
1686: AND item_id = l_deliverable_id;
1687: ELSE
1688: l_attachment_id := TO_NUMBER(p_content_key);
1689: DELETE FROM IBE_DSP_LGL_PHYS_MAP
1690: WHERE attachment_id = l_attachment_id
1691: AND content_item_key IS NULL
1692: AND item_id = l_deliverable_id;
1693:

Line 1701: FROM IBE_DSP_LGL_PHYS_MAP

1697: WHERE attachment_id = l_attachment_id;
1698:
1699: IF l_file_id <= 0 or l_file_id is null THEN
1700: SELECT count(1) into l_other_item_count
1701: FROM IBE_DSP_LGL_PHYS_MAP
1702: WHERE attachment_id = l_attachment_id
1703: AND content_item_key IS NULL
1704: AND item_id <> l_deliverable_id;
1705:

Line 1798: UPDATE IBE_DSP_LGL_PHYS_MAP

1794: IF (l_ocm_integration IS NOT NULL)
1795: AND (l_ocm_integration = 'Y') THEN
1796: l_content_item_key := p_new_content_key;
1797: l_old_content_item_key := p_old_content_key;
1798: UPDATE IBE_DSP_LGL_PHYS_MAP
1799: SET content_item_key = l_content_item_key
1800: WHERE content_item_key = l_old_content_item_key
1801: AND attachment_id = -1;
1802: ELSE

Line 1805: UPDATE IBE_DSP_LGL_PHYS_MAP

1801: AND attachment_id = -1;
1802: ELSE
1803: l_attachment_id := TO_NUMBER(p_new_content_key);
1804: l_old_attachment_id := TO_NUMBER(p_old_content_key);
1805: UPDATE IBE_DSP_LGL_PHYS_MAP
1806: SET attachment_id = l_attachment_id
1807: WHERE attachment_id = l_old_attachment_id
1808: AND content_item_key IS NULL;
1809: END IF;

Line 1916: FROM ibe_dsp_lgl_phys_map

1912:
1913: -- Get the value of the db_luby and db_ludate from the database.
1914: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
1915: INTO db_luby, db_ludate
1916: FROM ibe_dsp_lgl_phys_map
1917: WHERE lgl_phys_map_id = P_LGL_PHYS_MAP_ID;
1918:
1919:
1920: --Invoke standard merge comparison routine UPLOAD_TEST.

Line 1922: UPDATE ibe_dsp_lgl_phys_map

1918:
1919:
1920: --Invoke standard merge comparison routine UPLOAD_TEST.
1921: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, P_CUSTOM_MODE)) THEN
1922: UPDATE ibe_dsp_lgl_phys_map
1923: SET LGL_PHYS_MAP_ID = P_LGL_PHYS_MAP_ID,
1924: OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER,
1925: LAST_UPDATED_BY = f_luby,
1926: LAST_UPDATE_DATE = f_ludate,

Line 1946: select 1 into l_indexExists from ibe_dsp_lgl_phys_map where

1942: -- If we do not do this check then while inserting a seeded mapping row
1943: -- a unique contraint violation will be encountered
1944:
1945: BEGIN
1946: select 1 into l_indexExists from ibe_dsp_lgl_phys_map where
1947: item_id= to_number(P_ITEM_ID) and
1948: language_code= P_LANGUAGE_CODE and
1949: msite_id = to_number(P_MSITE_ID) and
1950: default_language= P_DEFAULT_LANGUAGE and

Line 1957: INSERT INTO ibe_dsp_lgl_phys_map (

1953: when NO_DATA_FOUND then
1954: l_indexExists:=null;
1955: END;
1956: IF (l_indexExists is null) then
1957: INSERT INTO ibe_dsp_lgl_phys_map (
1958: LGL_PHYS_MAP_ID,
1959: OBJECT_VERSION_NUMBER,
1960: CREATED_BY,
1961: CREATION_DATE,