APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_COV_ACTION_TIMES_ACC

Line 30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_COV_ACTION_TIMES_ACC';

26: g_pk3_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
27: g_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC_S';
28:
29: --CSM_COV_ACTION_TIMES
30: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'CSM_COV_ACTION_TIMES_ACC';
31: g_publication_item_name4 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
32: CSM_ACC_PKG.t_publication_item_list('CSM_COV_ACTION_TIMES');
33: g_pk1_name4 CONSTANT VARCHAR2(30) := 'ID';
34: g_pk2_name4 CONSTANT VARCHAR2(30) := 'INCIDENT_SEVERITY_ID1';

Line 36: g_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_COV_ACTION_TIMES_ACC_S';

32: CSM_ACC_PKG.t_publication_item_list('CSM_COV_ACTION_TIMES');
33: g_pk1_name4 CONSTANT VARCHAR2(30) := 'ID';
34: g_pk2_name4 CONSTANT VARCHAR2(30) := 'INCIDENT_SEVERITY_ID1';
35: g_pk3_name4 CONSTANT VARCHAR2(30) := 'ACTION_TYPE_CODE';
36: g_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_COV_ACTION_TIMES_ACC_S';
37:
38: -- CSF_M_NOTES
39: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
40: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';

Line 110: UPDATE CSM_COV_ACTION_TIMES_ACC

106: ,P_PK3_CHAR_VALUE => r_get_cov_times.ACTION_TYPE_CODE
107: ,P_USER_ID => p_user_id
108: );
109:
110: UPDATE CSM_COV_ACTION_TIMES_ACC
111: SET JTOT_OBJECT1_CODE = 'OKX_BUSIPROC',
112: OBJECT1_ID1 = p_business_proc_id,
113: CONTRACT_SERVICE_ID = p_contract_service_id
114: WHERE ID = r_get_cov_times.ID

Line 144: FROM CSM_COV_ACTION_TIMES_ACC

140: IS
141: CURSOR c_delete_cov_times(c_contract_service_id IN VARCHAR2, c_business_process_id in NUMBER, c_user_id NUMBER)
142: IS
143: SELECT ID,INCIDENT_SEVERITY_ID1,ACTION_TYPE_CODE
144: FROM CSM_COV_ACTION_TIMES_ACC
145: WHERE USER_ID = c_user_id
146: AND CONTRACT_SERVICE_ID = c_contract_service_id
147: AND OBJECT1_ID1 = c_business_process_id;
148: