APPS.CSM_HTML5_PKG dependencies on CSM_HTML5_PARSED_DATA

Line 2125: FROM asg_system_dirty_queue a, CSM_HTML5_PARSED_DATA b

2121: last_update_date,
2122: last_updated_by)
2123: SELECT p_user_name, p_pubitem, p_upload_tranid, access_id,b.sequence, l_client_wins,
2124: sysdate, 1, sysdate, 1
2125: FROM asg_system_dirty_queue a, CSM_HTML5_PARSED_DATA b
2126: WHERE client_id = p_user_name AND pub_item = p_pubitem AND
2127: transaction_id is NULL AND a.dml_type = 2
2128: AND b.session_id=p_upload_tranid AND b.piv_name=a.pub_item AND a.access_id=b.pk_value AND b.dml_type='U'
2129: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_CLIENTS_INFO WHERE USER_NAME=p_user_name AND PRF_NAME='COMPREF' AND PRF_VALUE=p_pubitem);

Line 2335: FOR rec IN (SELECT PIV_NAME,COUNT(1) cnt FROM CSM_HTML5_PARSED_DATA

2331: WHERE SESSION_ID = l_session_id;
2332: l_err:= 'w:'||l_session_id;
2333: ELSE
2334: l_dummy:=true;
2335: FOR rec IN (SELECT PIV_NAME,COUNT(1) cnt FROM CSM_HTML5_PARSED_DATA
2336: WHERE SESSION_ID=l_session_id GROUP BY PIV_NAME ORDER BY PIV_NAME)
2337: LOOP
2338: UPDATE_SESSION_DETAILS(l_session_id,rec.PIV_NAME,rec.cnt,l_dummy);
2339: END LOOP;

Line 2341: SELECT COUNT(*) INTO req_id FROM CSM_HTML5_PARSED_DATA

2337: LOOP
2338: UPDATE_SESSION_DETAILS(l_session_id,rec.PIV_NAME,rec.cnt,l_dummy);
2339: END LOOP;
2340:
2341: SELECT COUNT(*) INTO req_id FROM CSM_HTML5_PARSED_DATA
2342: WHERE SESSION_ID=l_session_id AND STATUS='PARSE_ERROR';
2343:
2344: IF req_id > 0 THEN
2345: l_err:= 'w:'||l_session_id; req_id:=0;

Line 2831: INSERT INTO CSM_HTML5_PARSED_DATA(SESSION_ID,SEQUENCE, PIV_NAME, PK_VALUE,

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)
2833: VALUES(P_SYNC_ID,l_seq,L_PIV_NAME,L_ACCESS_ID,L_DML_TYPE,'MOVED_TO_INQ',SYSDATE,L_USER_ID,SYSDATE,L_USER_ID);
2834:
2835: EXCEPTION

Line 2840: INSERT INTO CSM_HTML5_PARSED_DATA(SESSION_ID,SEQUENCE, PIV_NAME, PK_VALUE,

2836: WHEN OTHERS THEN
2837:
2838: X_ERROR_MESSAGE:=SUBSTR(SQLERRM,1,3000);
2839:
2840: INSERT INTO CSM_HTML5_PARSED_DATA(SESSION_ID,SEQUENCE, PIV_NAME, PK_VALUE,
2841: DML_TYPE,PAYLOAD, STATUS,COMMENTS, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY)
2842: VALUES(P_SYNC_ID,l_seq,L_PIV_NAME,L_ACCESS_ID,L_DML_TYPE,PART_XML,'PARSE_ERROR',X_ERROR_MESSAGE,SYSDATE,L_USER_ID,SYSDATE,L_USER_ID);
2843:
2844: END;

Line 3248: DELETE FROM CSM_HTML5_PARSED_DATA a

3244: CSM_UTIL_PKG.log('Purging tranid: ' || curr_tranid, 'CSM_HTML5_PKG.purge_pubitems',FND_LOG.LEVEL_PROCEDURE);
3245: purge_pubitems(p_user_name, curr_tranid, x_return_status);
3246:
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

Line 3259: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_PARSED_DATA a WHERE a.SESSION_ID=b.SESSION_ID);

3255: END IF;
3256:
3257: DELETE FROM CSM_HTML5_UPLOAD_DATA b
3258: WHERE SESSION_ID <= g_current_tranid
3259: AND NOT EXISTS(SELECT 1 FROM CSM_HTML5_PARSED_DATA a WHERE a.SESSION_ID=b.SESSION_ID);
3260: END purge_pubitems;
3261:
3262: PROCEDURE end_client_apply(p_user_name IN VARCHAR2,
3263: x_return_status OUT NOCOPY VARCHAR2)