[Home] [Help]
2189:
2190: CSM_UTIL_PKG.LOG('Entered Process Conflicts for tranid: '||p_upload_tran_id, 'CSM_HTML5_PKG.process_conflicts', FND_LOG.LEVEL_PROCEDURE);
2191:
2192: FOR rec IN (SELECT api.item_id
2193: FROM csm_html5_inq ci, asg_pub_item api
2194: WHERE ci.user_name = p_user_name
2195: AND ci.sync_id = p_upload_tran_id
2196: AND ci.pi_name = api.name
2197: AND api.detect_conflict = 'Y')
2820: END IF;
2821: END IF;
2822:
2823: BEGIN
2824: SELECT 1 INTO dummy FROM csm_html5_inq
2825: WHERE USER_NAME=L_SYNC_USER_NAME AND pi_name=L_PIV_NAME AND SYNC_ID=p_SYNC_ID;
2826: EXCEPTION
2827: WHEN OTHERS THEN
2828: INSERT INTO csm_html5_inq (USER_NAME,PI_NAME,SYNC_ID) VALUES(L_SYNC_USER_NAME,L_PIV_NAME,p_SYNC_ID);
2824: SELECT 1 INTO dummy FROM csm_html5_inq
2825: WHERE USER_NAME=L_SYNC_USER_NAME AND pi_name=L_PIV_NAME AND SYNC_ID=p_SYNC_ID;
2826: EXCEPTION
2827: WHEN OTHERS THEN
2828: INSERT INTO csm_html5_inq (USER_NAME,PI_NAME,SYNC_ID) VALUES(L_SYNC_USER_NAME,L_PIV_NAME,p_SYNC_ID);
2829: END;
2830:
2831: INSERT INTO CSM_HTML5_PARSED_DATA(SESSION_ID,SEQUENCE, PIV_NAME, PK_VALUE,
2832: DML_TYPE, STATUS, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
2907: x_return_status := FND_API.G_RET_STS_SUCCESS;
2908: curr_tranid := p_tranid;
2909:
2910: l_select_inqcnt_sqlstring :=
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 ' ||
2958: counter := 1;
2959: counter2:= 1;
2960: curr_pubitem_length := 0;
2961: l_select_store_sqlstring :=
2962: 'SELECT pi_name FROM CSM_HTML5_INQ ci '||
2963: 'WHERE user_name = :1 AND ' ||
2964: ' sync_id = :2 AND ' ||
2965: ' pi_name in (select item_id from asg_pub_item) '||
2966: ' AND NOT EXISTS (SELECT 1 FROM asg_users_inqarchive ' ||
3155: WHEN OTHERS THEN
3156: CSM_UTIL_PKG.log('Exception executing the SQL Command ' ||SUBSTR(SQLERRM,1,3000), 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3157: END;
3158:
3159: DELETE FROM CSM_HTML5_INQ WHERE USER_NAME=p_user_name AND SYNC_ID=p_tranid AND PI_NAME=curr_pubitem;
3160:
3161: END LOOP;
3162:
3163: IF (l_deferred_trans = TRUE) THEN
3176: p_tranid IN NUMBER,
3177: x_return_status OUT NOCOPY VARCHAR2)
3178: IS
3179: l_pubitems_tbl asg_apply.vc2_tbl_type;
3180: CURSOR l_c IS SELECT PI_NAME FROM CSM_HTML5_INQ WHERE USER_NAME=p_user_name AND SYNC_ID=p_tranid;
3181: BEGIN
3182:
3183: IF ((p_user_name = FND_API.G_MISS_CHAR) OR (p_user_name IS NULL)) OR
3184: ((p_tranid = FND_API.G_MISS_NUM) OR (p_tranid IS NULL)) THEN
3453: IS
3454: counter PLS_INTEGER;
3455: CURSOR l_cursor1 IS
3456: SELECT PI_NAME
3457: FROM CSM_HTML5_INQ a,ASG_PUB_ITEM b
3458: WHERE a.PI_NAME=b.ITEM_ID
3459: AND a.user_name=p_user_name
3460: AND a.SYNC_ID=p_tranid
3461: ORDER BY nvl(b.table_weight,0);
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
3482: WHERE PI_NAME= object_name
3483: AND USER_NAME=device_user_name
3484: AND SYNC_ID=deferred_tran_id)
3485: ORDER BY nvl(b.table_weight,0))
3601: END IF;
3602: END IF;
3603: END LOOP;
3604:
3605: FOR rec IN (SELECT DISTINCT USER_NAME FROM CSM_HTML5_INQ)
3606: LOOP
3607: CSM_HTML5_PKG.process_upload(rec.USER_NAME);
3608: END LOOP;
3609: