APPS.CSM_HTML5_PKG dependencies on ASG_DEFERRED_TRANINFO

Line 3109: ||'and not exists (SELECT 1 FROM asg_deferred_traninfo WHERE device_user_name = a.clid$$cs AND deferred_tran_id = a.tranid$$ and sequence=a.seqno$$ AND object_name ='''

3105: CLOSE c_pk;
3106:
3107: IF l_pk IS NOT NULL THEN --this functionality is not there in usual ppc/laptop
3108: OPEN c_cur FOR 'SELECT DMLTYPE$$,SEQNO$$ ,to_char('||l_pk||') FROM '||inq_tbl_name||' a WHERE clid$$cs='''||p_user_name||''' and TRANID$$='||p_tranid
3109: ||'and not exists (SELECT 1 FROM asg_deferred_traninfo WHERE device_user_name = a.clid$$cs AND deferred_tran_id = a.tranid$$ and sequence=a.seqno$$ AND object_name ='''
3110: ||curr_pubitem||''')';
3111: LOOP
3112: FETCH c_cur INTO l_dml,l_seq,l_pk;
3113: EXIT WHEN c_cur%NOTFOUND;

Line 3120: sql_string := 'INSERT INTO asg_deferred_traninfo ('||

3116: END IF;
3117:
3118: -- Defer those records that were not already deferred or deleted during
3119: -- processing by wrapper
3120: sql_string := 'INSERT INTO asg_deferred_traninfo ('||
3121: 'DEVICE_USER_NAME, ' ||
3122: 'RESOURCE_ID, ' ||
3123: 'DEFERRED_TRAN_ID, ' ||
3124: 'MOBILE_ERROR_ID, ' ||

Line 3140: 'FROM asg_deferred_traninfo ' ||

3136: ' FROM '|| inq_tbl_name ||
3137: ' b WHERE b.clid$$cs = :5 AND ' ||
3138: ' tranid$$ = :6 AND ' ||
3139: ' b.seqno$$ not in (SELECT sequence ' ||
3140: 'FROM asg_deferred_traninfo ' ||
3141: 'WHERE device_user_name = :7 AND ' ||
3142: ' deferred_tran_id = :8 '||
3143: ' AND object_name = :9)';
3144: BEGIN

Line 3207: FROM asg_deferred_traninfo

3203: WHERE device_user_name = p_user_name AND
3204: tranid = p_tranid AND
3205: tranid not IN
3206: (SELECT distinct deferred_tran_id
3207: FROM asg_deferred_traninfo
3208: WHERE device_user_name = p_user_name AND
3209: deferred_tran_id = p_tranid);
3210:
3211: END purge_pubitems;

Line 3251: AND NOT EXISTS (SELECT 1 FROM asg_deferred_traninfo b

3247: --Purge xml upload dump tables
3248: DELETE FROM CSM_HTML5_PARSED_DATA a
3249: WHERE A.SESSION_ID=curr_tranid
3250: AND a.status='MOVED_TO_INQ'
3251: AND NOT EXISTS (SELECT 1 FROM asg_deferred_traninfo b
3252: WHERE a.session_id=b.DEFERRED_TRAN_ID
3253: AND a.sequence=b.sequence); --reject record requires the data if deferred
3254: END LOOP;
3255: END IF;

Line 3477: FROM asg_deferred_traninfo a,asg_pub_item b

3473: l_n:=x_pubitems_tbl.count;
3474: IF l_n >0 THEN l_dummy:=true; END IF;
3475:
3476: FOR REC IN (SELECT object_name
3477: FROM asg_deferred_traninfo a,asg_pub_item b
3478: WHERE device_user_name = p_user_name
3479: AND deferred_tran_id = p_tranid
3480: AND b.item_id=a.object_name
3481: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_INQ

Line 3517: FROM asg_deferred_traninfo

3513: l_orig_app_id NUMBER;
3514:
3515: CURSOR c_deferred_processed (p_user_name VARCHAR2, p_tranid NUMBER) IS
3516: SELECT count(*) count
3517: FROM asg_deferred_traninfo
3518: WHERE device_user_name = p_user_name AND
3519: deferred_tran_id = p_tranid AND
3520: status <> 0;
3521: BEGIN