APPS.CSM_HA_EVENT_PKG dependencies on CSM_HA_SESSION_INFO

Line 685: SELECT CSM_HA_SESSION_INFO_S.NEXTVAL FROM DUAL;

681: PROCEDURE SET_SESSION(p_create_flag boolean:=true)
682: IS
683: CURSOR c_get_session
684: IS
685: SELECT CSM_HA_SESSION_INFO_S.NEXTVAL FROM DUAL;
686:
687: l_ha_session_id NUMBER;
688: BEGIN
689:

Line 699: FROM CSM_HA_SESSION_INFO

695:
696: BEGIN
697: SELECT session_id,session_start_time,ha_payload_start
698: INTO G_HA_SESSION_SEQUENCE,G_HA_START_TIME,G_HA_PAYLOAD_SEQUENCE_START
699: FROM CSM_HA_SESSION_INFO
700: WHERE SESSION_ID = (SELECT MIN(SESSION_ID) FROM CSM_HA_SESSION_INFO WHERE SESSION_END_TIME IS NULL);
701:
702:
703: IF p_create_flag THEN -- concurrent request case : to reuse existing session

Line 700: WHERE SESSION_ID = (SELECT MIN(SESSION_ID) FROM CSM_HA_SESSION_INFO WHERE SESSION_END_TIME IS NULL);

696: BEGIN
697: SELECT session_id,session_start_time,ha_payload_start
698: INTO G_HA_SESSION_SEQUENCE,G_HA_START_TIME,G_HA_PAYLOAD_SEQUENCE_START
699: FROM CSM_HA_SESSION_INFO
700: WHERE SESSION_ID = (SELECT MIN(SESSION_ID) FROM CSM_HA_SESSION_INFO WHERE SESSION_END_TIME IS NULL);
701:
702:
703: IF p_create_flag THEN -- concurrent request case : to reuse existing session
704:

Line 711: UPDATE CSM_HA_SESSION_INFO

707:
708: G_HA_START_TIME := SYSTIMESTAMP;
709: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO G_HA_PAYLOAD_SEQUENCE_START FROM DUAL;
710:
711: UPDATE CSM_HA_SESSION_INFO
712: SET SESSION_START_TIME=G_HA_START_TIME,
713: HA_PAYLOAD_START=G_HA_PAYLOAD_SEQUENCE_START
714: WHERE SESSION_ID=G_HA_SESSION_SEQUENCE;
715: END IF;

Line 749: INSERT INTO CSM_HA_SESSION_INFO(SESSION_ID, SESSION_START_TIME, SESSION_END_TIME,

745:
746: G_HA_PAYLOAD_SEQUENCE_END := NULL;
747:
748:
749: INSERT INTO CSM_HA_SESSION_INFO(SESSION_ID, SESSION_START_TIME, SESSION_END_TIME,
750: HA_PAYLOAD_START, HA_PAYLOAD_END, STATUS,
751: COMMENTS, CREATION_DATE, CREATED_BY,
752: LAST_UPDATE_DATE, LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
753: VALUES( G_HA_SESSION_SEQUENCE, G_HA_START_TIME, G_HA_END_TIME,

Line 769: SELECT HA_PAYLOAD_START,HA_PAYLOAD_END FROM CSM_HA_SESSION_INFO WHERE SESSION_ID = b_session_id;

765: AS
766:
767: CURSOR c_get_limits(b_session_id NUMBER)
768: IS
769: SELECT HA_PAYLOAD_START,HA_PAYLOAD_END FROM CSM_HA_SESSION_INFO WHERE SESSION_ID = b_session_id;
770:
771: CURSOR c_get_sequences(b_payload_start NUMBER,b_payload_end NUMBER)
772: IS
773: SELECT SEQ_MAPPING_ID,SEQUENCE_OWNER||'.'||SEQUENCE_NAME ,INCREMENT_BY

Line 1040: UPDATE CSM_HA_SESSION_INFO

1036: IS
1037: BEGIN
1038: G_HA_SESSION_SEQUENCE := NULL;
1039:
1040: UPDATE CSM_HA_SESSION_INFO
1041: SET SESSION_END_TIME = SYSTIMESTAMP,
1042: HA_PAYLOAD_END = G_HA_PAYLOAD_SEQUENCE_END,
1043: STATUS = 'COMPLETED',
1044: COMMENTS = 'HA Recording session successfully completed.',

Line 1047: WHERE SESSION_ID = (SELECT MIN(SESSION_ID) FROM CSM_HA_SESSION_INFO WHERE SESSION_END_TIME IS NULL);

1043: STATUS = 'COMPLETED',
1044: COMMENTS = 'HA Recording session successfully completed.',
1045: LAST_UPDATE_DATE = SYSDATE,
1046: LAST_UPDATED_BY = 1
1047: WHERE SESSION_ID = (SELECT MIN(SESSION_ID) FROM CSM_HA_SESSION_INFO WHERE SESSION_END_TIME IS NULL);
1048:
1049: END END_SESSION;
1050:
1051: PROCEDURE BEGIN_HA_TRACKING(x_RETURN_STATUS OUT NOCOPY VARCHAR2,