APPS.ASG_CONS_QPKG dependencies on ASG_AUTO_SYNC_TRANIDS

Line 117: insert into asg_auto_sync_tranids

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

Line 137: FROM asg_auto_sync_tranids

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

Line 159: UPDATE asg_auto_sync_tranids SET SYNC_ID= l_sync_id

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