APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_CONTR_HEADERS_ACC

Line 6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';

2: /* $Header: csmectrb.pls 120.2 2005/11/06 08:37:47 trajasek noship $*/
3:
4: /*** Globals ***/
5: -- CSM_CONTR_HEADERS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';

Line 10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';

6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');
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 :=

Line 346: FROM csm_contr_headers_acc acc

342:
343: CURSOR l_access_id_csr(p_incident_id IN number, p_user_id IN number)
344: IS
345: SELECT acc.access_id, acc.counter
346: FROM csm_contr_headers_acc acc
347: WHERE incident_id = p_incident_id
348: AND user_id = p_user_id;
349:
350: r_csm_contract_line_details l_csm_contract_line_details%ROWTYPE;

Line 460: FROM CSM_CONTR_HEADERS_ACC

456: CURSOR l_contr_headers_csr(p_incidentid IN number,
457: p_userid IN number)
458: IS
459: SELECT incident_id, contract_service_id
460: FROM CSM_CONTR_HEADERS_ACC
461: WHERE user_id = p_user_id
462: AND incident_id = p_incidentid;
463:
464: CURSOR l_contr_buss_processes_csr(p_contractserviceid IN VARCHAR2,