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_SR_CONTRACT_HEADERS

Line 6: -- CSL_SR_CONTRACT_HEADERS

2: /* $Header: cslctrhb.pls 120.0 2005/05/25 11:06:41 appldev noship $ */
3:
4: /*** Globals ***/
5:
6: -- CSL_SR_CONTRACT_HEADERS
7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';
8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
9: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SR_CONTRACT_HEADERS');
10: g_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS';

Line 7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';

3:
4: /*** Globals ***/
5:
6: -- CSL_SR_CONTRACT_HEADERS
7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';
8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
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';

Line 9: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_SR_CONTRACT_HEADERS');

5:
6: -- CSL_SR_CONTRACT_HEADERS
7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';
8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
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

Line 10: g_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS';

6: -- CSL_SR_CONTRACT_HEADERS
7: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSL_SR_CONTRACT_HEADERS_ACC';
8: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
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';

Line 508: INSERT INTO CSL_SR_CONTRACT_HEADERS

504: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
505: , 'csl_contract_handling_pkg');
506: END IF;
507:
508: INSERT INTO CSL_SR_CONTRACT_HEADERS
509: ( INCIDENT_ID
510: , CONTRACT_SERVICE_ID
511: , CONTRACT_NUMBER
512: , SERVICE_NAME

Line 588: FROM CSL_SR_CONTRACT_HEADERS

584: AND h.sts_code = 'ACTIVE';
585:
586: CURSOR c_csl_contr_record (b_incident_id NUMBER) IS
587: SELECT NULL
588: FROM CSL_SR_CONTRACT_HEADERS
589: WHERE INCIDENT_ID = b_incident_id;
590:
591: r_csl_contr_record c_csl_contr_record%ROWTYPE;
592:

Line 628: , 'Contract Line for INCIDENT_ID: ' || p_incident_id || ' does not exist in CSL_SR_CONTRACT_HEADERS'

624: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
625: jtm_message_log_pkg.Log_Msg
626: ( p_incident_id
627: , g_table_name1
628: , 'Contract Line for INCIDENT_ID: ' || p_incident_id || ' does not exist in CSL_SR_CONTRACT_HEADERS'
629: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
630: , 'csl_contract_handling_pkg');
631:
632: jtm_message_log_pkg.Log_Msg

Line 925: FROM CSL_SR_CONTRACT_HEADERS

921: , x_return_status OUT NOCOPY VARCHAR2)
922: IS
923: CURSOR c_csl_contr_record (b_incident_id NUMBER) IS
924: SELECT CONTRACT_SERVICE_ID
925: FROM CSL_SR_CONTRACT_HEADERS
926: WHERE INCIDENT_ID = b_incident_id;
927: r_csl_contr_record c_csl_contr_record%ROWTYPE;
928:
929: BEGIN

Line 942: /* is new contract different from contract stored in csl_sr_contract_headers? */

938: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL
939: , 'csl_contract_handling_pkg');
940: END IF;
941:
942: /*** is new contract different from contract stored in csl_sr_contract_headers? ***/
943: OPEN c_csl_contr_record( 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

Line 950: DELETE CSL_SR_CONTRACT_HEADERS WHERE incident_id = p_incident_id;

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;
954:

Line 996: FROM CSL_SR_CONTRACT_HEADERS

992: , x_return_status OUT NOCOPY VARCHAR2) IS
993:
994: CURSOR c_csl_contr_record (b_incident_id NUMBER) IS
995: SELECT CONTRACT_SERVICE_ID
996: FROM CSL_SR_CONTRACT_HEADERS
997: WHERE INCIDENT_ID = b_incident_id;
998: r_csl_contr_record c_csl_contr_record%ROWTYPE;
999:
1000: BEGIN