APPS.ASG_CONS_QPKG dependencies on ASG_AUTO_SYNC_TRANIDS

Line 114: insert into asg_auto_sync_tranids

110: p_upload_tranid IN NUMBER)
111: IS
112: PRAGMA AUTONOMOUS_TRANSACTION;
113: BEGIN
114: insert into asg_auto_sync_tranids
115: (user_name, upload_tranid, sync_id,
116: creation_date, created_by, last_update_date, last_updated_by)
117: values
118: (p_user_name, p_upload_tranid, NULL, sysdate,1, sysdate,1);

Line 134: FROM asg_auto_sync_tranids

130: IS --PRAGMA AUTONOMOUS_TRANSACTION;
131: CURSOR c_sync_id(b_user_name VARCHAR2)
132: IS
133: SELECT MAX(upload_tranid)
134: FROM asg_auto_sync_tranids
135: WHERE USER_NAME=b_user_name
136: AND SYNC_ID IS NULL;
137:
138: l_sync_id NUMBER;

Line 156: UPDATE asg_auto_sync_tranids SET SYNC_ID= l_sync_id

152: ELSE
153: l_sync_id:=p_upload_tranid;
154: END IF;
155:
156: UPDATE asg_auto_sync_tranids SET SYNC_ID= l_sync_id
157: WHERE USER_NAME=p_user_name
158: AND SYNC_ID IS NULL;
159: -- COMMIT;
160: