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.CS_SR_RES_CODE_MAPPING_PKG dependencies on CS_SR_RES_CODE_MAPPING_DETAIL

Line 57: cs_sr_res_code_mapping_detail cstl

53: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
54: cslkup.lookup_code = l_resolution_code and
55: not exists
56: ( select 'X' from
57: cs_sr_res_code_mapping_detail cstl
58: where
59: cstl.resolution_code = cslkup.lookup_code and
60: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
61: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 89: cs_sr_res_code_mapping_detail cstl

85: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
86: cslkup.lookup_code = l_resolution_code and
87: exists
88: ( select 'X' from
89: cs_sr_res_code_mapping_detail cstl
90: where
91: cstl.resolution_code = cslkup.lookup_code and
92: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
93: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 153: cs_sr_res_code_mapping_detail cstl

149: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
150: cslkup.lookup_code = l_resolution_code and
151: exists
152: ( select 'X' from
153: cs_sr_res_code_mapping_detail cstl
154: where
155: cstl.resolution_code = cslkup.lookup_code and
156: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
157: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 187: cs_sr_res_code_mapping_detail cstl

183: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
184: cslkup.lookup_code = l_resolution_code and
185: exists
186: ( select 'X' from
187: cs_sr_res_code_mapping_detail cstl
188: where
189: cstl.resolution_code = cslkup.lookup_code and
190: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
191: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 228: cs_sr_res_code_mapping_detail cstl

224: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
225: cslkup.lookup_code = l_resolution_code and
226: exists
227: ( select 'X' from
228: cs_sr_res_code_mapping_detail cstl
229: where
230: cstl.resolution_code = cslkup.lookup_code and
231: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
232: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 269: cs_sr_res_code_mapping_detail cstl

265: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
266: cslkup.lookup_code = l_resolution_code and
267: exists
268: ( select 'X' from
269: cs_sr_res_code_mapping_detail cstl
270: where
271: cstl.resolution_code = cslkup.lookup_code and
272: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
273: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 323: cs_sr_res_code_mapping_detail cstl

319: cslkup.lookup_type='REQUEST_RESOLUTION_CODE' and
320: cslkup.lookup_code = l_resolution_code and
321: exists
322: ( select 'X' from
323: cs_sr_res_code_mapping_detail cstl
324: where
325: cstl.resolution_code = cslkup.lookup_code and
326: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
327: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 719: SELECT resolution_map_detail_id,start_date_active, end_date_active from cs_sr_res_code_mapping_detail

715: (end_date_active is null or
716: trunc(end_date_active) >= trunc(sysdate));
717:
718: CURSOR c_sr_res_code_map_exists_csr IS
719: SELECT resolution_map_detail_id,start_date_active, end_date_active from cs_sr_res_code_mapping_detail
720: WHERE resolution_map_id = l_resolution_map_id
721: AND resolution_code = l_resolution_code
722: AND (start_date_active is null or trunc(start_date_active) <= trunc(sysdate)) and
723: (end_date_active is null or trunc(end_date_active) >= trunc(sysdate));

Line 851: CS_SR_RES_CODE_MAPPING_DETAIL table */

847: RAISE fnd_api.g_exc_unexpected_error;
848: END IF;
849:
850: /* Now, we need to create the actual resolution code -> search criteria mapping details in
851: CS_SR_RES_CODE_MAPPING_DETAIL table */
852:
853: /* First, the following validation checks :
854: #1) the resolution code should be a CS lookup code with lookup type = 'REQUEST_RESOLUTION_CODE'
855: #2) the resolution code mapping should not already be present. Though this is creation API, it is

Line 893: /* We can create the resolution code mapping in cs_sr_res_code_MAPPING_DETAIL table now */

889: l_start_date_active >= l_end_date_active) THEN
890: RAISE fnd_api.g_exc_unexpected_error;
891: END IF;
892:
893: /* We can create the resolution code mapping in cs_sr_res_code_MAPPING_DETAIL table now */
894: CS_SR_RES_CODE_MAP_DETAIL_PKG.INSERT_ROW (
895: PX_RESOLUTION_MAP_DETAIL_ID => l_resolution_map_detail_id,
896: P_RESOLUTION_MAP_ID => l_resolution_map_id,
897: P_INCIDENT_TYPE_ID => l_service_request_type_id,

Line 1087: SELECT resolution_code,start_date_active,end_date_active from CS_SR_RES_CODE_MAPPING_DETAIL

1083: (end_date_active is null or
1084: trunc(end_date_active) >= trunc(sysdate));
1085:
1086: CURSOR cs_sr_rescode_mapped_csr IS
1087: SELECT resolution_code,start_date_active,end_date_active from CS_SR_RES_CODE_MAPPING_DETAIL
1088: WHERE resolution_map_id = l_resolution_map_id and
1089: resolution_map_detail_id <> l_resolution_map_detail_id and
1090: resolution_code = l_resolution_code and
1091: (start_date_active is null or

Line 1366: FROM CS_SR_RES_CODE_MAPPING_DETAIL

1362: map_start_date_active, map_end_date_active,
1363: start_date_active, end_date_active,
1364: incident_type_id, inventory_item_id, organization_id,
1365: category_id, problem_code, resolution_code
1366: FROM CS_SR_RES_CODE_MAPPING_DETAIL
1367: WHERE
1368: resolution_map_id = l_resolution_map_id;
1369: cs_sr_resmapid_rules_rec cs_sr_resmapid_rules_csr%ROWTYPE;
1370:

Line 1394: update CS_SR_RES_CODE_MAPPING_DETAIL

1390:
1391: IF(cs_sr_resmapid_crit_rec.start_date_active is not null AND
1392: nvl(cs_sr_resmapid_rules_rec.map_start_date_active, cs_sr_resmapid_crit_rec.start_date_active+1) <> cs_sr_resmapid_crit_rec.start_date_active) THEN
1393:
1394: update CS_SR_RES_CODE_MAPPING_DETAIL
1395: set
1396: map_start_date_active = cs_sr_resmapid_crit_rec.start_date_active,
1397: map_end_date_active = cs_sr_resmapid_crit_rec.end_date_active
1398: where

Line 1404: update CS_SR_RES_CODE_MAPPING_DETAIL

1400: ELSIF (cs_sr_resmapid_crit_rec.start_date_active is null AND
1401: cs_sr_resmapid_crit_rec.end_date_active is not null AND
1402: nvl(cs_sr_resmapid_rules_rec.map_end_date_active, cs_sr_resmapid_crit_rec.end_date_active+1) <> cs_sr_resmapid_crit_rec.end_date_active) THEN
1403:
1404: update CS_SR_RES_CODE_MAPPING_DETAIL
1405: set
1406: map_start_date_active = cs_sr_resmapid_crit_rec.start_date_active,
1407: map_end_date_active = cs_sr_resmapid_crit_rec.end_date_active
1408: where