DBA Data[Home] [Help]

APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_CONTR_BUSS_TXN_TYPES_ACC

Line 21: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC';

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 :=
23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');
24: g_pk1_name3 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
25: g_pk2_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 27: g_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC_S';

23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');
24: g_pk1_name3 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
25: g_pk2_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
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 :=

Line 205: FROM csm_contr_buss_txn_types_acc acc

201: CURSOR l_access_id_csr(p_contract_service_id IN VARCHAR2, p_business_process_id in number,
202: p_txn_billing_type_id in number, p_user_id IN number)
203: IS
204: SELECT acc.access_id, acc.counter
205: FROM csm_contr_buss_txn_types_acc acc
206: WHERE user_id = p_user_id
207: AND contract_service_id = p_contract_service_id
208: AND business_process_id = p_business_process_id
209: AND txn_billing_type_id = p_txn_billing_type_id;

Line 636: FROM csm_contr_buss_txn_types_acc

632: p_businessprocessid IN number,
633: p_userid IN number)
634: IS
635: SELECT contract_service_id, business_process_id, txn_billing_type_id
636: FROM csm_contr_buss_txn_types_acc
637: WHERE user_id = p_userid
638: AND contract_service_id = p_contractserviceid
639: AND business_process_id = p_businessprocessid;
640: