DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_HEADER_EVENT_PKG dependencies on CSM_DEBRIEF_HEADERS_ACC

Line 15: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_ACC';

11: -- Person Date Comments
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;

Line 17: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_HEADERS_ACC_S';

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:
21: PROCEDURE DEBRIEF_HEADER_INS_INIT(p_debrief_header_id IN NUMBER, p_h_user_id IN NUMBER,

Line 138: csm_debrief_headers_acc acc

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;
142: