APPS.CSM_SERVICE_REQUESTS_PKG dependencies on CSM_INCIDENTS_ALL_INQ

Line 15: FROM CSM_INCIDENTS_ALL_INQ

11:
12: /* Select all inq records */
13: CURSOR c_incident( b_user_name VARCHAR2, b_tranid NUMBER) is
14: SELECT *
15: FROM CSM_INCIDENTS_ALL_INQ
16: WHERE tranid$$ = b_tranid
17: AND clid$$cs = b_user_name;
18:
19: /* Select all contact records for incident from inq table */

Line 955: /*** loop through CSM_INCIDENTS_ALL_INQ records in inqueue ***/

951: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
952: g_debug_level := p_debug_level;
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
955: /*** loop through CSM_INCIDENTS_ALL_INQ records in inqueue ***/
956: FOR r_incident IN c_incident( p_user_name, p_tranid) LOOP
957: SAVEPOINT save_rec ;
958: /*** apply record ***/
959: APPLY_RECORD

Line 1087: CSM_INCIDENTS_ALL_INQ a

1083: l_sequence in number)
1084: IS
1085: SELECT b.last_updated_by
1086: FROM CS_INCIDENTS_ALL_B b,
1087: CSM_INCIDENTS_ALL_INQ a
1088: WHERE a.clid$$cs = l_user_name
1089: AND tranid$$ = l_tran_id
1090: AND seqno$$ = l_sequence
1091: AND a.incident_id = b.incident_id ;