APPS.ASG_APPLY dependencies on ASG_AUTO_SYNC_TRANIDS

Line 1003: FROM asg_auto_sync_tranids

999: x_return_status OUT NOCOPY VARCHAR2)
1000: IS
1001: CURSOR c_auto_sync_tranid(p_user_name VARCHAR2, p_tranid NUMBER) IS
1002: SELECT sync_id
1003: FROM asg_auto_sync_tranids
1004: WHERE user_name = p_user_name
1005: AND upload_tranid = p_tranid;
1006: l_sync_id NUMBER;
1007:

Line 1017: -- If there is no record in asg_auto_sync_tranids for a particular tranid

1013:
1014: OPEN c_auto_sync_tranid(p_user_name, p_tranid);
1015: FETCH c_auto_sync_tranid into l_sync_id;
1016: IF c_auto_sync_tranid%NOTFOUND OR l_sync_id is null THEN
1017: -- If there is no record in asg_auto_sync_tranids for a particular tranid
1018: -- assume it is NOT auto sync
1019: x_compacted_tranid := p_tranid;
1020: CLOSE c_auto_sync_tranid;
1021: -- Remove the asg_sync_info record

Line 1022: DELETE FROM asg_auto_sync_tranids

1018: -- assume it is NOT auto sync
1019: x_compacted_tranid := p_tranid;
1020: CLOSE c_auto_sync_tranid;
1021: -- Remove the asg_sync_info record
1022: DELETE FROM asg_auto_sync_tranids
1023: WHERE user_name = p_user_name
1024: AND upload_tranid <= x_compacted_tranid;
1025: return;
1026: END IF;

Line 1050: FROM asg_auto_sync_tranids

1046: IS
1047: CURSOR c_end_auto_sync(p_user_name VARCHAR2,
1048: p_tranid NUMBER) IS
1049: SELECT sync_id
1050: FROM asg_auto_sync_tranids
1051: WHERE user_name = p_user_name
1052: AND upload_tranid = p_tranid;
1053:
1054: l_end_tranid NUMBER;

Line 1097: -- Delete from asg_auto_sync_tranids table.

1093: log('process_auto_sync: Processing inq tables');
1094: compact_inqtables(p_user_name, p_tranid, l_end_tranid, l_compact_tranid);
1095:
1096: END IF;
1097: -- Delete from asg_auto_sync_tranids table.
1098:
1099: DELETE FROM asg_auto_sync_tranids
1100: WHERE user_name = p_user_name
1101: AND upload_tranid <= l_end_tranid;

Line 1099: DELETE FROM asg_auto_sync_tranids

1095:
1096: END IF;
1097: -- Delete from asg_auto_sync_tranids table.
1098:
1099: DELETE FROM asg_auto_sync_tranids
1100: WHERE user_name = p_user_name
1101: AND upload_tranid <= l_end_tranid;
1102:
1103: log('process_auto_synch: Done Processing auto sync.');