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_UTIL dependencies on CS_INCIDENT_STATUSES_B

Line 63: -- cs_incident_statuses_b

59: -- -----------------------------------------------------------------------------
60: -- Procedure Name : get_status_details
61: -- Parameter :
62: -- IN : p_status_id This foreign key to
63: -- cs_incident_statuses_b
64: -- OUT : x_close_flag
65: -- : x_disallow_request_update Any SR attribute except statrus
66: -- can not be updated.
67: -- : x_disallow_agent_dispatch owner update not allowed

Line 122: cs_incident_statuses_b

118: , x_intermediate_status_id
119: , x_approval_action_status_id
120: , x_rejection_action_status_id
121: FROM
122: cs_incident_statuses_b
123: WHERE incident_status_id = p_status_id
124: -- AND trunc(sysdate) BETWEEN NVL(start_date_active,l_dt)
125: -- AND NVL(end_date_active ,l_dt)
126: ;

Line 1292: FROM cs_incident_statuses_b

1288: -- Cursor to Validate Status
1289:
1290: CURSOR all_statuses_csr IS
1291: SELECT seeded_flag, close_flag
1292: FROM cs_incident_statuses_b
1293: WHERE incident_subtype = p_subtype
1294: AND incident_status_id = p_status_id
1295: AND valid_in_create_flag = 'Y'
1296: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))

Line 1301: FROM cs_incident_statuses_b

1297: AND TRUNC(NVL(end_date_active, SYSDATE));
1298:
1299: CURSOR all_statuses_csr1 IS
1300: SELECT seeded_flag, close_flag
1301: FROM cs_incident_statuses_b
1302: WHERE incident_subtype = p_subtype
1303: AND incident_status_id = p_status_id
1304: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1305: AND TRUNC(NVL(end_date_active, SYSDATE));

Line 1449: FROM cs_incident_statuses_b

1445:
1446: -- Cursor to Validate Status
1447: CURSOR all_statuses_csr IS
1448: SELECT seeded_flag, close_flag
1449: FROM cs_incident_statuses_b
1450: WHERE incident_subtype = p_subtype
1451: AND incident_status_id = p_new_status_id
1452: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1453: AND TRUNC(NVL(end_date_active, SYSDATE));

Line 1519: FROM cs_incident_statuses_b

1515: SELECT close_flag, disallow_request_update,
1516: disallow_agent_dispatch, disallow_product_update
1517: INTO p_close_flag, p_disallow_request_update,
1518: p_disallow_owner_update, p_disallow_product_update
1519: FROM cs_incident_statuses_b
1520: WHERE incident_status_id = p_old_status_id
1521: AND incident_subtype = p_subtype;
1522: -- AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1523: -- AND TRUNC(NVL(end_date_active, SYSDATE));

Line 1527: FROM cs_incident_statuses_b

1523: -- AND TRUNC(NVL(end_date_active, SYSDATE));
1524:
1525: --Added the query because the close_date did not populate with SYSDATE
1526: SELECT close_flag INTO p_close_flag
1527: FROM cs_incident_statuses_b
1528: WHERE incident_status_id = p_new_status_id
1529: AND incident_subtype = p_subtype
1530: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE))
1531: AND TRUNC(NVL(end_date_active, SYSDATE));

Line 6495: FROM cs_incident_statuses_b

6491: x_return_status := FND_API.G_RET_STS_SUCCESS;
6492:
6493: SELECT close_flag
6494: INTO l_close_flag
6495: FROM cs_incident_statuses_b
6496: WHERE incident_status_id = p_status_id;
6497:
6498: IF ( l_close_flag = 'Y' ) THEN
6499: SELECT COUNT(*)

Line 9765: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;

9761: , x_inc_responded_by_date IN OUT NOCOPY DATE
9762: , x_incident_resolved_date IN OUT NOCOPY DATE
9763: , x_return_status OUT NOCOPY VARCHAR2
9764: ) IS
9765: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9766: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9767: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9768: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9769: BEGIN

Line 9766: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;

9762: , x_incident_resolved_date IN OUT NOCOPY DATE
9763: , x_return_status OUT NOCOPY VARCHAR2
9764: ) IS
9765: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9766: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9767: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9768: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9769: BEGIN
9770: -- Logic added for 11.5.10 enhancement : Usability changes

Line 9767: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;

9763: , x_return_status OUT NOCOPY VARCHAR2
9764: ) IS
9765: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9766: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9767: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9768: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9769: BEGIN
9770: -- Logic added for 11.5.10 enhancement : Usability changes
9771: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9768: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;

9764: ) IS
9765: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9766: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9767: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9768: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9769: BEGIN
9770: -- Logic added for 11.5.10 enhancement : Usability changes
9771: x_return_status := FND_API.G_RET_STS_SUCCESS;
9772: SELECT