eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_CONTRACT_HANDLING_PKG dependencies on CSL_CONTR_BUSS_PROCESSES

Line 13: -- CSL_CONTR_BUSS_PROCESSES

9: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SR_CONTRACT_HEADERS');
10: g_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS';
11: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12:
13: -- CSL_CONTR_BUSS_PROCESSES
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';
15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');
17: g_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES';

Line 14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';

10: g_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS';
11: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
12:
13: -- CSL_CONTR_BUSS_PROCESSES
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';
15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');
17: g_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES';
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';

Line 16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');

12:
13: -- CSL_CONTR_BUSS_PROCESSES
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';
15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');
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:

Line 17: g_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES';

13: -- CSL_CONTR_BUSS_PROCESSES
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_CONTR_BUSS_PROCESSES_ACC';
15: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CONTR_BUSS_PROCESSES');
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

Line 273: INSERT INTO CSL_CONTR_BUSS_PROCESSES

269: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
270: , 'csl_contract_handling_pkg');
271: END IF;
272:
273: INSERT INTO CSL_CONTR_BUSS_PROCESSES
274: ( INCIDENT_ID
275: , BUSINESS_PROCESS_ID
276: , CONTRACT_SERVICE_ID
277: , START_DATE

Line 332: FROM CSL_CONTR_BUSS_PROCESSES

328: RETURN NUMBER
329: IS
330: CURSOR c_csl_contr_bus_proc (b_incident_id NUMBER, b_cov_txn_grp_line_id NUMBER, b_bp_id NUMBER) IS
331: SELECT null
332: FROM CSL_CONTR_BUSS_PROCESSES
333: WHERE INCIDENT_ID = b_incident_id
334: AND BUSINESS_PROCESS_ID = b_bp_id
335: AND CONTRACT_SERVICE_ID = b_cov_txn_grp_line_id;
336:

Line 949: DELETE CSL_CONTR_BUSS_PROCESSES WHERE incident_id = p_incident_id;

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;
953: CLOSE c_csl_contr_record;