APPS.CSM_HA_EVENT_PKG dependencies on ASG_SYSTEM_DIRTY_QUEUE

Line 367: -- Process ASG_SYSTEM_DIRTY_QUEUE - pending download data

363: TRACK_HA_RECORD('MOBILEADMIN.C$SYNC_HIS_PUB_ITEMS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');
364: END LOOP;
365: CLOSE cur;
366:
367: -- Process ASG_SYSTEM_DIRTY_QUEUE - pending download data
368: CSM_UTIL_PKG.LOG
369: ( 'No Pld Track of ASG_SYSTEM_DIRTY_QUEUE' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
370:
371: FOR rec IN (SELECT DISTINCT USER_ID,HA_PARENT_PAYLOAD_ID

Line 369: ( 'No Pld Track of ASG_SYSTEM_DIRTY_QUEUE' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);

365: CLOSE cur;
366:
367: -- Process ASG_SYSTEM_DIRTY_QUEUE - pending download data
368: CSM_UTIL_PKG.LOG
369: ( 'No Pld Track of ASG_SYSTEM_DIRTY_QUEUE' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
370:
371: FOR rec IN (SELECT DISTINCT USER_ID,HA_PARENT_PAYLOAD_ID
372: FROM ASG_SYSTEM_DIRTY_QUEUE a, ASG_USER b
373: WHERE HA_PARENT_PAYLOAD_ID IS NOT NULL

Line 372: FROM ASG_SYSTEM_DIRTY_QUEUE a, ASG_USER b

368: CSM_UTIL_PKG.LOG
369: ( 'No Pld Track of ASG_SYSTEM_DIRTY_QUEUE' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
370:
371: FOR rec IN (SELECT DISTINCT USER_ID,HA_PARENT_PAYLOAD_ID
372: FROM ASG_SYSTEM_DIRTY_QUEUE a, ASG_USER b
373: WHERE HA_PARENT_PAYLOAD_ID IS NOT NULL
374: AND (DOWNLOAD_FLAG IS NULL OR TRANSACTION_ID IS NULL)
375: AND a.CLIENT_ID=b.USER_NAME)
376: LOOP

Line 377: TRACK_MFS_REC_NO_PLD('ASG_SYSTEM_DIRTY_QUEUE', rec.HA_PARENT_PAYLOAD_ID||','||rec.USER_ID);

373: WHERE HA_PARENT_PAYLOAD_ID IS NOT NULL
374: AND (DOWNLOAD_FLAG IS NULL OR TRANSACTION_ID IS NULL)
375: AND a.CLIENT_ID=b.USER_NAME)
376: LOOP
377: TRACK_MFS_REC_NO_PLD('ASG_SYSTEM_DIRTY_QUEUE', rec.HA_PARENT_PAYLOAD_ID||','||rec.USER_ID);
378: END LOOP;
379:
380: END RECORD_MFS_DATA;
381: