APPS.CSM_HTML5_PKG dependencies on ASG_USERS_INQINFO

Line 2915: 'AND NOT EXISTS (SELECT 1 FROM asg_users_inqinfo ' ||

2911: 'SELECT count(*) FROM CSM_HTML5_INQ ci ' ||
2912: 'WHERE user_name = :1 AND ' ||
2913: ' sync_id = :2 AND ' ||
2914: ' pi_name in (select item_id from asg_pub_item) ' ||
2915: 'AND NOT EXISTS (SELECT 1 FROM asg_users_inqinfo ' ||
2916: ' WHERE device_user_name = ci.user_name AND TRANID =ci.sync_id) ' ;
2917:
2918: EXECUTE IMMEDIATE l_select_inqcnt_sqlstring INTO l_inq_count USING p_user_name, p_tranid;
2919:

Line 2931: INSERT INTO asg_users_inqinfo (device_user_name,

2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: return;
2929: END IF;
2930:
2931: INSERT INTO asg_users_inqinfo (device_user_name,
2932: resource_id,
2933: tranid,
2934: sync_date,
2935: processed,

Line 3164: UPDATE asg_users_inqinfo

3160:
3161: END LOOP;
3162:
3163: IF (l_deferred_trans = TRUE) THEN
3164: UPDATE asg_users_inqinfo
3165: SET deferred = 'Y', processed = 'I',
3166: last_update_date = SYSDATE, last_updated_by = 1
3167: WHERE device_user_name = p_user_name AND
3168: tranid = p_tranid;

Line 3201: UPDATE asg_users_inqinfo

3197: purge_pubitems(p_user_name, p_tranid, l_pubitems_tbl, x_return_status);
3198: END IF;
3199:
3200: -- If no deferred rows, set processed = 'Y'
3201: UPDATE asg_users_inqinfo
3202: SET processed = 'Y', last_update_date=SYSDATE, last_updated_by=1
3203: WHERE device_user_name = p_user_name AND
3204: tranid = p_tranid AND
3205: tranid not IN

Line 3223: SELECT tranid FROM asg_users_inqinfo

3219: counter PLS_INTEGER;
3220: curr_tranid NUMBER;
3221: l_tranid_tbl asg_apply.num_tbl_type;
3222: cursor c_tranids (p_user_name VARCHAR2, p_max_tranid NUMBER) IS
3223: SELECT tranid FROM asg_users_inqinfo
3224: WHERE device_user_name = p_user_name AND
3225: tranid <= p_max_tranid;
3226: BEGIN
3227: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

Line 3271: FROM asg_users_inqinfo

3267: curr_tran_deferred VARCHAR2(1);
3268: curr_tran_archive VARCHAR2(1);
3269: CURSOR c_archive_asg_users(p_user_name VARCHAR2) IS
3270: SELECT tranid, processed, deferred, archive
3271: FROM asg_users_inqinfo
3272: WHERE device_user_name = p_user_name;
3273: BEGIN
3274:
3275: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) THEN

Line 3298: DELETE FROM asg_users_inqinfo

3294: tranid = curr_tranid;
3295: END IF;
3296: END LOOP;
3297:
3298: DELETE FROM asg_users_inqinfo
3299: WHERE device_user_name = p_user_name AND processed = 'Y';
3300:
3301: --COMMIT;
3302:

Line 3311: FROM asg_users_inqinfo a

3307: x_return_status OUT NOCOPY VARCHAR2)
3308: IS
3309: CURSOR c_first_tran (p_user_name VARCHAR2) IS
3310: SELECT min(tranid) tran_id
3311: FROM asg_users_inqinfo a
3312: WHERE a.device_user_name = p_user_name AND
3313: a.deferred='N'
3314: AND a.tranid <=
3315: (SELECT nvl(hwm_tranid,1000000000000)

Line 3344: FROM asg_users_inqinfo a

3340: x_return_status OUT NOCOPY VARCHAR2)
3341: IS
3342: CURSOR c_next_tran (p_user_name VARCHAR2, p_tranid VARCHAR2) IS
3343: SELECT min(tranid) tran_id
3344: FROM asg_users_inqinfo a
3345: WHERE tranid > p_tranid
3346: AND a.device_user_name = p_user_name AND a.deferred='N'
3347: AND a.tranid <= (SELECT nvl(hwm_tranid,1000000000000)
3348: FROM asg_user WHERE user_name=a.device_user_name);

Line 3562: UPDATE asg_users_inqinfo

3558: FETCH c_deferred_processed INTO l_def_count;
3559: CLOSE c_deferred_processed;
3560: -- All the deferred records are processed
3561: IF l_def_count = 0 THEN
3562: UPDATE asg_users_inqinfo
3563: SET deferred = 'S'
3564: WHERE device_user_name = p_user_name AND
3565: tranid = p_tranid;
3566: END IF;