DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on ASG_USER

Line 257: /* ASG_USER 1-PK */

253: l_pk_name_list(1):= 'CLIENTID'; l_pk_type_list(1):= 'VARCHAR';
254: TRACK_TABLE('MOBILEADMIN.C$ALL_CLIENTS',l_pk_name_list,l_pk_type_list,'Y');
255:
256:
257: /* ASG_USER 1-PK */
258: CSM_UTIL_PKG.LOG
259: ( 'Record ASG_USER' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
260: l_pk_name_list(1):= 'USER_NAME'; l_pk_type_list(1):= 'VARCHAR';
261: TRACK_TABLE('ASG_USER',l_pk_name_list,l_pk_type_list,'Y');

Line 259: ( 'Record ASG_USER' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);

255:
256:
257: /* ASG_USER 1-PK */
258: CSM_UTIL_PKG.LOG
259: ( 'Record ASG_USER' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
260: l_pk_name_list(1):= 'USER_NAME'; l_pk_type_list(1):= 'VARCHAR';
261: TRACK_TABLE('ASG_USER',l_pk_name_list,l_pk_type_list,'Y');
262:
263:

Line 261: TRACK_TABLE('ASG_USER',l_pk_name_list,l_pk_type_list,'Y');

257: /* ASG_USER 1-PK */
258: CSM_UTIL_PKG.LOG
259: ( 'Record ASG_USER' , 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
260: l_pk_name_list(1):= 'USER_NAME'; l_pk_type_list(1):= 'VARCHAR';
261: TRACK_TABLE('ASG_USER',l_pk_name_list,l_pk_type_list,'Y');
262:
263:
264: /* ASG_SEQUENCE_PARTITIONS 2-PK */
265:

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 320: TRACK_HA_RECORD('ASG_USERS_INQARCHIVE',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');

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
324:

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 1258: ELSIF p_object_name='ASG_USER' THEN

1254: ELSIF p_object_name='MOBILEADMIN.C$SYNC_HISTORY' THEN
1255: RETURN 'SESSION_ID';
1256: ELSIF p_object_name='MOBILEADMIN.C$SYNC_HIS_PUB_ITEMS' THEN
1257: RETURN 'SESSION_ID,PUB_ITEM,PHASE';
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

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

Line 1264: ELSIF p_object_name='ASG_USERS_INQARCHIVE' THEN

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
1267: RETURN 'CLIENTID,NAME';
1268: END IF;