APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 38: FROM csf_debrief_headers

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

Line 48: AND entity_name = 'CSF_DEBRIEF_HEADERS'

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
50: FOR UPDATE OF pk1_value NOWAIT;
51:
52: /***

Line 89: from csf_debrief_headers

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

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

272: -- SERVER_WINS profile value
273: IF(l_profile_value = csm_profile_pkg.g_SERVER_WINS) AND
274: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_pub_name, p_record.seqno$$) <> FND_API.G_TRUE THEN
275: 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
276: p_error_msg := 'UPWARD SYNC CONFLICT: CLIENT LOST For CSF_DEBRIEF_HEADERS: CSM_DEBRIEF_HEADERS_PKG.APPLY_UPDATE: P_KEY = '
277: || p_record.debrief_header_id;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: csm_util_pkg.log(p_error_msg, g_object_name || '.APPLY_UPDATE', FND_LOG.LEVEL_ERROR);
280: RETURN;

Line 379: FROM csf_debrief_headers dh

375: SELECT dh.debrief_header_id
376: , dh.debrief_number
377: , dh.last_update_date
378: , dh.last_updated_by
379: FROM csf_debrief_headers dh
380: WHERE dh.debrief_header_id = b_debrief_header_id
381: UNION
382: SELECT dh.debrief_header_id
383: , dh.debrief_number

Line 386: FROM csf_debrief_headers dh

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

Line 581: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

577: x_return_status IN out nocopy VARCHAR2
578: ) IS
579: l_process_status VARCHAR2(1);
580: l_error_msg VARCHAR2(4000);
581: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
582:
583: BEGIN
584: g_debug_level := p_debug_level;
585: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 716: FROM csf_debrief_headers b,

712: l_user_name in varchar2,
713: l_sequence in number)
714: IS
715: SELECT b.last_updated_by
716: FROM csf_debrief_headers b,
717: csm_debrief_headers_inq a
718: WHERE a.clid$$cs = l_user_name
719: AND tranid$$ = l_tran_id
720: AND seqno$$ = l_sequence