APPS.CSM_HA_EVENT_PKG dependencies on CSM_HA_PAYLOAD_DATA_S

Line 141: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO l_pld_id FROM DUAL;

137: IS
138: l_pld_id NUMBER;
139: BEGIN
140:
141: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO l_pld_id FROM DUAL;
142:
143: INSERT INTO CSM_HA_PAYLOAD_DATA(HA_PAYLOAD_ID ,OBJECT_NAME, PK_VALUE, PARENT_PAYLOAD_ID,DML_TYPE ,MOBILE_DATA, PROCESSED ,
144: CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE ,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
145: VALUES(l_pld_id,p_TABLE_NAME,p_pk_value,l_pld_id,'I','Y','N',SYSDATE,1,SYSDATE,1,1);

Line 709: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO G_HA_PAYLOAD_SEQUENCE_START FROM DUAL;

705: CSM_UTIL_PKG.LOG('Re-Using session id '||G_HA_SESSION_SEQUENCE||' created by a concurrent race condition.',
706: 'CSM_HA_EVENT_PKG.SET_SESSION', FND_LOG.LEVEL_PROCEDURE);
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

Line 744: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO G_HA_PAYLOAD_SEQUENCE_START FROM DUAL;

740: G_HA_SESSION_SEQUENCE := l_ha_session_id;
741: G_HA_START_TIME := SYSTIMESTAMP;
742: G_HA_END_TIME := NULL;
743:
744: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO G_HA_PAYLOAD_SEQUENCE_START FROM DUAL;
745:
746: G_HA_PAYLOAD_SEQUENCE_END := NULL;
747:
748:

Line 1165: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO G_HA_PAYLOAD_SEQUENCE_END FROM DUAL;

1161: RECORD_MISC_DATA;
1162:
1163: l_module := 'Saving Sequence Values of Business Objects';
1164:
1165: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO G_HA_PAYLOAD_SEQUENCE_END FROM DUAL;
1166:
1167: SAVE_SEQUENCE(G_HA_SESSION_SEQUENCE,'R',G_HA_PAYLOAD_SEQUENCE_START,G_HA_PAYLOAD_SEQUENCE_END);
1168:
1169:

Line 1406: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO l_pld_id FROM DUAL;

1402: RAISE_APPLICATION_ERROR(-20222,'HA Tracking failed : XML Payload is null');
1403: END IF;
1404:
1405:
1406: SELECT CSM_HA_PAYLOAD_DATA_S.nextval INTO l_pld_id FROM DUAL;
1407:
1408: INSERT INTO CSM_HA_PAYLOAD_DATA(HA_PAYLOAD_ID ,OBJECT_NAME , PK_VALUE, PARENT_PAYLOAD_ID,DML_TYPE , PAYLOAD, CONTEXT ,MOBILE_DATA, PROCESSED ,
1409: STATUS ,COMMENTS ,CREATION_DATE , CREATED_BY , LAST_UPDATE_DATE ,LAST_UPDATED_BY,LAST_UPDATE_LOGIN)
1410: VALUES(l_pld_id,p_TABLE_NAME,l_pk_values,NVL(p_parent_payload_id,l_pld_id),p_dml_type,xmltype(l_XML_PAYLOAD),xmltype(l_XML_CONTEXT),p_mobile_data,'N',NULL,NULL,SYSDATE,1,SYSDATE,1,1);