DBA Data[Home] [Help]

APPS.CSM_TASK_PURGE_PKG dependencies on JTF_OBJECT_PURGE_PARAM_TMP

Line 43: UPDATE JTF_OBJECT_PURGE_PARAM_TMP

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

Line 51: JTF_OBJECT_PURGE_PARAM_TMP tmp

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