APPS.CZ_PUBL_SYNC_CRASH dependencies on CZ_XFR_RUN_INFOS_S

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