APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_CONTR_BUSS_PROCESSES_ACC

Line 13: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC';

9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';
11:
12: -- CSM_CONTR_BUSS_PROCESSES
13: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC';
14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');
16: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
17: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';

14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');
16: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
17: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';
19:
20: -- CSM_CONTR_BUSS_TXN_TYPES
21: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC';
22: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 336: FROM csm_contr_buss_processes_acc acc

332: IS
333: CURSOR l_access_id_csr(p_contract_service_id IN VARCHAR2, p_business_process_id in number, p_user_id IN number)
334: IS
335: SELECT acc.access_id, acc.counter
336: FROM csm_contr_buss_processes_acc acc
337: WHERE user_id = p_user_id
338: AND contract_service_id = p_contract_service_id
339: AND business_process_id = p_business_process_id;
340:

Line 627: FROM CSM_CONTR_BUSS_PROCESSES_ACC

623: CURSOR l_contr_buss_processes_csr(p_contractserviceid IN VARCHAR2,
624: p_userid IN number)
625: IS
626: SELECT contract_service_id, business_process_id
627: FROM CSM_CONTR_BUSS_PROCESSES_ACC
628: WHERE user_id = p_userid
629: AND contract_service_id = p_contractserviceid;
630:
631: CURSOR l_contr_buss_txn_types_csr(p_contractserviceid IN varchar2,