APPS.JTF_IH_PUB_PS dependencies on JTF_IH_MEDIA_ITEM_LC_SEG_S1

Line 878: SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_mlcs(idx).milcs_id FROM dual;

874:
875: Default_Mlcs_table(l_mlcs);
876: for idx in 1 .. p_mlcs.count loop
877: IF ((p_mlcs(idx).milcs_id IS NULL) OR (p_mlcs(idx).milcs_id = fnd_api.g_miss_num)) THEN
878: SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_mlcs(idx).milcs_id FROM dual;
879: END IF;
880:
881: insert into jtf_ih_media_item_lc_segs
882: (

Line 1183: SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_milcs_id FROM dual;

1179: END IF;
1180: ----DBMS_OUTPUT.PUT_LINE('PAST Validate_Mlcs_Record in JTF_IH_PUB_PS.Create_MediaLifecycle');
1181:
1182:
1183: SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_milcs_id FROM dual;
1184: ----DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB_PS.Create_MediaLifecycle');
1185:
1186: insert into jtf_ih_media_item_lc_segs
1187: (