DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on AHL_VISITS_B_S

Line 488: SELECT Ahl_Visits_B_S.NEXTVAL

484: FUNCTION Get_Visit_Id RETURN NUMBER IS
485:
486: -- To find the next id value from visit sequence
487: CURSOR c_seq IS
488: SELECT Ahl_Visits_B_S.NEXTVAL
489: FROM dual;
490:
491: -- To find whether id already exists
492: CURSOR c_id_exists (x_id IN NUMBER) IS

Line 1420: SELECT Ahl_Visits_B_S.NEXTVAL

1416: l_Visit_rec Visit_Rec_Type := p_x_Visit_rec;
1417: -- Define local Cursors
1418: -- To find the next id value from visit sequence
1419: CURSOR c_seq IS
1420: SELECT Ahl_Visits_B_S.NEXTVAL
1421: FROM dual;
1422:
1423: -- To find whether id already exists
1424: CURSOR c_id_exists (x_id IN NUMBER) IS