DBA Data[Home] [Help]

APPS.JTF_DSP_SECTION_GRP dependencies on JTF_AMV_ITEMS_B

Line 989: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b

985: IF ((p_deliverable_id IS NOT NULL) AND
986: (p_deliverable_id <> FND_API.G_MISS_NUM))
987: THEN
988: BEGIN
989: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
990: WHERE item_id = p_deliverable_id;
991: EXCEPTION
992: WHEN NO_DATA_FOUND THEN
993: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');

Line 1279: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b

1275: IF ((p_deliverable_id IS NOT NULL) AND
1276: (p_deliverable_id <> FND_API.G_MISS_NUM))
1277: THEN
1278: BEGIN
1279: SELECT item_id INTO l_deliverable_id FROM jtf_amv_items_b
1280: WHERE item_id = p_deliverable_id;
1281: EXCEPTION
1282: WHEN NO_DATA_FOUND THEN
1283: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_DLVRBL');