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_SERVICEREQUEST_PVT dependencies on CS_SR_TYPE_MAPPING

Line 6503: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'

6499: IF NVL(l_sr_related_data.disallow_request_update,'N') <> 'Y' THEN
6500: IF p_auto_generate_tasks = 'Y' OR p_auto_generate_tasks = 'y' THEN
6501:
6502: --Fix for bug 12668350
6503: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
6504: --table first If it is not defined,then look in cs_incident_types
6505: BEGIN
6506: SELECT task_template_id into l_task_template_id
6507: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype

Line 6507: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype

6503: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
6504: --table first If it is not defined,then look in cs_incident_types
6505: BEGIN
6506: SELECT task_template_id into l_task_template_id
6507: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype
6508: WHERE srtype.incident_type_id = l_service_request_rec.type_id
6509: AND srtype.responsibility_id = p_resp_id
6510: AND trunc(sysdate) BETWEEN
6511: trunc(nvl(srtype.start_date, sysdate)) AND

Line 7722: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'

7718: IF NVL(l_new_disallow_request_update,'N') <> 'Y' THEN
7719: IF p_auto_generate_tasks = 'Y' OR p_auto_generate_tasks = 'y' THEN
7720:
7721: --Fix for bug 12668350
7722: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
7723: --table first If it is not defined,then look in cs_incident_types
7724: BEGIN
7725: SELECT task_template_id into l_task_template_id
7726: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype

Line 7726: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype

7722: --Check if status_group_id is defined in 'CS_SR_TYPE_MAPPING'
7723: --table first If it is not defined,then look in cs_incident_types
7724: BEGIN
7725: SELECT task_template_id into l_task_template_id
7726: FROM cs_sr_status_transitions cst,cs_sr_type_mapping srtype
7727: WHERE srtype.incident_type_id = l_servicerequest_rec.incident_type_id
7728: AND srtype.responsibility_id = p_resp_id
7729: AND trunc(sysdate) BETWEEN
7730: trunc(nvl(srtype.start_date, sysdate)) AND