eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_HA_EVENT_PKG dependencies on CSM_HA_PAYLOAD_DATA

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 143: INSERT INTO CSM_HA_PAYLOAD_DATA(HA_PAYLOAD_ID ,OBJECT_NAME, PK_VALUE, PARENT_PAYLOAD_ID,DML_TYPE ,MOBILE_DATA, PROCESSED ,

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);
146:
147: CSM_HA_AUDIT_PKG.AUDIT_RECORD(l_pld_id,'RECORD');

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 776: FROM CSM_HA_PAYLOAD_DATA

772: IS
773: SELECT SEQ_MAPPING_ID,SEQUENCE_OWNER||'.'||SEQUENCE_NAME ,INCREMENT_BY
774: FROM CSM_HA_SEQ_MAPPINGS
775: WHERE BUSINESS_OBJECT_NAME IN (SELECT OBJECT_NAME
776: FROM CSM_HA_PAYLOAD_DATA
777: WHERE HA_PAYLOAD_ID between b_payload_start AND b_payload_end
778: AND DML_TYPE='I');
779:
780: l_start_seq_value NUMBER;

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 1314: FROM CSM_HA_PAYLOAD_DATA

1310:
1311: BEGIN
1312:
1313: SELECT OBJECT_NAME,PK_VALUE INTO l_bo_name,l_pk_value
1314: FROM CSM_HA_PAYLOAD_DATA
1315: WHERE HA_PAYLOAD_ID=p_parent_payload_id;
1316:
1317: CSM_UTIL_PKG.LOG
1318: ( 'Check for aux with parent payload Id:'||p_parent_payload_id

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);

Line 1408: INSERT INTO CSM_HA_PAYLOAD_DATA(HA_PAYLOAD_ID ,OBJECT_NAME , PK_VALUE, PARENT_PAYLOAD_ID,DML_TYPE , PAYLOAD, CONTEXT ,MOBILE_DATA, PROCESSED ,

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);
1411:
1412: CSM_HA_AUDIT_PKG.AUDIT_RECORD(l_pld_id,'RECORD');

Line 1461: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b

1457: l_last_run_date:= G_HA_START_TIME;
1458: END IF;
1459:
1460: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE > l_last_run_date
1461: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b
1462: WHERE HA_PAYLOAD_ID > G_HA_PAYLOAD_SEQUENCE_START
1463: AND OBJECT_NAME='FND_DOCUMENTS'
1464: AND PK_VALUE=to_char(a.DOCUMENT_ID)
1465: AND DML_TYPE='I'))

Line 1473: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b

1469: END LOOP;
1470:
1471: FOR rec IN (SELECT DOCUMENT_ID FROM FND_DOCUMENTS a WHERE CREATION_DATE < l_last_run_date
1472: AND LAST_UPDATE_DATE > l_last_run_date
1473: AND NOT EXISTS(SELECT 1 FROM CSM_HA_PAYLOAD_DATA b
1474: WHERE HA_PAYLOAD_ID > G_HA_PAYLOAD_SEQUENCE_START
1475: AND OBJECT_NAME='FND_DOCUMENTS'
1476: AND PK_VALUE=to_char(a.DOCUMENT_ID)
1477: AND DML_TYPE='U'))