DBA Data[Home] [Help]

APPS.CAC_VIEW_UTIL_PVT dependencies on CAC_VIEW_COLLAB_DETAILS_S

Line 56: SELECT cac_view_collab_details_s.nextval

52: CLOSE c_collab;
53: END IF;
54: CLOSE c_collab;
55: -- new collab_id
56: SELECT cac_view_collab_details_s.nextval
57: INTO l_seqnum
58: FROM DUAL;
59:
60: CAC_VIEW_COLLAB_DETAILS_PKG.INSERT_ROW(

Line 139: SELECT cac_view_collab_details_s.nextval

135: IF c_collab_update%NOTFOUND THEN
136: CLOSE c_collab_update;
137: -- insert here
138: -- new collab_id
139: SELECT cac_view_collab_details_s.nextval
140: INTO l_seqnum
141: FROM DUAL;
142: CAC_VIEW_COLLAB_DETAILS_PKG.INSERT_ROW(
143: X_ROWID => l_row_id,