APPS.JTF_IH_PUB_PS dependencies on JTF_IH_MEDIA_ITEMS_S1

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

818: RAISE fnd_api.g_exc_error;
819: END IF;
820: Default_Media_Item_Record(l_int_val_rec);
821: IF ((p_media.media_id IS NULL) OR (p_media.media_id = fnd_api.g_miss_num)) THEN
822: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_int_val_rec.media_id FROM dual;
823: END IF;
824:
825: insert into jtf_ih_Media_Items
826: (

Line 1029: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;

1025: END IF;
1026:
1027: ----DBMS_OUTPUT.PUT_LINE('PAST Validate_Media_Item in JTF_IH_PUB_PS.Create_MediaItem');
1028:
1029: SELECT jtf_ih_media_items_s1.NEXTVAL INTO l_media_id FROM dual;
1030:
1031: ----DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB_PS.Create_MediaItem');
1032: insert into jtf_ih_Media_Items
1033: (