APPS.AMV_PERSPECTIVE_PVT dependencies on AMV_I_ITEM_PERSPECTIVES

Line 342: Delete from amv_i_item_perspectives

338: -- Now do the deleting:
339: Delete from amv_c_chl_perspectives
340: where perspective_id = l_perspective_id;
341: --
342: Delete from amv_i_item_perspectives
343: where perspective_id = l_perspective_id;
344: --
345: AMV_I_PERSPECTIVES_PKG.DELETE_ROW
346: (

Line 1067: From amv_i_item_perspectives

1063: --
1064: CURSOR Check_ItemPerspectives_csr (p_perspectiv_id IN NUMBER) is
1065: Select
1066: perspective_id
1067: From amv_i_item_perspectives
1068: Where item_id = p_item_id
1069: And perspective_id = p_perspectiv_id;
1070: --
1071: CURSOR Get_IDandDate_csr is

Line 1072: Select amv_i_item_perspectives_s.nextval, sysdate

1068: Where item_id = p_item_id
1069: And perspective_id = p_perspectiv_id;
1070: --
1071: CURSOR Get_IDandDate_csr is
1072: Select amv_i_item_perspectives_s.nextval, sysdate
1073: From Dual;
1074: --
1075: BEGIN
1076: -- Standard call to check for call compatibility.

Line 1165: Insert Into amv_i_item_perspectives

1161: IF AMV_UTILITY_PVT.Is_PerspectiveIdValid(l_perspective_id) THEN
1162: OPEN Get_IDandDate_csr;
1163: FETCH Get_IDandDate_csr Into l_temp_number, l_date;
1164: CLOSE Get_IDandDate_csr;
1165: Insert Into amv_i_item_perspectives
1166: (
1167: ITEM_PERSPECTIVE_ID,
1168: OBJECT_VERSION_NUMBER,
1169: LAST_UPDATE_DATE,

Line 1271: From amv_i_item_perspectives

1267: --
1268: CURSOR Check_ItemPerspectives_csr is
1269: Select
1270: perspective_id
1271: From amv_i_item_perspectives
1272: Where item_id = p_item_id
1273: And perspective_id = p_perspective_id;
1274: --
1275: CURSOR Get_IDandDate_csr is

Line 1276: Select amv_i_item_perspectives_s.nextval, sysdate

1272: Where item_id = p_item_id
1273: And perspective_id = p_perspective_id;
1274: --
1275: CURSOR Get_IDandDate_csr is
1276: Select amv_i_item_perspectives_s.nextval, sysdate
1277: From Dual;
1278: --
1279: BEGIN
1280: -- Standard call to check for call compatibility.

Line 1373: Insert Into amv_i_item_perspectives

1369: CLOSE Check_ItemPerspectives_csr;
1370: OPEN Get_IDandDate_csr;
1371: FETCH Get_IDandDate_csr Into l_item_persp, l_date;
1372: CLOSE Get_IDandDate_csr;
1373: Insert Into amv_i_item_perspectives
1374: (
1375: ITEM_PERSPECTIVE_ID,
1376: LAST_UPDATE_DATE,
1377: LAST_UPDATED_BY,

Line 1469: From amv_i_item_perspectives

1465: --
1466: CURSOR Check_ItemPerspectives_csr (p_perspectiv_id IN NUMBER) is
1467: Select
1468: perspective_id
1469: From amv_i_item_perspectives
1470: Where item_id = p_item_id
1471: And perspective_id = p_perspectiv_id;
1472: --
1473: BEGIN

Line 1558: Delete from amv_i_item_perspectives

1554: FND_MSG_PUB.Add;
1555: END IF;
1556: ELSE
1557: CLOSE Check_ItemPerspectives_csr;
1558: Delete from amv_i_item_perspectives
1559: Where item_id = p_item_id
1560: And perspective_id = l_perspective_id;
1561: END IF;
1562: END LOOP;

Line 1634: From amv_i_item_perspectives

1630: --
1631: CURSOR Check_ItemPerspectives_csr IS
1632: Select
1633: perspective_id
1634: From amv_i_item_perspectives
1635: Where item_id = p_item_id
1636: And perspective_id = p_perspective_id;
1637: --
1638: BEGIN

Line 1721: Delete from amv_i_item_perspectives

1717: END IF;
1718: RAISE FND_API.G_EXC_ERROR;
1719: ELSE
1720: CLOSE Check_ItemPerspectives_csr;
1721: Delete from amv_i_item_perspectives
1722: Where item_id = p_item_id
1723: And perspective_id = p_perspective_id;
1724: END IF;
1725: ELSE

Line 1728: Delete from amv_i_item_perspectives

1724: END IF;
1725: ELSE
1726: -- p_perspective_id is not specified,
1727: -- caller wants to delete all the perspectives of the item.
1728: Delete from amv_i_item_perspectives
1729: Where item_id = p_item_id;
1730: END IF;
1731: --Standard check of commit
1732: IF FND_API.To_Boolean ( p_commit ) THEN

Line 1853: AMV_I_ITEM_PERSPECTIVES I

1849: B.LAST_UPDATE_DATE,
1850: B.LAST_UPDATED_BY,
1851: B.LAST_UPDATE_LOGIN
1852: From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B,
1853: AMV_I_ITEM_PERSPECTIVES I
1854: Where B.PERSPECTIVE_ID = I.PERSPECTIVE_ID
1855: And T.PERSPECTIVE_ID = I.PERSPECTIVE_ID
1856: And T.LANGUAGE = userenv('LANG')
1857: And I.ITEM_ID = p_item_id