APPS.ASG_APPLY dependencies on ASG_AUTO_SYNC_TRANIDS

Line 1009: FROM asg_auto_sync_tranids

1005: x_return_status OUT NOCOPY VARCHAR2)
1006: IS
1007: CURSOR c_auto_sync_tranid(p_user_name VARCHAR2, p_tranid NUMBER) IS
1008: SELECT sync_id
1009: FROM asg_auto_sync_tranids
1010: WHERE user_name = p_user_name
1011: AND upload_tranid = p_tranid;
1012: l_sync_id NUMBER;
1013:

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

1019:
1020: OPEN c_auto_sync_tranid(p_user_name, p_tranid);
1021: FETCH c_auto_sync_tranid into l_sync_id;
1022: IF c_auto_sync_tranid%NOTFOUND OR l_sync_id is null THEN
1023: -- If there is no record in asg_auto_sync_tranids for a particular tranid
1024: -- assume it is NOT auto sync
1025: x_compacted_tranid := p_tranid;
1026: CLOSE c_auto_sync_tranid;
1027: -- Remove the asg_sync_info record

Line 1028: DELETE FROM asg_auto_sync_tranids

1024: -- assume it is NOT auto sync
1025: x_compacted_tranid := p_tranid;
1026: CLOSE c_auto_sync_tranid;
1027: -- Remove the asg_sync_info record
1028: DELETE FROM asg_auto_sync_tranids
1029: WHERE user_name = p_user_name
1030: AND upload_tranid <= x_compacted_tranid;
1031: return;
1032: END IF;

Line 1056: FROM asg_auto_sync_tranids

1052: IS
1053: CURSOR c_end_auto_sync(p_user_name VARCHAR2,
1054: p_tranid NUMBER) IS
1055: SELECT sync_id
1056: FROM asg_auto_sync_tranids
1057: WHERE user_name = p_user_name
1058: AND upload_tranid = p_tranid;
1059:
1060: l_end_tranid NUMBER;

Line 1103: -- Delete from asg_auto_sync_tranids table.

1099: log('process_auto_sync: Processing inq tables');
1100: compact_inqtables(p_user_name, p_tranid, l_end_tranid, l_compact_tranid);
1101:
1102: END IF;
1103: -- Delete from asg_auto_sync_tranids table.
1104:
1105: DELETE FROM asg_auto_sync_tranids
1106: WHERE user_name = p_user_name
1107: AND upload_tranid <= l_end_tranid;

Line 1105: DELETE FROM asg_auto_sync_tranids

1101:
1102: END IF;
1103: -- Delete from asg_auto_sync_tranids table.
1104:
1105: DELETE FROM asg_auto_sync_tranids
1106: WHERE user_name = p_user_name
1107: AND upload_tranid <= l_end_tranid;
1108:
1109: log('process_auto_synch: Done Processing auto sync.');