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 CZ_XFR_RUN_INFOS

Line 813: x_run_id CZ_XFR_RUN_INFOS.run_id%type;

809: v_remote_pub_tbl t_publ_tbl;
810: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;
811:
812: lLinkName CZ_SERVERS.fndnam_link_name%type;
813: x_run_id CZ_XFR_RUN_INFOS.run_id%type;
814: x_status CZ_MODEL_PUBLICATIONS.export_status%type;
815:
816: ok_count NUMBER := 0;
817: err_count NUMBER := 0;

Line 921: runId CZ_XFR_RUN_INFOS.RUN_ID%type;

917: p_run_id IN OUT NOCOPY NUMBER, -- DEFAULT NULL
918: p_target_server_id IN NUMBER)
919: IS
920: -- xERROR BOOLEAN := FALSE;
921: runId CZ_XFR_RUN_INFOS.RUN_ID%type;
922: okCount NUMBER := 0;
923: errCount NUMBER := 0;
924: lServerName CZ_SERVERS.local_name%type;
925: lLinkName CZ_SERVERS.fndnam_link_name%type;

Line 936: -- get new run id if not there and insert record in cz_xfr_run_infos

932: WHERE server_local_id = p_target_server_id;
933:
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

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 939: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)

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;
943: ELSE

Line 941: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID = runId);

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
945: runId := p_run_id;

Line 1063: -- get new run id if not there and insert record in cz_xfr_run_infos

1059: -- xError boolean := false;
1060: CURSOR c_get_all_remote_servers IS
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)

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 1067: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)

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);
1070: COMMIT;
1071: OPEN c_get_all_remote_servers;

Line 1069: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=p_run_id);

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
1073: BEGIN

Line 1121: -- get new run id if not there and insert record in cz_xfr_run_infos

1117: -- Check if source server flag is set correctly
1118: IF (ValidateSource(p_source_server_id)) THEN
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;

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 1127: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)

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

Line 1129: (SELECT 1 FROM CZ_XFR_RUN_INFOS WHERE RUN_ID=runId);

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;
1133: -- Delete all deleted publications from source and target