APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 39: FROM csf_debrief_headers

35:
36: CURSOR c_debrief (p_task_assignment_id number)
37: IS
38: SELECT debrief_header_id
39: FROM csf_debrief_headers
40: WHERE task_assignment_id = p_task_assignment_id;
41:
42: CURSOR c_debrief_signature(p_debrief_header_id IN NUMBER, b_user_name IN VARCHAR2,
43: b_tranid IN NUMBER)

Line 49: AND entity_name = 'CSF_DEBRIEF_HEADERS'

45: SELECT file_id, pk1_value
46: FROM csf_m_lobs_inq
47: WHERE tranid$$ = b_tranid
48: AND clid$$cs = b_user_name
49: AND entity_name = 'CSF_DEBRIEF_HEADERS'
50: AND to_number(pk1_value) = p_debrief_header_id
51: FOR UPDATE OF pk1_value NOWAIT;
52:
53: /***

Line 90: from csf_debrief_headers

86: , ATTRIBUTE13
87: , ATTRIBUTE14
88: , ATTRIBUTE15
89: , ATTRIBUTE_CATEGORY
90: from csf_debrief_headers
91: where task_assignment_id = b_task_assignment_id;
92:
93: r_deb_head c_deb_head%rowtype;
94:

Line 279: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '

275: -- SERVER_WINS profile value
276: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS) AND
277: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN
278: IF(r_deb_head.last_update_date <> p_record.server_last_update_date AND r_deb_head.last_updated_by <> NVL(p_record.last_updated_by,asg_base.get_user_id(p_record.clid$$cs))) THEN --12.1
279: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '
280: || p_record.debrief_header_id;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: csm_util_pkg.log(p_error_msg, g_object_name || '.APPLY_UPDATE', FND_LOG.LEVEL_ERROR);
283: RETURN;

Line 382: FROM csf_debrief_headers dh

378: SELECT dh.debrief_header_id
379: , dh.debrief_number
380: , dh.last_update_date
381: , dh.last_updated_by
382: FROM csf_debrief_headers dh
383: WHERE dh.debrief_header_id = b_debrief_header_id
384: UNION
385: SELECT dh.debrief_header_id
386: , dh.debrief_number

Line 389: FROM csf_debrief_headers dh

385: SELECT dh.debrief_header_id
386: , dh.debrief_number
387: , dh.last_update_date
388: , dh.last_updated_by
389: FROM csf_debrief_headers dh
390: WHERE dh.task_assignment_id = b_task_assignment_id
391: ;
392:
393: r_debrief_header c_debrief_header%ROWTYPE;

Line 587: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

583: p_task_assignment_id IN NUMBER
584: ) IS
585: l_process_status VARCHAR2(1);
586: l_error_msg VARCHAR2(4000);
587: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
588:
589: TYPE c_curtype is ref cursor;
590: c_cur c_curtype;
591: r_debrief_headers c_debrief_headers%rowtype;

Line 739: FROM csf_debrief_headers b,

735: l_user_name in varchar2,
736: l_sequence in number)
737: IS
738: SELECT b.last_updated_by
739: FROM csf_debrief_headers b,
740: csm_debrief_headers_inq a
741: WHERE a.clid$$cs = l_user_name
742: AND tranid$$ = l_tran_id
743: AND seqno$$ = l_sequence