APPS.CSM_DEBRIEF_HEADER_EVENT_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 16: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_ACC';
16: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS';
17: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_ACC_S';
18: g_debrief_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_HEADER_ID';
19: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;
20:

Line 30: CURSOR l_csm_debrfHdInsInit_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)

26: l_error_msg VARCHAR2(4000);
27: l_return_status VARCHAR2(2000);
28: l_user_id NUMBER;
29:
30: CURSOR l_csm_debrfHdInsInit_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
31: IS
32: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
33: FROM csf_debrief_headers dhdr,
34: jtf_task_assignments jta,

Line 33: FROM csf_debrief_headers dhdr,

29:
30: CURSOR l_csm_debrfHdInsInit_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
31: IS
32: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
33: FROM csf_debrief_headers dhdr,
34: jtf_task_assignments jta,
35: jtf_rs_resource_extns jtrs
36: WHERE dhdr.debrief_header_id = p_debrief_header_id
37: AND jta.task_assignment_id = dhdr.task_assignment_id

Line 133: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE,

129: l_error_msg VARCHAR2(4000);
130: l_return_status VARCHAR2(2000);
131: l_user_id NUMBER;
132:
133: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE,
134: p_user_id NUMBER)
135: IS
136: SELECT dhdr.task_assignment_id, acc.user_id
137: FROM csf_debrief_headers dhdr,

Line 137: FROM csf_debrief_headers dhdr,

133: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE,
134: p_user_id NUMBER)
135: IS
136: SELECT dhdr.task_assignment_id, acc.user_id
137: FROM csf_debrief_headers dhdr,
138: csm_debrief_headers_acc acc
139: WHERE dhdr.debrief_header_id = p_debrief_header_id
140: AND acc.debrief_header_id = dhdr.debrief_header_id
141: AND acc.user_id = p_user_id;