APPS.CSM_HA_EVENT_PKG dependencies on ASG_USERS_INQINFO

Line 276: /*Track Specific MFS records in ASG_DEFERRED_TRANINFO, ASG_USERS_INQINFO,ASG_USERS_INQARCHIVE */

272:
273:
274: -----------------TRACK SPECIFIC RECORDS-------------------
275:
276: /*Track Specific MFS records in ASG_DEFERRED_TRANINFO, ASG_USERS_INQINFO,ASG_USERS_INQARCHIVE */
277: CSM_UTIL_PKG.LOG
278: ( 'Track ASG_DEFERRED_TRANINFO HA records' ,
279: 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
280:

Line 301: --ASG_USERS_INQINFO and ASG_USERS_INQARCHIVE --2 PKS

297: l_pk_value_list(3):=rec.SEQUENCE;
298: TRACK_HA_RECORD('ASG_DEFERRED_TRANINFO',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');
299: END LOOP;
300:
301: --ASG_USERS_INQINFO and ASG_USERS_INQARCHIVE --2 PKS
302:
303: CSM_UTIL_PKG.LOG
304: ( 'Track ASG_USERS_INQINFO and ASG_USERS_INQARCHIVE HA records' ,
305: 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);

Line 304: ( 'Track ASG_USERS_INQINFO and ASG_USERS_INQARCHIVE HA records' ,

300:
301: --ASG_USERS_INQINFO and ASG_USERS_INQARCHIVE --2 PKS
302:
303: CSM_UTIL_PKG.LOG
304: ( 'Track ASG_USERS_INQINFO and ASG_USERS_INQARCHIVE HA records' ,
305: 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
306:
307: l_pk_name_list.DELETE;l_pk_type_list.DELETE; l_pk_value_list.DELETE;
308: l_pk_name_list.extend(2);l_pk_type_list.extend(2);l_pk_value_list.extend(2);

Line 314: FROM ASG_USERS_INQINFO

310: l_pk_name_list(1):= 'DEVICE_USER_NAME'; l_pk_name_list(2):= 'TRANID';
311: l_pk_type_list(1):= 'VARCHAR'; l_pk_type_list(2):= 'NUMBER';
312:
313: FOR rec IN (SELECT DEVICE_USER_NAME,TRANID
314: FROM ASG_USERS_INQINFO
315: WHERE CREATION_DATE >= G_HA_START_TIME)
316: LOOP
317: l_pk_value_list(1):=rec.DEVICE_USER_NAME;
318: l_pk_value_list(2):=rec.TRANID;

Line 319: TRACK_HA_RECORD('ASG_USERS_INQINFO',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');

315: WHERE CREATION_DATE >= G_HA_START_TIME)
316: LOOP
317: l_pk_value_list(1):=rec.DEVICE_USER_NAME;
318: l_pk_value_list(2):=rec.TRANID;
319: TRACK_HA_RECORD('ASG_USERS_INQINFO',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');
320: TRACK_HA_RECORD('ASG_USERS_INQARCHIVE',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');
321: END LOOP;
322:
323: --MOBILEADMIN.C$SYNC_HISTORY 1-PK

Line 1262: ELSIF p_object_name='ASG_USERS_INQINFO' THEN

1258: ELSIF p_object_name='ASG_USER' THEN
1259: RETURN 'USER_NAME';
1260: ELSIF p_object_name='ASG_DEFERRED_TRANINFO' THEN
1261: RETURN 'DEVICE_USER_NAME,DEFERRED_TRAN_ID,SEQUENCE';
1262: ELSIF p_object_name='ASG_USERS_INQINFO' THEN
1263: RETURN 'DEVICE_USER_NAME,TRANID';
1264: ELSIF p_object_name='ASG_USERS_INQARCHIVE' THEN
1265: RETURN 'DEVICE_USER_NAME,TRANID';
1266: ELSIF p_object_name='ASG_SEQUENCE_PARTITIONS' THEN