APPS.JTF_IH_PUB dependencies on JTF_IH_MEDIA_ITEMS_S1

Line 1607: SELECT jtf_ih_media_items_s1.NEXTVAL INTO n_Return FROM dual;

1603: RETURN n_media_id;
1604: END;
1605: ELSIF ((n_media_id IS NULL) OR (n_media_id = fnd_api.g_miss_num)) THEN
1606: LOOP
1607: SELECT jtf_ih_media_items_s1.NEXTVAL INTO n_Return FROM dual;
1608: BEGIN
1609: SELECT n_media_id INTO n_Dummy FROM jtf_ih_media_items WHERE media_id = n_Return;
1610: EXCEPTION
1611: WHEN NO_DATA_FOUND THEN

Line 1829: -- SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;

1825: l_int_val_rec.address := p_media.address;
1826: END IF;
1827:
1828: --IF ((p_media.media_id IS NULL) OR (p_media.media_id = fnd_api.g_miss_num)) THEN
1829: -- SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;
1830: --END IF;
1831: -- Bug# 2817083
1832: l_int_val_rec.media_id := Get_Media_Id(p_media.media_id);
1833: IF l_int_val_rec.media_id = -1 THEN

Line 2264: --SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;

2260: l_media_rec.address := p_media_rec.address;
2261: END IF;
2262:
2263:
2264: --SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;
2265: --l_media_id := Get_Media_Id(NULL);
2266: l_media_rec.media_id := Get_Media_Id(NULL);
2267:
2268: -- DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB.Create_MediaItem');

Line 7710: --SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;

7706: l_media_rec.address := p_media_rec.address;
7707: END IF;
7708:
7709: -- Bug# 2817083
7710: --SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;
7711: --l_media_id := Get_Media_Id(NULL);
7712: l_media_rec.media_id := Get_Media_Id(NULL);
7713:
7714: INSERT INTO jtf_ih_media_items