APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_M_NOTES_INQ

Line 29: FROM csf_m_notes_inq

25:
26: CURSOR c_debrief_notes(p_debrief_header_id number, b_user_name varchar2, b_tranid number)
27: IS
28: SELECT jtf_note_id, source_object_id
29: FROM csf_m_notes_inq
30: WHERE tranid$$ = b_tranid
31: AND clid$$cs = b_user_name
32: AND source_object_code = 'SD'
33: AND source_object_id = p_debrief_header_id

Line 631: UPDATE csf_m_notes_inq

627: OPEN c_debrief(r_debrief_headers.task_assignment_id);
628: FETCH c_debrief INTO l_debrief_header_id;
629: IF c_debrief%FOUND THEN
630: FOR r_debrief_notes IN c_debrief_notes(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
631: UPDATE csf_m_notes_inq
632: SET source_object_id = l_debrief_header_id
633: WHERE CURRENT OF c_debrief_notes;
634: END LOOP;
635:

Line 675: UPDATE csf_m_notes_inq

671: OPEN c_debrief(r_debrief_headers.task_assignment_id);
672: FETCH c_debrief INTO l_debrief_header_id;
673: IF c_debrief%FOUND THEN
674: FOR r_debrief_notes IN c_debrief_notes(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
675: UPDATE csf_m_notes_inq
676: SET source_object_id = l_debrief_header_id
677: WHERE CURRENT OF c_debrief_notes;
678: END LOOP;
679: FOR r_debrief_signature IN c_debrief_signature(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP