APPS.CSM_HA_EVENT_PKG dependencies on ASG_DEFERRED_TRANINFO

Line 218: FROM ASG_DEFERRED_TRANINFO info, ASG_PUB_ITEM pi

214: l_pk_type_list(1):= 'VARCHAR'; l_pk_type_list(2):= 'NUMBER'; l_pk_type_list(3):= 'NUMBER';
215:
216:
217: FOR rec IN (SELECT INQ_OWNER,INQ_NAME, DEVICE_USER_NAME, DEFERRED_TRAN_ID,SEQUENCE
218: FROM ASG_DEFERRED_TRANINFO info, ASG_PUB_ITEM pi
219: WHERE info.OBJECT_NAME = pi.ITEM_ID
220: AND INQ_NAME IS NOT NULL
221: AND info.CREATION_DATE >= G_HA_START_TIME)
222: LOOP

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 278: ( 'Track ASG_DEFERRED_TRANINFO HA records' ,

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:
281:
282:

Line 283: --ASG_DEFERRED_TRANINFO -- 3PKS

279: 'CSM_HA_EVENT_PKG.RECORD_MFS_DATA', FND_LOG.LEVEL_PROCEDURE);
280:
281:
282:
283: --ASG_DEFERRED_TRANINFO -- 3PKS
284:
285: l_pk_name_list.DELETE;l_pk_type_list.DELETE; l_pk_value_list.DELETE;
286: l_pk_name_list.EXTEND(3);l_pk_type_list.EXTEND(3); l_pk_value_list.EXTEND(3);
287:

Line 292: FROM ASG_DEFERRED_TRANINFO

288: l_pk_name_list(1):= 'DEVICE_USER_NAME'; l_pk_name_list(2):= 'DEFERRED_TRAN_ID'; l_pk_name_list(3):= 'SEQUENCE';
289: l_pk_type_list(1):= 'VARCHAR'; l_pk_type_list(2):= 'NUMBER'; l_pk_type_list(3):= 'NUMBER';
290:
291: FOR rec IN (SELECT DEVICE_USER_NAME,DEFERRED_TRAN_ID,SEQUENCE
292: FROM ASG_DEFERRED_TRANINFO
293: WHERE CREATION_DATE >= G_HA_START_TIME)
294: LOOP
295: l_pk_value_list(1):=rec.DEVICE_USER_NAME;
296: l_pk_value_list(2):=rec.DEFERRED_TRAN_ID;

Line 298: TRACK_HA_RECORD('ASG_DEFERRED_TRANINFO',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','Y');

294: LOOP
295: l_pk_value_list(1):=rec.DEVICE_USER_NAME;
296: l_pk_value_list(2):=rec.DEFERRED_TRAN_ID;
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:

Line 1260: ELSIF p_object_name='ASG_DEFERRED_TRANINFO' THEN

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
1263: RETURN 'DEVICE_USER_NAME,TRANID';
1264: ELSIF p_object_name='ASG_USERS_INQARCHIVE' THEN