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 1294: FROM cs_incident_statuses_b

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

Line 1303: FROM cs_incident_statuses_b

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

Line 1451: FROM cs_incident_statuses_b

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

Line 1521: FROM cs_incident_statuses_b

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

Line 1529: FROM cs_incident_statuses_b

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

Line 6511: FROM cs_incident_statuses_b

6507: x_return_status := FND_API.G_RET_STS_SUCCESS;
6508:
6509: SELECT close_flag
6510: INTO l_close_flag
6511: FROM cs_incident_statuses_b
6512: WHERE incident_status_id = p_status_id;
6513:
6514: IF ( l_close_flag = 'Y' ) THEN
6515: SELECT COUNT(*)

Line 9818: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;

9814: , x_inc_responded_by_date IN OUT NOCOPY DATE
9815: , x_incident_resolved_date IN OUT NOCOPY DATE
9816: , x_return_status OUT NOCOPY VARCHAR2
9817: ) IS
9818: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9819: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9820: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9821: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9822: BEGIN

Line 9819: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;

9815: , x_incident_resolved_date IN OUT NOCOPY DATE
9816: , x_return_status OUT NOCOPY VARCHAR2
9817: ) IS
9818: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9819: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9820: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9821: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9822: BEGIN
9823: -- Logic added for 11.5.10 enhancement : Usability changes

Line 9820: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;

9816: , x_return_status OUT NOCOPY VARCHAR2
9817: ) IS
9818: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9819: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9820: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9821: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9822: BEGIN
9823: -- Logic added for 11.5.10 enhancement : Usability changes
9824: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9821: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;

9817: ) IS
9818: l_new_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9819: l_old_responded_flag CS_INCIDENT_STATUSES_B.responded_flag % TYPE;
9820: l_new_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9821: l_old_resolved_flag CS_INCIDENT_STATUSES_B.resolved_flag % TYPE;
9822: BEGIN
9823: -- Logic added for 11.5.10 enhancement : Usability changes
9824: x_return_status := FND_API.G_RET_STS_SUCCESS;
9825: SELECT