APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_M_LOBS_INQ

Line 45: FROM csf_m_lobs_inq

41: CURSOR c_debrief_signature(p_debrief_header_id IN NUMBER, b_user_name IN VARCHAR2,
42: b_tranid IN NUMBER)
43: IS
44: SELECT file_id, pk1_value
45: FROM csf_m_lobs_inq
46: WHERE tranid$$ = b_tranid
47: AND clid$$cs = b_user_name
48: AND entity_name = 'CSF_DEBRIEF_HEADERS'
49: AND to_number(pk1_value) = p_debrief_header_id

Line 615: UPDATE csf_m_lobs_inq

611: WHERE CURRENT OF c_debrief_notes;
612: END LOOP;
613:
614: FOR r_debrief_signature IN c_debrief_signature(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
615: UPDATE csf_m_lobs_inq
616: SET pk1_value = l_debrief_header_id
617: WHERE CURRENT OF c_debrief_signature;
618: END LOOP;
619:

Line 658: UPDATE csf_m_lobs_inq

654: SET source_object_id = l_debrief_header_id
655: WHERE CURRENT OF c_debrief_notes;
656: END LOOP;
657: FOR r_debrief_signature IN c_debrief_signature(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
658: UPDATE csf_m_lobs_inq
659: SET pk1_value = l_debrief_header_id
660: WHERE CURRENT OF c_debrief_signature;
661: END LOOP;
662: