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 816: /*** loop through CSM_INCIDENTS_ALL_INQ records in inqueue ***/

812: 'CSM_SERVICE_REQUESTS_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
813: g_debug_level := p_debug_level;
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: /*** loop through CSM_INCIDENTS_ALL_INQ records in inqueue ***/
817: FOR r_incident IN c_incident( p_user_name, p_tranid) LOOP
818: SAVEPOINT save_rec ;
819: /*** apply record ***/
820: APPLY_RECORD

Line 948: CSM_INCIDENTS_ALL_INQ a

944: l_sequence in number)
945: IS
946: SELECT b.last_updated_by
947: FROM CS_INCIDENTS_ALL_B b,
948: CSM_INCIDENTS_ALL_INQ a
949: WHERE a.clid$$cs = l_user_name
950: AND tranid$$ = l_tran_id
951: AND seqno$$ = l_sequence
952: AND a.incident_id = b.incident_id ;