eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_IH_PUB dependencies on DUAL

Line 1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;

1518: RETURN n_activity_id;
1519: END;
1520: ELSIF ((n_activity_id IS NULL) OR (n_activity_id = fnd_api.g_miss_num)) THEN
1521: LOOP
1522: SELECT jtf_ih_activities_s1.NEXTVAL INTO n_Return FROM dual;
1523: BEGIN
1524: SELECT activity_id INTO n_Dummy FROM jtf_ih_activities WHERE activity_id = n_Return;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN

Line 1565: SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;

1561: RETURN n_interaction_id;
1562: END;
1563: ELSIF ((n_interaction_id IS NULL) OR (n_interaction_id = fnd_api.g_miss_num)) THEN
1564: LOOP
1565: SELECT jtf_ih_interactions_s1.NEXTVAL INTO n_Return FROM dual;
1566: BEGIN
1567: SELECT interaction_id INTO n_Dummy FROM jtf_ih_interactions WHERE interaction_id = n_Return;
1568: EXCEPTION
1569: WHEN NO_DATA_FOUND THEN

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 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 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 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 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 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 2925: -- SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;

2921: END IF;
2922:
2923: -- Bug# 2817083
2924: --IF ((p_interaction_rec.interaction_id IS NULL) OR (p_interaction_rec.interaction_id = fnd_api.g_miss_num)) THEN
2925: -- SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;
2926: --END IF;
2927: l_int_val_rec.interaction_id := Get_Interaction_ID(p_interaction_rec.interaction_id);
2928: IF l_int_val_rec.interaction_id = -1 THEN
2929: RAISE fnd_api.g_exc_error;

Line 3079: -- SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;

3075:
3076: for idx in 1 .. p_activities.count loop
3077: --Bug# 2817083
3078: --IF ((p_activities(idx).activity_id IS NULL) OR (p_activities(idx).activity_id = fnd_api.g_miss_num)) THEN
3079: -- SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;
3080: --END IF;
3081:
3082: -- Bug# 2323210
3083: if(p_activities(idx).start_date_time <> fnd_api.g_miss_date) AND (p_activities(idx).start_date_time IS NOT NULL) then

Line 4143: --SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;

4139: END IF;
4140: END IF;
4141: --l_test_msg := '5';
4142:
4143: --SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;
4144: --l_test_msg := '6';
4145:
4146: -- Bug# 2817083
4147: --l_interaction_id := Get_Interaction_ID(NULL);

Line 5962: --SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

5958:
5959: -- Bug 2817083
5960: --l_activity_id := Get_Activity_ID(NULL);
5961: l_activity_rec.activity_id := Get_Activity_ID(NULL);
5962: --SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;
5963:
5964: validate_source_code(l_api_name_full, l_activity_rec.source_code_id, l_activity_rec.source_code, x_return_status);
5965: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
5966: RAISE fnd_api.g_exc_error;

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

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: