APPS.JTF_IH_PUB_PS dependencies on DUAL

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 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 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: (

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: (

Line 1339: SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;

1335: END IF;
1336: --DBMS_OUTPUT.PUT_LINE('PAST Validate_Interaction_Record in JTF_IH_PUB_PS.Create_Interaction');
1337: Default_Interaction_Record(l_int_val_rec);
1338: IF ((p_interaction_rec.interaction_id IS NULL) OR (p_interaction_rec.interaction_id = fnd_api.g_miss_num)) THEN
1339: SELECT jtf_ih_interactions_s1.NEXTVAL INTO l_int_val_rec.interaction_id FROM dual;
1340:
1341: END IF;
1342:
1343: INSERT INTO jtf_ih_Interactions

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

1450:
1451: Default_activity_table(l_activities);
1452: for idx in 1 .. p_activities.count loop
1453: IF ((p_activities(idx).activity_id IS NULL) OR (p_activities(idx).activity_id = fnd_api.g_miss_num)) THEN
1454: SELECT jtf_ih_activities_s1.NEXTVAL INTO l_activities(idx).activity_id FROM dual;
1455: END IF;
1456: insert into jtf_ih_Activities
1457: (
1458: OBJECT_ID,

Line 1920: SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;

1916: l_productive_time_amount := l_duration;
1917: END IF;
1918: END IF;
1919:
1920: SELECT JTF_IH_INTERACTIONS_S1.NextVal into l_interaction_id FROM dual;
1921:
1922: INSERT INTO jtf_ih_interactions
1923: (
1924: CREATED_BY,

Line 2705: SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;

2701: --DBMS_OUTPUT.PUT_LINE('PAST Validate_StartEnd_Date in JTF_IH_PUB_PS.Add_Activity');
2702: l_duration := ROUND((p_activity_rec.end_date_time - l_start_date_time)*24*60);
2703: END IF;
2704:
2705: SELECT JTF_IH_ACTIVITIES_S1.NextVal into l_activity_id FROM dual;
2706:
2707: INSERT INTO jtf_ih_Activities
2708: (
2709: ACTIVITY_ID,