DBA Data[Home] [Help]

APPS.JTF_IH_PUB_PS dependencies on JTF_IH_ACTIVITIES_S1

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 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,