APPS.CSM_HTML5_PKG dependencies on CSM_HTML5_AJAX_INFO

Line 926: INSERT INTO csm_html5_ajax_info(AJAX_SESSION_ID,USER_NAME,CREATION_DATE,SYNC_RESPONSE,SYNC_ID)

922: IS
923: PRAGMA AUTONOMOUS_TRANSACTION;
924: BEGIN
925:
926: INSERT INTO csm_html5_ajax_info(AJAX_SESSION_ID,USER_NAME,CREATION_DATE,SYNC_RESPONSE,SYNC_ID)
927: VALUES(csm_html5_ajax_s.NEXTVAL,p_user_name,SYSDATE,p_response,p_sync_id);
928:
929: COMMIT;
930: END create_ajax_session;

Line 1982: delete from csm_html5_ajax_info where creation_date < (sysdate-l_days);

1978:
1979: OPEN c_purge_days;
1980: FETCH c_purge_days INTO l_days;
1981: IF c_purge_days%FOUND AND l_days IS NOT NULL AND l_days>0 THEN
1982: delete from csm_html5_ajax_info where creation_date < (sysdate-l_days);
1983: delete from csm_html5_sync_info where start_date < (sysdate-l_days);
1984: delete from csm_html5_sync_details a where not exists(select 1 from csm_html5_sync_info b where a.session_id=b.session_id);
1985: delete from csm_query_instances_acc
1986: where creation_date < (sysdate-l_days)