APPS.ASG_APPLY dependencies on ASG_USERS_INQARCHIVE

Line 269: -- Update asg_users_inqarchive also

265: tranid >= p_start_tranid AND
266: tranid <= p_end_tranid AND
267: tranid <> p_compact_tranid;
268:
269: -- Update asg_users_inqarchive also
270:
271: -- Get the list of pub-items for this tranid
272: -- This is the list of all publication items uploaded for that tranid
273: l_pubitems_1 := null;

Line 328: UPDATE asg_users_inqarchive

324: END LOOP;
325:
326: log('compact_asginq: Pub-Items to be processed during this auto sync: ' ||
327: l_pubitems_1 || l_pubitems_2);
328: UPDATE asg_users_inqarchive
329: SET pub_items1 = l_pubitems_1, pub_items2 = l_pubitems_2
330: WHERE device_user_name = p_user_name AND
331: tranid = p_compact_tranid;
332:

Line 334: DELETE FROM asg_users_inqarchive

330: WHERE device_user_name = p_user_name AND
331: tranid = p_compact_tranid;
332:
333: -- Remove all records except compact tranID
334: DELETE FROM asg_users_inqarchive
335: WHERE device_user_name = p_user_name AND
336: tranid >= p_start_tranid AND
337: tranid <= p_end_tranid AND
338: tranid <> p_compact_tranid;

Line 435: l_sql:='UPDATE ASG_USERS_INQARCHIVE '||

431: log('compact_curr_inqtable: No of Records Deleted IN C$INQ : ' || l_sql_count);
432:
433: IF l_sql_count>0 THEN
434: BEGIN
435: l_sql:='UPDATE ASG_USERS_INQARCHIVE '||
436: 'SET PUB_ITEMS1=replace(PUB_ITEMS1,'''||p_curr_pubitem||''',''*'||p_curr_pubitem||'''),
437: PUB_ITEMS2=replace(PUB_ITEMS2,'''||p_curr_pubitem||''',''*'||p_curr_pubitem||''') '||
438: 'WHERE DEVICE_USER_NAME=:2 AND TRANID=:3';
439: log('compact_curr_inqtable: SQL Command: ' || l_sql);

Line 1088: -- Process asg_users_inqinfo/asg_users_inqarchive

1084: -- Process c$inq first
1085: log('process_auto_sync: Processing c$inq');
1086: compact_cinq(p_user_name, p_tranid, l_end_tranid, l_compact_tranid);
1087:
1088: -- Process asg_users_inqinfo/asg_users_inqarchive
1089: log('process_auto_sync: Processing asg inq info tables');
1090: compact_asginq(p_user_name, p_tranid, l_end_tranid, l_compact_tranid);
1091:
1092: -- Process inq tables

Line 1503: UPDATE asg_users_inqarchive

1499: curr_tran_processed := caau.processed;
1500: curr_tran_deferred := caau.deferred;
1501: curr_tran_archive := caau.archive;
1502: IF (curr_tran_processed = 'Y') AND (curr_tran_archive = 'Y') THEN
1503: UPDATE asg_users_inqarchive
1504: SET processed = 'Y', deferred = curr_tran_deferred,
1505: last_update_date = SYSDATE, last_updated_by = 1
1506: WHERE device_user_name = p_user_name AND
1507: tranid = curr_tranid;

Line 1840: -- Replace with call to table-handler for asg_users_inqarchive

1836: counter2 := counter2 +1;
1837: END IF;
1838: END LOOP;
1839:
1840: -- Replace with call to table-handler for asg_users_inqarchive
1841: INSERT INTO asg_users_inqarchive (device_user_name,
1842: resource_id,
1843: tranid,
1844: sync_date,

Line 1841: INSERT INTO asg_users_inqarchive (device_user_name,

1837: END IF;
1838: END LOOP;
1839:
1840: -- Replace with call to table-handler for asg_users_inqarchive
1841: INSERT INTO asg_users_inqarchive (device_user_name,
1842: resource_id,
1843: tranid,
1844: sync_date,
1845: processed,