DBA Data[Home] [Help]

APPS.CAC_NOTES_PVT dependencies on JTF_NOTES_S

Line 269: IS SELECT JTF_NOTES_S.NEXTVAL

265:
266:
267: -- Cursor for getting the note ID from the sequence
268: CURSOR l_jtf_note_id_csr
269: IS SELECT JTF_NOTES_S.NEXTVAL
270: FROM DUAL;
271:
272: BEGIN
273: -- API savepoint

Line 558: jtf_notes_s.nextval,

554: LAST_UPDATE_DATE,
555: LAST_UPDATED_BY,
556: LAST_UPDATE_LOGIN)
557: VALUES (
558: jtf_notes_s.nextval,
559: L_jtf_note_id,
560: P_source_object_id,
561: P_source_object_code,
562: NVL(p_creation_date,l_current_date),

Line 1279: NVL(p_note_context_id,jtf_notes_s.nextval),

1275: LAST_UPDATE_LOGIN
1276: )
1277: VALUES
1278: (
1279: NVL(p_note_context_id,jtf_notes_s.nextval),
1280: p_jtf_note_id,
1281: p_note_context_type_id,
1282: p_note_context_type,
1283: NVL(p_creation_date,l_current_date),