APPS.CSM_HA_EVENT_PKG dependencies on ASG_BASE

Line 195: ' WHERE SYNC_SESSION_ID IN (SELECT SESSION_ID FROM '||asg_base.G_OLITE_SCHEMA||'.C$SYNC_HISTORY '||

191:
192: l_pk_name_list(1):= 'NOTIFICATION_ID'; l_pk_type_list(1):= 'NUMBER';
193:
194: OPEN cur FOR ' SELECT NOTIFICATION_ID FROM CSM_SYNC_ERROR_NFN_INFO '||
195: ' WHERE SYNC_SESSION_ID IN (SELECT SESSION_ID FROM '||asg_base.G_OLITE_SCHEMA||'.C$SYNC_HISTORY '||
196: ' WHERE START_TIME >= :1)' USING G_HA_START_TIME;
197: LOOP
198: FETCH cur INTO l_pk_value_list(1);
199: EXIT WHEN cur%NOTFOUND;

Line 335: OPEN cur FOR 'SELECT SESSION_ID FROM '||asg_base.G_OLITE_SCHEMA||'.C$SYNC_HISTORY '

331:
332: l_pk_name_list(1):= 'SESSION_ID';
333: l_pk_type_list(1):= 'NUMBER';
334:
335: OPEN cur FOR 'SELECT SESSION_ID FROM '||asg_base.G_OLITE_SCHEMA||'.C$SYNC_HISTORY '
336: ||'WHERE START_TIME >= :1' USING G_HA_START_TIME;
337: LOOP
338: FETCH cur INTO l_pk_value_list(1);
339: EXIT WHEN cur%NOTFOUND;

Line 358: ||asg_base.G_OLITE_SCHEMA||'.C$SYNC_HIS_PUB_ITEMS '

354: l_pk_name_list(1):= 'SESSION_ID'; l_pk_name_list(2):= 'PUB_ITEM'; l_pk_name_list(3):= 'PHASE';
355: l_pk_type_list(1):= 'NUMBER'; l_pk_type_list(2):= 'VARCHAR'; l_pk_type_list(3):= 'VARCHAR';
356:
357: OPEN cur FOR 'SELECT SESSION_ID,PUB_ITEM,PHASE FROM '
358: ||asg_base.G_OLITE_SCHEMA||'.C$SYNC_HIS_PUB_ITEMS '
359: ||'WHERE ROWNUM<2 AND START_TIME >= :1' USING G_HA_START_TIME;
360: LOOP
361: FETCH cur INTO l_pk_value_list(1),l_pk_value_list(2),l_pk_value_list(3);
362: EXIT WHEN cur%NOTFOUND;