APPS.CSM_HTML5_PKG dependencies on ASG_DEFER

Line 1948: PRAGMA AUTONOMOUS_TRANSACTION; --required for asg_defer to work as it's a pragma-a-t and not finding inq info data

1944: END disable_pi;
1945:
1946: PROCEDURE PURGE_HTML5_DATA(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)
1947: IS
1948: PRAGMA AUTONOMOUS_TRANSACTION; --required for asg_defer to work as it's a pragma-a-t and not finding inq info data
1949: l_sqlerrno VARCHAR2(20);
1950: l_sqlerrmsg VARCHAR2(4000);
1951: l_error_msg VARCHAR2(4000);
1952: l_return_status VARCHAR2(2000);

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

Line 3525: l_def_trans := asg_defer.is_deferred(p_user_name, p_tranid);

3521: BEGIN
3522:
3523: CSM_UTIL_PKG.LOG( 'Reapply started for user:'||p_user_name ||' tranid:'||p_tranid, 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);
3524: -- Check if this transaction is deferred
3525: l_def_trans := asg_defer.is_deferred(p_user_name, p_tranid);
3526: IF l_def_trans = FND_API.G_FALSE THEN
3527: CSM_UTIL_PKG.LOG( 'Leaving since tranid is not deferred', 'CSM_HTML5_PKG.reapply_transaction',FND_LOG.LEVEL_PROCEDURE);
3528: x_return_status := FND_API.G_RET_STS_ERROR;
3529: return;