APPS.JTF_IH_PUB dependencies on JTF_IH_MEDIA_ITEM_LC_SEG_S1

Line 1650: SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO n_Return FROM dual;

1646: RETURN n_milcs_id;
1647: END;
1648: ELSIF ((n_milcs_id IS NULL) OR (n_milcs_id = fnd_api.g_miss_num)) THEN
1649: LOOP
1650: SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO n_Return FROM dual;
1651: BEGIN
1652: SELECT n_milcs_id INTO n_Dummy FROM jtf_ih_media_item_lc_segs WHERE milcs_id = n_Return;
1653: EXCEPTION
1654: WHEN NO_DATA_FOUND THEN

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

1953: l_mlcs(idx).duration := ROUND((l_mlcs(idx).end_date_time - l_mlcs(idx).start_date_time)*24*60*60);
1954: END IF;
1955:
1956: --IF ((p_mlcs(idx).milcs_id IS NULL) OR (p_mlcs(idx).milcs_id = fnd_api.g_miss_num)) THEN
1957: -- SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_mlcs(idx).milcs_id FROM dual;
1958: --END IF;
1959:
1960: -- Bug# 2817083
1961: l_mlcs(idx).milcs_id := Get_milcs_id(p_mlcs(idx).milcs_id);

Line 2598: --SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_milcs_id FROM dual;

2594: where milcs_code = p_media_lc_rec.milcs_code;
2595: END IF;
2596:
2597: -- Bug# 2817083
2598: --SELECT jtf_ih_media_item_lc_seg_s1.NEXTVAL INTO l_milcs_id FROM dual;
2599: -- DBMS_OUTPUT.PUT_LINE('PAST generate PK in JTF_IH_PUB.Create_MediaLifecycle '|| l_milcs_id);
2600: --l_milcs_id := Get_milcs_id(NULL);
2601: l_media_lc_rec.milcs_id := Get_milcs_id(NULL);
2602:

Line 8871: --SELECT JTF_IH_MEDIA_ITEM_LC_SEG_S1.NextVal into l_milcs_id FROM dual;

8867:
8868: -- DBMS_OUTPUT.PUT_LINE('PAST assign the duration in JTF_IH_PUB.Add_MediaLifeCycle');
8869:
8870: -- Bug# 2817083
8871: --SELECT JTF_IH_MEDIA_ITEM_LC_SEG_S1.NextVal into l_milcs_id FROM dual;
8872: -- DBMS_OUTPUT.PUT_LINE('PAST generated sequence JTF_IH_PUB.Add_MediaLifeCycle milcs := ' || l_milcs_id);
8873: --l_milcs_id := Get_milcs_id(NULL);
8874: l_media_lc_rec.milcs_id := Get_milcs_id(NULL);
8875: