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.CZ_PUBL_SYNC_CRASH dependencies on DUAL

Line 619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;

615: cz_utils.log_report(pkg_name, 'CREATE_PUBLICATION_DATA', null, ERRBUF, fnd_log.LEVEL_ERROR);
616: END;
617:
618: -- insert
619: SELECT CZ_MODEL_PUBLICATIONS_S.NEXTVAL into lPublicationId from dual;
620: EXECUTE IMMEDIATE
621: ' INSERT INTO cz_model_publications (PUBLICATION_ID ' ||
622: ' ,MODEL_ID ' ||
623: ' ,SERVER_ID ' ||

Line 938: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO runId FROM DUAL;

934: IF (ValidateSource(p_target_server_id)) THEN
935: BEGIN
936: -- get new run id if not there and insert record in cz_xfr_run_infos
937: IF (p_run_id = NULL) THEN
938: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO runId FROM DUAL;
939: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
940: SELECT runId,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
941: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID = runId);
942: COMMIT;

Line 940: SELECT runId,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS

936: -- get new run id if not there and insert record in cz_xfr_run_infos
937: IF (p_run_id = NULL) THEN
938: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO runId FROM DUAL;
939: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
940: SELECT runId,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
941: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID = runId);
942: COMMIT;
943: ELSE
944: -- should have been inserted by SYNC_ALL_SOURCE_CP

Line 1065: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM DUAL;

1061: SELECT server_local_id, local_name FROM CZ_SERVERS;
1062: BEGIN
1063: -- get new run id if not there and insert record in cz_xfr_run_infos
1064: IF (p_run_id = NULL) THEN
1065: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM DUAL;
1066: END IF;
1067: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
1068: SELECT p_run_id,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
1069: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=p_run_id);

Line 1068: SELECT p_run_id,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS

1064: IF (p_run_id = NULL) THEN
1065: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO p_run_id FROM DUAL;
1066: END IF;
1067: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
1068: SELECT p_run_id,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
1069: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=p_run_id);
1070: COMMIT;
1071: OPEN c_get_all_remote_servers;
1072: LOOP

Line 1123: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO runId FROM DUAL;

1119: -- IF (ValidateTarget(p_source_server_id)) THEN
1120: BEGIN
1121: -- get new run id if not there and insert record in cz_xfr_run_infos
1122: IF (p_run_id = NULL) THEN
1123: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO runId FROM DUAL;
1124: ELSE
1125: runId := p_run_id;
1126: END IF;
1127: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)

Line 1128: SELECT runId,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS

1124: ELSE
1125: runId := p_run_id;
1126: END IF;
1127: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
1128: SELECT runId,SYSDATE,SYSDATE,'0' FROM DUAL WHERE NOT EXISTS
1129: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=runId);
1130: IF (inCommitYesNo = 0) THEN
1131: COMMIT;
1132: END IF;