APPS.CSM_HA_EVENT_PKG dependencies on CSM_HA_SESSION_SEQ_VALUES

Line 827: INSERT INTO CSM_HA_SESSION_SEQ_VALUES(SESSION_ID,SEQ_MAPPING_ID,

823: ||l_sequence_list(j) || ' Sequence Value: ' || l_curr_seq_value,
824: 'CSM_HA_EVENT_PKG.SAVE_SEQUENCE', FND_LOG.LEVEL_STATEMENT);
825:
826: BEGIN
827: INSERT INTO CSM_HA_SESSION_SEQ_VALUES(SESSION_ID,SEQ_MAPPING_ID,
828: RECORDED_SEQUENCE,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
829: VALUES(p_session_id,l_seq_map_list(j),l_curr_seq_value,sysdate,1,sysdate,1,1);
830: EXCEPTION
831: WHEN Others THEN

Line 834: UPDATE CSM_HA_SESSION_SEQ_VALUES

830: EXCEPTION
831: WHEN Others THEN
832: CSM_UTIL_PKG.log('Rare Case: Caused by concurrent calls - mostly reported by QA'
833: ,'CSM_HA_EVENT_PKG.SAVE_SEQUENCE', FND_LOG.LEVEL_STATEMENT);
834: UPDATE CSM_HA_SESSION_SEQ_VALUES
835: SET RECORDED_SEQUENCE = l_curr_seq_value
836: WHERE SESSION_ID=p_session_id
837: AND SEQ_MAPPING_ID = L_SEQ_MAP_LIST(J)
838: AND RECORDED_SEQUENCE < l_curr_seq_value;

Line 849: UPDATE CSM_HA_SESSION_SEQ_VALUES

845: CSM_UTIL_PKG.log( 'APPLY: SESSION_ID: ' || P_SESSION_ID || ' SEQUENCE_NAME: '
846: ||l_sequence_list(j) || ' Sequence Value: ' || l_curr_seq_value,
847: 'CSM_HA_EVENT_PKG.SAVE_SEQUENCE', FND_LOG.LEVEL_STATEMENT);
848:
849: UPDATE CSM_HA_SESSION_SEQ_VALUES
850: SET APPLY_SEQUENCE = l_curr_seq_value
851: WHERE SESSION_ID=p_session_id
852: and SEQ_MAPPING_ID = L_SEQ_MAP_LIST(J)
853: RETURNING APPLY_SEQUENCE,RECORDED_SEQUENCE INTO l_start_seq_value,l_end_seq_value;

Line 870: UPDATE CSM_HA_SESSION_SEQ_VALUES

866: CSM_UTIL_PKG.log('Sequence: ' || L_SEQUENCE_LIST(J) ||
867: ' Modified Sequence Value: ' || l_applied_sequence_value,
868: 'CSM_HA_EVENT_PKG.SAVE_SEQUENCE', FND_LOG.LEVEL_STATEMENT);
869:
870: UPDATE CSM_HA_SESSION_SEQ_VALUES
871: set AFTER_APPLY_SEQUENCE = L_APPLIED_SEQUENCE_VALUE
872: WHERE SESSION_ID=p_session_id
873: and SEQ_MAPPING_ID = L_SEQ_MAP_LIST(J);
874: