DBA Data[Home] [Help]

APPS.CSL_CONTRACT_HANDLING_PKG dependencies on CSL_CONTR_BUSS_TXN_TYPES

Line 21: -- CSL_CONTR_BUSS_TXN_TYPES

17: g_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES';
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
20:
21: -- CSL_CONTR_BUSS_TXN_TYPES
22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';
23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');
25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';

Line 22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';

18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
20:
21: -- CSL_CONTR_BUSS_TXN_TYPES
22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';
23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');
25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';

Line 24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');

20:
21: -- CSL_CONTR_BUSS_TXN_TYPES
22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';
23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');
25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
27: g_pk2_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
28: g_pk3_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';

21: -- CSL_CONTR_BUSS_TXN_TYPES
22: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES_ACC';
23: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
24: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_TXN_TYPES');
25: g_table_name3 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_TXN_TYPES';
26: g_pk1_name3 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
27: g_pk2_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
28: g_pk3_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
29:

Line 54: INSERT INTO CSL_CONTR_BUSS_TXN_TYPES

50: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
51: , 'csl_contract_handling_pkg');
52: END IF;
53:
54: INSERT INTO CSL_CONTR_BUSS_TXN_TYPES
55: ( INCIDENT_ID
56: , TXN_BILLING_TYPE_ID
57: , BUSINESS_PROCESS_ID
58: , CONTRACT_SERVICE_ID

Line 123: FROM CSL_CONTR_BUSS_TXN_TYPES

119: , b_txn_bill_type_id NUMBER
120: , b_bp_id NUMBER
121: , b_cov_txn_grp_line_id NUMBER) IS
122: SELECT null
123: FROM CSL_CONTR_BUSS_TXN_TYPES
124: WHERE INCIDENT_ID = b_incident_id
125: AND TXN_BILLING_TYPE_ID = b_txn_bill_type_id
126: AND BUSINESS_PROCESS_ID = b_bp_id
127: AND CONTRACT_SERVICE_ID = b_cov_txn_grp_line_id;

Line 948: DELETE CSL_CONTR_BUSS_TXN_TYPES WHERE incident_id = p_incident_id;

944: FETCH c_csl_contr_record INTO r_csl_contr_record;
945: IF c_csl_contr_record%FOUND THEN
946: IF r_csl_contr_record.contract_service_id <> NVL( p_new_contract_service_id, FND_API.G_MISS_NUM ) THEN
947: /*** yes -> delete old contract from csl contract tables ***/
948: DELETE CSL_CONTR_BUSS_TXN_TYPES WHERE incident_id = p_incident_id;
949: DELETE CSL_CONTR_BUSS_PROCESSES WHERE incident_id = p_incident_id;
950: DELETE CSL_SR_CONTRACT_HEADERS WHERE incident_id = p_incident_id;
951: END IF;
952: END IF;