APPS.CSM_SR_PURGE_PKG dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 44: UPDATE JTF_OBJECT_PURGE_PARAM_TMP

40: (i/p parameter) has incident links to Mobile objects. If so then
41: Mark the SR as Not Purgeable else Make it Purgeable. */
42:
43: IF (nvl(P_OBJECT_TYPE, 'SR') = 'SR') THEN
44: UPDATE JTF_OBJECT_PURGE_PARAM_TMP
45: SET purge_status = 'E',
46: purge_error_message = 'CSM:CSM_SR_PURGE_FAILED'
47: WHERE processing_set_id = P_PROCESSING_SET_ID AND
48: object_id IN

Line 52: JTF_OBJECT_PURGE_PARAM_TMP tmp

48: object_id IN
49: (
50: SELECT DISTINCT acc.INCIDENT_ID
51: FROM csm_incidents_all_acc acc,
52: JTF_OBJECT_PURGE_PARAM_TMP tmp
53: WHERE tmp.object_id = acc.INCIDENT_ID AND
54: nvl(tmp.purge_status, 'S') <> 'E' AND
55: tmp.processing_set_id = P_PROCESSING_SET_ID
56: ) AND