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_SERVERS

Line 25: lServerName CZ_SERVERS.local_name%type;

21:
22: FUNCTION validateServer(p_server_id IN NUMBER)
23: RETURN BOOLEAN
24: IS
25: lServerName CZ_SERVERS.local_name%type;
26: lLinkName CZ_SERVERS.fndnam_link_name%type;
27: lHostName CZ_SERVERS.HOSTNAME%type;
28: lSid CZ_SERVERS.INSTANCE_NAME%type;
29: lHost CZ_SERVERS.HOSTNAME%type;

Line 26: lLinkName CZ_SERVERS.fndnam_link_name%type;

22: FUNCTION validateServer(p_server_id IN NUMBER)
23: RETURN BOOLEAN
24: IS
25: lServerName CZ_SERVERS.local_name%type;
26: lLinkName CZ_SERVERS.fndnam_link_name%type;
27: lHostName CZ_SERVERS.HOSTNAME%type;
28: lSid CZ_SERVERS.INSTANCE_NAME%type;
29: lHost CZ_SERVERS.HOSTNAME%type;
30: x_server_f BOOLEAN := FALSE;

Line 27: lHostName CZ_SERVERS.HOSTNAME%type;

23: RETURN BOOLEAN
24: IS
25: lServerName CZ_SERVERS.local_name%type;
26: lLinkName CZ_SERVERS.fndnam_link_name%type;
27: lHostName CZ_SERVERS.HOSTNAME%type;
28: lSid CZ_SERVERS.INSTANCE_NAME%type;
29: lHost CZ_SERVERS.HOSTNAME%type;
30: x_server_f BOOLEAN := FALSE;
31: CURSOR c_get_server IS

Line 28: lSid CZ_SERVERS.INSTANCE_NAME%type;

24: IS
25: lServerName CZ_SERVERS.local_name%type;
26: lLinkName CZ_SERVERS.fndnam_link_name%type;
27: lHostName CZ_SERVERS.HOSTNAME%type;
28: lSid CZ_SERVERS.INSTANCE_NAME%type;
29: lHost CZ_SERVERS.HOSTNAME%type;
30: x_server_f BOOLEAN := FALSE;
31: CURSOR c_get_server IS
32: SELECT local_name, fndnam_link_name FROM CZ_SERVERS

Line 29: lHost CZ_SERVERS.HOSTNAME%type;

25: lServerName CZ_SERVERS.local_name%type;
26: lLinkName CZ_SERVERS.fndnam_link_name%type;
27: lHostName CZ_SERVERS.HOSTNAME%type;
28: lSid CZ_SERVERS.INSTANCE_NAME%type;
29: lHost CZ_SERVERS.HOSTNAME%type;
30: x_server_f BOOLEAN := FALSE;
31: CURSOR c_get_server IS
32: SELECT local_name, fndnam_link_name FROM CZ_SERVERS
33: WHERE server_local_id = p_server_id;

Line 32: SELECT local_name, fndnam_link_name FROM CZ_SERVERS

28: lSid CZ_SERVERS.INSTANCE_NAME%type;
29: lHost CZ_SERVERS.HOSTNAME%type;
30: x_server_f BOOLEAN := FALSE;
31: CURSOR c_get_server IS
32: SELECT local_name, fndnam_link_name FROM CZ_SERVERS
33: WHERE server_local_id = p_server_id;
34: BEGIN
35:
36: BEGIN

Line 38: ' SELECT fndnam_link_name,local_name, hostname FROM CZ_SERVERS WHERE server_local_id = :1'

34: BEGIN
35:
36: BEGIN
37: EXECUTE IMMEDIATE
38: ' SELECT fndnam_link_name,local_name, hostname FROM CZ_SERVERS WHERE server_local_id = :1'
39: INTO lLinkName, lServerName, lHostName
40: USING p_server_id ;
41: EXCEPTION
42: WHEN NO_DATA_FOUND THEN

Line 93: lServerName CZ_SERVERS.local_name%type;

89:
90: FUNCTION verifyServer(p_link_name IN VARCHAR2)
91: RETURN BOOLEAN
92: IS
93: lServerName CZ_SERVERS.local_name%type;
94: lLinkName CZ_SERVERS.fndnam_link_name%type;
95: lHostName CZ_SERVERS.HOSTNAME%type;
96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;
97: lSid CZ_SERVERS.INSTANCE_NAME%type;

Line 94: lLinkName CZ_SERVERS.fndnam_link_name%type;

90: FUNCTION verifyServer(p_link_name IN VARCHAR2)
91: RETURN BOOLEAN
92: IS
93: lServerName CZ_SERVERS.local_name%type;
94: lLinkName CZ_SERVERS.fndnam_link_name%type;
95: lHostName CZ_SERVERS.HOSTNAME%type;
96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;
97: lSid CZ_SERVERS.INSTANCE_NAME%type;
98: lHost CZ_SERVERS.HOSTNAME%type;

Line 95: lHostName CZ_SERVERS.HOSTNAME%type;

91: RETURN BOOLEAN
92: IS
93: lServerName CZ_SERVERS.local_name%type;
94: lLinkName CZ_SERVERS.fndnam_link_name%type;
95: lHostName CZ_SERVERS.HOSTNAME%type;
96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;
97: lSid CZ_SERVERS.INSTANCE_NAME%type;
98: lHost CZ_SERVERS.HOSTNAME%type;
99: x_server_f BOOLEAN := FALSE;

Line 96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;

92: IS
93: lServerName CZ_SERVERS.local_name%type;
94: lLinkName CZ_SERVERS.fndnam_link_name%type;
95: lHostName CZ_SERVERS.HOSTNAME%type;
96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;
97: lSid CZ_SERVERS.INSTANCE_NAME%type;
98: lHost CZ_SERVERS.HOSTNAME%type;
99: x_server_f BOOLEAN := FALSE;
100:

Line 97: lSid CZ_SERVERS.INSTANCE_NAME%type;

93: lServerName CZ_SERVERS.local_name%type;
94: lLinkName CZ_SERVERS.fndnam_link_name%type;
95: lHostName CZ_SERVERS.HOSTNAME%type;
96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;
97: lSid CZ_SERVERS.INSTANCE_NAME%type;
98: lHost CZ_SERVERS.HOSTNAME%type;
99: x_server_f BOOLEAN := FALSE;
100:
101: BEGIN

Line 98: lHost CZ_SERVERS.HOSTNAME%type;

94: lLinkName CZ_SERVERS.fndnam_link_name%type;
95: lHostName CZ_SERVERS.HOSTNAME%type;
96: lInstanceName CZ_SERVERS.INSTANCE_NAME%type;
97: lSid CZ_SERVERS.INSTANCE_NAME%type;
98: lHost CZ_SERVERS.HOSTNAME%type;
99: x_server_f BOOLEAN := FALSE;
100:
101: BEGIN
102:

Line 105: ' SELECT local_name, hostname, instance_name FROM CZ_SERVERS' || p_link_name ||

101: BEGIN
102:
103: BEGIN
104: EXECUTE IMMEDIATE
105: ' SELECT local_name, hostname, instance_name FROM CZ_SERVERS' || p_link_name ||
106: ' WHERE source_server_flag = ''1'''
107: INTO lServerName,lHostName, lInstanceName;
108: EXCEPTION
109: WHEN NO_DATA_FOUND THEN

Line 149: lServerId CZ_SERVERS.server_local_id%type;

145: FUNCTION checkIfSource(p_server_id IN NUMBER)
146: RETURN BOOLEAN
147: IS
148:
149: lServerId CZ_SERVERS.server_local_id%type;
150: rServerId CZ_SERVERS.server_local_id%type;
151: lServerName CZ_SERVERS.local_name%type;
152: lName CZ_SERVERS.local_name%type;
153: x_source_server_f BOOLEAN := FALSE;

Line 150: rServerId CZ_SERVERS.server_local_id%type;

146: RETURN BOOLEAN
147: IS
148:
149: lServerId CZ_SERVERS.server_local_id%type;
150: rServerId CZ_SERVERS.server_local_id%type;
151: lServerName CZ_SERVERS.local_name%type;
152: lName CZ_SERVERS.local_name%type;
153: x_source_server_f BOOLEAN := FALSE;
154:

Line 151: lServerName CZ_SERVERS.local_name%type;

147: IS
148:
149: lServerId CZ_SERVERS.server_local_id%type;
150: rServerId CZ_SERVERS.server_local_id%type;
151: lServerName CZ_SERVERS.local_name%type;
152: lName CZ_SERVERS.local_name%type;
153: x_source_server_f BOOLEAN := FALSE;
154:
155: CURSOR c_source_servers IS

Line 152: lName CZ_SERVERS.local_name%type;

148:
149: lServerId CZ_SERVERS.server_local_id%type;
150: rServerId CZ_SERVERS.server_local_id%type;
151: lServerName CZ_SERVERS.local_name%type;
152: lName CZ_SERVERS.local_name%type;
153: x_source_server_f BOOLEAN := FALSE;
154:
155: CURSOR c_source_servers IS
156: SELECT local_name FROM CZ_SERVERS

Line 156: SELECT local_name FROM CZ_SERVERS

152: lName CZ_SERVERS.local_name%type;
153: x_source_server_f BOOLEAN := FALSE;
154:
155: CURSOR c_source_servers IS
156: SELECT local_name FROM CZ_SERVERS
157: WHERE source_server_flag = '1'
158: AND server_local_id = p_server_id;
159:
160: str varchar2(255);

Line 167: select fndnam_link_name into lName from CZ_SERVERS

163: FETCH c_source_servers INTO lServerName;
164: x_source_server_f:= c_source_servers%FOUND;
165: close c_source_servers;
166: */
167: select fndnam_link_name into lName from CZ_SERVERS
168: WHERE server_local_id = p_server_id;
169:
170: IF (lName is not NULL) THEN
171: lName := '@' || lName;

Line 172: EXECUTE IMMEDIATE 'SELECT local_name, server_local_id FROM CZ_SERVERS' || lName ||

168: WHERE server_local_id = p_server_id;
169:
170: IF (lName is not NULL) THEN
171: lName := '@' || lName;
172: EXECUTE IMMEDIATE 'SELECT local_name, server_local_id FROM CZ_SERVERS' || lName ||
173: ' WHERE source_server_flag = ''1'' '
174: INTO lServerName, rServerId;
175:
176: -- if (NOT(x_source_server_f)) then

Line 332: lServerName CZ_SERVERS.local_name%type;

328: IS
329: -- xERROR BOOLEAN := FALSE;
330: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
331: --lPublicationIds tPublicationIds;
332: lServerName CZ_SERVERS.local_name%type;
333: lLinkName CZ_SERVERS.fndnam_link_name%type;
334: lTargetServerId CZ_SERVERS.server_local_id%type;
335: lSid CZ_SERVERS.instance_name%type;
336: lHostName CZ_SERVERS.hostname%type;

Line 333: lLinkName CZ_SERVERS.fndnam_link_name%type;

329: -- xERROR BOOLEAN := FALSE;
330: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
331: --lPublicationIds tPublicationIds;
332: lServerName CZ_SERVERS.local_name%type;
333: lLinkName CZ_SERVERS.fndnam_link_name%type;
334: lTargetServerId CZ_SERVERS.server_local_id%type;
335: lSid CZ_SERVERS.instance_name%type;
336: lHostName CZ_SERVERS.hostname%type;
337: x_server_f BOOLEAN := FALSE;

Line 334: lTargetServerId CZ_SERVERS.server_local_id%type;

330: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
331: --lPublicationIds tPublicationIds;
332: lServerName CZ_SERVERS.local_name%type;
333: lLinkName CZ_SERVERS.fndnam_link_name%type;
334: lTargetServerId CZ_SERVERS.server_local_id%type;
335: lSid CZ_SERVERS.instance_name%type;
336: lHostName CZ_SERVERS.hostname%type;
337: x_server_f BOOLEAN := FALSE;
338:

Line 335: lSid CZ_SERVERS.instance_name%type;

331: --lPublicationIds tPublicationIds;
332: lServerName CZ_SERVERS.local_name%type;
333: lLinkName CZ_SERVERS.fndnam_link_name%type;
334: lTargetServerId CZ_SERVERS.server_local_id%type;
335: lSid CZ_SERVERS.instance_name%type;
336: lHostName CZ_SERVERS.hostname%type;
337: x_server_f BOOLEAN := FALSE;
338:
339: TYPE t_publ_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 336: lHostName CZ_SERVERS.hostname%type;

332: lServerName CZ_SERVERS.local_name%type;
333: lLinkName CZ_SERVERS.fndnam_link_name%type;
334: lTargetServerId CZ_SERVERS.server_local_id%type;
335: lSid CZ_SERVERS.instance_name%type;
336: lHostName CZ_SERVERS.hostname%type;
337: x_server_f BOOLEAN := FALSE;
338:
339: TYPE t_publ_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
340: v_deleted_pub_tbl t_publ_tbl;

Line 348: SELECT fndnam_link_name, server_local_id INTO lLinkName, lServerName FROM CZ_SERVERS

344: v_publication_id CZ_MODEL_PUBLICATIONS.publication_id%type;
345:
346: BEGIN
347:
348: SELECT fndnam_link_name, server_local_id INTO lLinkName, lServerName FROM CZ_SERVERS
349: WHERE server_local_id = p_server_id;
350:
351: IF (lLinkName <> NULL) THEN
352: lLinkName := '@' || LTRIM(RTRIM(lLinkName));

Line 407: FROM CZ_SERVERS

403: -- Delete all history for this target on the source.
404:
405: SELECT hostname, instance_name
406: INTO lHostName, lSid
407: FROM CZ_SERVERS
408: WHERE server_local_id = '0';
409:
410: EXECUTE IMMEDIATE
411: 'SELECT SERVER_LOCAL_ID FROM CZ_SERVERS' || lLinkName ||

Line 411: 'SELECT SERVER_LOCAL_ID FROM CZ_SERVERS' || lLinkName ||

407: FROM CZ_SERVERS
408: WHERE server_local_id = '0';
409:
410: EXECUTE IMMEDIATE
411: 'SELECT SERVER_LOCAL_ID FROM CZ_SERVERS' || lLinkName ||
412: ' INTO ' || lTargetServerId ||
413: ' WHERE hostname = ' || lHostName ||
414: ' AND instance_name = ' || lSid;
415:

Line 536: lServerName CZ_SERVERS.local_name%type;

532: IS
533: -- xERROR BOOLEAN := FALSE;
534: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
535: --lPublicationIds tPublicationIds;
536: lServerName CZ_SERVERS.local_name%type;
537: lLinkName CZ_SERVERS.fndnam_link_name%type;
538: x_server_f BOOLEAN := FALSE;
539:
540: n_source_model_id cz_ps_nodes.ps_node_id%type;

Line 537: lLinkName CZ_SERVERS.fndnam_link_name%type;

533: -- xERROR BOOLEAN := FALSE;
534: --TYPE tPublicationIds IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
535: --lPublicationIds tPublicationIds;
536: lServerName CZ_SERVERS.local_name%type;
537: lLinkName CZ_SERVERS.fndnam_link_name%type;
538: x_server_f BOOLEAN := FALSE;
539:
540: n_source_model_id cz_ps_nodes.ps_node_id%type;
541: n_source_ui_def_id cz_ui_nodes.ui_def_id%type;

Line 551: SELECT fndnam_link_name INTO lLinkName FROM CZ_SERVERS

547: v_pub_tbl t_publ_tbl;
548:
549: BEGIN
550:
551: SELECT fndnam_link_name INTO lLinkName FROM CZ_SERVERS
552: WHERE server_local_id = p_target_server_id;
553:
554: IF (lLinkName is NOT NULL) THEN
555: lLinkName := '@' || LTRIM(RTRIM(lLinkName));

Line 730: lLinkName CZ_SERVERS.fndnam_link_name%type;

726: item_type_val number;
727: ps_node_val number;
728: ui_node_val number;
729:
730: lLinkName CZ_SERVERS.fndnam_link_name%type;
731: WRONG_INCR exception;
732:
733: BEGIN
734:

Line 736: ' SELECT fndnam_link_name FROM CZ_SERVERS WHERE server_local_id = :1'

732:
733: BEGIN
734:
735: EXECUTE IMMEDIATE
736: ' SELECT fndnam_link_name FROM CZ_SERVERS WHERE server_local_id = :1'
737: INTO lLinkName
738: USING p_target_server ;
739:
740: IF (lLinkName <> NULL) THEN

Line 812: lLinkName CZ_SERVERS.fndnam_link_name%type;

808: v_pub_tbl t_publ_tbl;
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;

Line 822: SELECT fndnam_link_name INTO lLinkName FROM CZ_SERVERS

818: lStartDate DATE := sysdate;
819: lEndDate DATE := sysdate;
820: BEGIN
821:
822: SELECT fndnam_link_name INTO lLinkName FROM CZ_SERVERS
823: WHERE server_local_id = p_source_server;
824:
825: IF (lLinkName <> NULL) THEN
826: lLinkName := '@' || LTRIM(RTRIM(lLinkName));

Line 889: lLinkName CZ_SERVERS.FNDNAM_LINK_NAME%TYPE;

885: FUNCTION ValidateSource(p_target_server_id IN NUMBER)
886: RETURN BOOLEAN
887: IS
888:
889: lLinkName CZ_SERVERS.FNDNAM_LINK_NAME%TYPE;
890: BEGIN
891:
892: if (checkIfSource(p_target_server_id)) then
893: -- if(validateServer(p_target_server_id)) then

Line 924: lServerName CZ_SERVERS.local_name%type;

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;
926:
927: BEGIN
928: SET_DBMS_INFO(pbSourceCrash);

Line 925: lLinkName CZ_SERVERS.fndnam_link_name%type;

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;
926:
927: BEGIN
928: SET_DBMS_INFO(pbSourceCrash);
929:

Line 931: FROM CZ_SERVERS

927: BEGIN
928: SET_DBMS_INFO(pbSourceCrash);
929:
930: SELECT local_name,fndnam_link_name INTO lServerName, lLinkName
931: FROM CZ_SERVERS
932: WHERE server_local_id = p_target_server_id;
933:
934: IF (ValidateSource(p_target_server_id)) THEN
935: BEGIN

Line 1057: l_server_id CZ_SERVERS.server_local_id%type;

1053: PROCEDURE SYNC_ALL_SOURCE_CP (ERRNO IN OUT NOCOPY NUMBER,
1054: ERRBUF IN OUT NOCOPY VARCHAR2,
1055: p_run_id IN OUT NOCOPY NUMBER)
1056: IS
1057: l_server_id CZ_SERVERS.server_local_id%type;
1058: l_server_name CZ_SERVERS.local_name%type;
1059: -- xError boolean := false;
1060: CURSOR c_get_all_remote_servers IS
1061: SELECT server_local_id, local_name FROM CZ_SERVERS;

Line 1058: l_server_name CZ_SERVERS.local_name%type;

1054: ERRBUF IN OUT NOCOPY VARCHAR2,
1055: p_run_id IN OUT NOCOPY NUMBER)
1056: IS
1057: l_server_id CZ_SERVERS.server_local_id%type;
1058: l_server_name CZ_SERVERS.local_name%type;
1059: -- xError boolean := false;
1060: CURSOR c_get_all_remote_servers IS
1061: SELECT server_local_id, local_name FROM CZ_SERVERS;
1062: BEGIN

Line 1061: SELECT server_local_id, local_name FROM CZ_SERVERS;

1057: l_server_id CZ_SERVERS.server_local_id%type;
1058: l_server_name CZ_SERVERS.local_name%type;
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;

Line 1098: lServerName CZ_SERVERS.local_name%type;

1094: p_commitYesNo IN NUMBER DEFAULT 0)
1095: IS
1096: okCount NUMBER := 0;
1097: errCount NUMBER := 0;
1098: lServerName CZ_SERVERS.local_name%type;
1099: lLinkName CZ_SERVERS.fndnam_link_name%type;
1100: inSourceServerId CZ_SERVERS.server_local_id%type;
1101: inDate DATE;
1102: inCommitYesNo NUMBER;

Line 1099: lLinkName CZ_SERVERS.fndnam_link_name%type;

1095: IS
1096: okCount NUMBER := 0;
1097: errCount NUMBER := 0;
1098: lServerName CZ_SERVERS.local_name%type;
1099: lLinkName CZ_SERVERS.fndnam_link_name%type;
1100: inSourceServerId CZ_SERVERS.server_local_id%type;
1101: inDate DATE;
1102: inCommitYesNo NUMBER;
1103: runId NUMBER;

Line 1100: inSourceServerId CZ_SERVERS.server_local_id%type;

1096: okCount NUMBER := 0;
1097: errCount NUMBER := 0;
1098: lServerName CZ_SERVERS.local_name%type;
1099: lLinkName CZ_SERVERS.fndnam_link_name%type;
1100: inSourceServerId CZ_SERVERS.server_local_id%type;
1101: inDate DATE;
1102: inCommitYesNo NUMBER;
1103: runId NUMBER;
1104: BEGIN

Line 1114: FROM CZ_SERVERS

1110: inDate := p_date;
1111: inCommitYesNo := p_commitYesNo;
1112:
1113: SELECT local_name,fndnam_link_name INTO lServerName, lLinkName
1114: FROM CZ_SERVERS
1115: WHERE server_local_id = p_source_server_id;
1116:
1117: -- Check if source server flag is set correctly
1118: IF (ValidateSource(p_source_server_id)) THEN

Line 1150: -- The selected Target's tns details do not match with that in CZ_SERVERS

1146: END IF;
1147: **/
1148: ELSE
1149: ERRNO := czError;
1150: -- The selected Target's tns details do not match with that in CZ_SERVERS
1151: ERRBUF := CZ_UTILS.GET_TEXT('CZ_INCORRECT_TARGET');
1152: cz_utils.log_report(pkg_name, 'SYNC_TARGET_CP', null, ERRBUF, fnd_log.LEVEL_ERROR);
1153: END IF;
1154: IF (inCommitYesNo = 0) THEN

Line 1245: lHost CZ_SERVERS.hostname%type;

1241:
1242: FUNCTION ValidateTarget(p_server_id IN NUMBER)
1243: RETURN BOOLEAN
1244: IS
1245: lHost CZ_SERVERS.hostname%type;
1246: lSid CZ_SERVERS.instance_name%type;
1247: lLinkName CZ_SERVERS.fndnam_link_name%type;
1248: lHostName CZ_SERVERS.hostname%type;
1249: lServerName CZ_SERVERS.instance_name%type;

Line 1246: lSid CZ_SERVERS.instance_name%type;

1242: FUNCTION ValidateTarget(p_server_id IN NUMBER)
1243: RETURN BOOLEAN
1244: IS
1245: lHost CZ_SERVERS.hostname%type;
1246: lSid CZ_SERVERS.instance_name%type;
1247: lLinkName CZ_SERVERS.fndnam_link_name%type;
1248: lHostName CZ_SERVERS.hostname%type;
1249: lServerName CZ_SERVERS.instance_name%type;
1250: BEGIN

Line 1247: lLinkName CZ_SERVERS.fndnam_link_name%type;

1243: RETURN BOOLEAN
1244: IS
1245: lHost CZ_SERVERS.hostname%type;
1246: lSid CZ_SERVERS.instance_name%type;
1247: lLinkName CZ_SERVERS.fndnam_link_name%type;
1248: lHostName CZ_SERVERS.hostname%type;
1249: lServerName CZ_SERVERS.instance_name%type;
1250: BEGIN
1251:

Line 1248: lHostName CZ_SERVERS.hostname%type;

1244: IS
1245: lHost CZ_SERVERS.hostname%type;
1246: lSid CZ_SERVERS.instance_name%type;
1247: lLinkName CZ_SERVERS.fndnam_link_name%type;
1248: lHostName CZ_SERVERS.hostname%type;
1249: lServerName CZ_SERVERS.instance_name%type;
1250: BEGIN
1251:
1252: SELECT fndnam_link_name INTO lLinkName

Line 1249: lServerName CZ_SERVERS.instance_name%type;

1245: lHost CZ_SERVERS.hostname%type;
1246: lSid CZ_SERVERS.instance_name%type;
1247: lLinkName CZ_SERVERS.fndnam_link_name%type;
1248: lHostName CZ_SERVERS.hostname%type;
1249: lServerName CZ_SERVERS.instance_name%type;
1250: BEGIN
1251:
1252: SELECT fndnam_link_name INTO lLinkName
1253: FROM CZ_SERVERS

Line 1253: FROM CZ_SERVERS

1249: lServerName CZ_SERVERS.instance_name%type;
1250: BEGIN
1251:
1252: SELECT fndnam_link_name INTO lLinkName
1253: FROM CZ_SERVERS
1254: WHERE server_local_id = p_server_id;
1255:
1256: IF (lLinkName <> NULL) THEN
1257: lLinkName := '@' || lLinkName;

Line 1262: ' FROM CZ_SERVERS'|| lLinkName ||

1258: END IF;
1259:
1260: EXECUTE IMMEDIATE
1261: ' SELECT hostname, instance_name INTO ' || lHost || ',' || lSid ||
1262: ' FROM CZ_SERVERS'|| lLinkName ||
1263: ' WHERE source_server_flag = ''1''';
1264:
1265: SELECT INSTANCE_NAME, HOST_NAME INTO lServerName,lHostName from v$instance;
1266: IF ((upper(lSid) = upper(lServerName)) and (upper(lHost) = upper(lHostName))) THEN

Line 1288: lServerName CZ_SERVERS.local_name%type;

1284: p_date IN DATE)
1285: IS
1286: okCount NUMBER := 0;
1287: errCount NUMBER := 0;
1288: lServerName CZ_SERVERS.local_name%type;
1289: BEGIN
1290: SYNC_TARGET_CP(ERRNO,ERRBUF,p_run_id,p_source_server_id,p_date,1);
1291: END;
1292: ------------------------------------------------------------------------------------------