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_PROB_CODE_MAPPING_PKG dependencies on CS_SR_PROB_CODE_MAPPING_DETAIL

Line 58: cs_sr_prob_code_mapping_detail cstl

54: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
55: cslkup.lookup_code = l_problem_code and
56: not exists
57: ( select 'X' from
58: cs_sr_prob_code_mapping_detail cstl
59: where
60: cstl.problem_code = cslkup.lookup_code and
61: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
62: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 91: cs_sr_prob_code_mapping_detail cstl

87: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
88: cslkup.lookup_code = l_problem_code and
89: exists
90: ( select 'X' from
91: cs_sr_prob_code_mapping_detail cstl
92: where
93: cstl.problem_code = cslkup.lookup_code and
94: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
95: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 132: cs_sr_prob_code_mapping_detail cstl

128: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
129: cslkup.lookup_code = l_problem_code and
130: exists
131: ( select 'X' from
132: cs_sr_prob_code_mapping_detail cstl
133: where
134: cstl.problem_code = cslkup.lookup_code and
135: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
136: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 182: cs_sr_prob_code_mapping_detail cstl

178: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
179: cslkup.lookup_code = l_problem_code and
180: exists
181: ( select 'X' from
182: cs_sr_prob_code_mapping_detail cstl
183: where
184: cstl.problem_code = cslkup.lookup_code and
185: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
186: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 216: cs_sr_prob_code_mapping_detail cstl

212: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
213: cslkup.lookup_code = l_problem_code and
214: exists
215: ( select 'X' from
216: cs_sr_prob_code_mapping_detail cstl
217: where
218: cstl.problem_code = cslkup.lookup_code and
219: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
220: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 242: cs_sr_prob_code_mapping_detail cstl

238: cslkup.lookup_type='REQUEST_PROBLEM_CODE' and
239: cslkup.lookup_code = l_problem_code and
240: exists
241: ( select 'X' from
242: cs_sr_prob_code_mapping_detail cstl
243: where
244: cstl.problem_code = cslkup.lookup_code and
245: (cstl.map_start_date_active is null or trunc(cstl.map_start_date_active) <= trunc(sysdate)) and
246: (cstl.map_end_date_active is null or trunc(cstl.map_end_date_active) >= trunc(sysdate)) and

Line 559: SELECT problem_map_detail_id,start_date_active, end_date_active from cs_sr_prob_code_mapping_detail

555: (end_date_active is null or
556: trunc(end_date_active) >= trunc(sysdate));
557:
558: CURSOR c_sr_prob_code_map_exists_csr IS
559: SELECT problem_map_detail_id,start_date_active, end_date_active from cs_sr_prob_code_mapping_detail
560: WHERE problem_map_id = l_problem_map_id
561: AND problem_code = l_problem_code
562: AND (start_date_active is null or trunc(start_date_active) <= trunc(sysdate))
563: AND (end_date_active is null or trunc(end_date_active) >= trunc(sysdate));

Line 686: CS_SR_PROB_CODE_MAPPING_DETAIL table */

682: RAISE fnd_api.g_exc_unexpected_error;
683: END IF;
684:
685: /* Now, we need to create the actual problem code -> search criteria mapping details in
686: CS_SR_PROB_CODE_MAPPING_DETAIL table */
687:
688: /* First, the following validation checks :
689: #1) the problem code should be a CS lookup code with lookup type = 'REQUEST_PROBLEM_CODE'
690: #2) the problem code mapping should not already be present. Though this is creation API, it is

Line 729: /* We can create the problem code mapping in CS_SR_PROB_CODE_MAPPING_DETAIL table now */

725: l_start_date_active >= l_end_date_active) THEN
726: RAISE fnd_api.g_exc_unexpected_error;
727: END IF;
728:
729: /* We can create the problem code mapping in CS_SR_PROB_CODE_MAPPING_DETAIL table now */
730: CS_SR_PROB_CODE_MAP_DETAIL_PKG.INSERT_ROW (
731: PX_PROBLEM_MAP_DETAIL_ID => l_problem_map_detail_id,
732: P_PROBLEM_MAP_ID => l_problem_map_id,
733: P_INCIDENT_TYPE_ID => l_service_request_type_id,

Line 917: SELECT problem_code,start_date_active,end_date_active from CS_SR_PROB_CODE_MAPPING_DETAIL

913: (end_date_active is null or
914: trunc(end_date_active) >= trunc(sysdate));
915:
916: CURSOR cs_sr_probcode_mapped_csr IS
917: SELECT problem_code,start_date_active,end_date_active from CS_SR_PROB_CODE_MAPPING_DETAIL
918: WHERE problem_map_id = l_problem_map_id and
919: problem_map_detail_id <> nvl(l_problem_map_detail_id,0) and
920: problem_code = l_problem_code and
921: (start_date_active is null or

Line 1192: FROM CS_SR_PROB_CODE_MAPPING_DETAIL

1188: map_start_date_active, map_end_date_active,
1189: start_date_active, end_date_active,
1190: incident_type_id, inventory_item_id, organization_id,
1191: category_id, problem_code
1192: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
1193: WHERE
1194: problem_map_id = l_problem_map_id;
1195: cs_sr_probmapid_rules_rec cs_sr_probmapid_rules_csr%ROWTYPE;
1196:

Line 1220: update CS_SR_PROB_CODE_MAPPING_DETAIL

1216:
1217: IF(cs_sr_probmapid_crit_rec.start_date_active is not null AND
1218: nvl(cs_sr_probmapid_rules_rec.map_start_date_active, cs_sr_probmapid_crit_rec.start_date_active+1) <> cs_sr_probmapid_crit_rec.start_date_active) THEN
1219:
1220: update CS_SR_PROB_CODE_MAPPING_DETAIL
1221: set
1222: map_start_date_active = cs_sr_probmapid_crit_rec.start_date_active,
1223: map_end_date_active = cs_sr_probmapid_crit_rec.end_date_active
1224: where

Line 1230: update CS_SR_PROB_CODE_MAPPING_DETAIL

1226: ELSIF (cs_sr_probmapid_crit_rec.start_date_active is null AND
1227: cs_sr_probmapid_crit_rec.end_date_active is not null AND
1228: nvl(cs_sr_probmapid_rules_rec.map_end_date_active, cs_sr_probmapid_crit_rec.end_date_active+1) <> cs_sr_probmapid_crit_rec.end_date_active) THEN
1229:
1230: update CS_SR_PROB_CODE_MAPPING_DETAIL
1231: set
1232: map_start_date_active = cs_sr_probmapid_crit_rec.start_date_active,
1233: map_end_date_active = cs_sr_probmapid_crit_rec.end_date_active
1234: where