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 DUAL

Line 48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;

44: l_xml := DBMS_XMLGEN.getxml (qrycontext);
45: dbms_xmlgen.closeContext(qrycontext);
46: x_XML_PAYLOAD := l_xml;
47:
48: qrycontext := DBMS_XMLGEN.newcontext('SELECT FND_GLOBAL.user_id,FND_GLOBAL.resp_id,FND_GLOBAL.resp_appl_id,FND_GLOBAL.server_id FROM DUAL') ;
49: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
50: l_xml := DBMS_XMLGEN.getxml (qrycontext);
51: dbms_xmlgen.closeContext(qrycontext);
52:

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 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 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 819: execute immediate 'SELECT ' ||l_sequence_list(j) || '.NEXTVAL - '||l_inc_list(j)||' FROM dual'

815: FOR j in 1..l_seq_map_list.COUNT
816: LOOP
817:
818: IF p_action ='R' THEN
819: execute immediate 'SELECT ' ||l_sequence_list(j) || '.NEXTVAL - '||l_inc_list(j)||' FROM dual'
820: INTO l_curr_seq_value;
821:
822: CSM_UTIL_PKG.log( 'RECORD: SESSION_ID: ' || P_SESSION_ID || ' SEQUENCE_NAME: '
823: ||l_sequence_list(j) || ' Sequence Value: ' || l_curr_seq_value,

Line 842: execute immediate 'SELECT ' ||l_sequence_list(j) || '.NEXTVAL FROM dual'

838: AND RECORDED_SEQUENCE < l_curr_seq_value;
839: END;
840:
841: ELSE
842: execute immediate 'SELECT ' ||l_sequence_list(j) || '.NEXTVAL FROM dual'
843: INTO l_curr_seq_value;
844:
845: CSM_UTIL_PKG.log( 'APPLY: SESSION_ID: ' || P_SESSION_ID || ' SEQUENCE_NAME: '
846: ||l_sequence_list(j) || ' Sequence Value: ' || l_curr_seq_value,

Line 863: execute immediate 'SELECT ' ||L_SEQUENCE_LIST(J) || '.NEXTVAL FROM dual'

859: CSM_UTIL_PKG.log(L_SQL_QUERY, 'CSM_HA_EVENT_PKG.SAVE_SEQUENCE', FND_LOG.LEVEL_STATEMENT);
860: execute immediate L_SQL_QUERY;
861:
862: /* This select actually increments the sequence value */
863: execute immediate 'SELECT ' ||L_SEQUENCE_LIST(J) || '.NEXTVAL FROM dual'
864: into L_APPLIED_SEQUENCE_VALUE;
865:
866: CSM_UTIL_PKG.log('Sequence: ' || L_SEQUENCE_LIST(J) ||
867: ' Modified Sequence Value: ' || l_applied_sequence_value,

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