APPS.CZ_PB_SYNC_UTIL dependencies on CZ_DB_SETTINGS

Line 106: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_db_settings'||p_db_link_name ;

102: v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_LINK_NAME_IS_NULL');
103: RETURN FALSE;
104: ELSE
105: ----check if the link is up and active
106: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_db_settings'||p_db_link_name ;
107: LOOP
108: FETCH gl_ref_cursor INTO l_active_count;
109: EXIT WHEN gl_ref_cursor%NOTFOUND;
110: END LOOP;

Line 132: v_source_major_version cz_db_settings.value%TYPE;

128: FUNCTION validate_schema(target_server_id cz_servers.server_local_id%TYPE)
129: RETURN BOOLEAN
130: IS
131:
132: v_source_major_version cz_db_settings.value%TYPE;
133: v_source_minor_version cz_db_settings.value%TYPE;
134: v_target_major_version cz_db_settings.value%TYPE;
135: v_target_minor_version cz_db_settings.value%TYPE;
136: db_schema_compare_cur ref_cursor ;

Line 133: v_source_minor_version cz_db_settings.value%TYPE;

129: RETURN BOOLEAN
130: IS
131:
132: v_source_major_version cz_db_settings.value%TYPE;
133: v_source_minor_version cz_db_settings.value%TYPE;
134: v_target_major_version cz_db_settings.value%TYPE;
135: v_target_minor_version cz_db_settings.value%TYPE;
136: db_schema_compare_cur ref_cursor ;
137: v_db_link cz_servers.fndnam_link_name%TYPE;

Line 134: v_target_major_version cz_db_settings.value%TYPE;

130: IS
131:
132: v_source_major_version cz_db_settings.value%TYPE;
133: v_source_minor_version cz_db_settings.value%TYPE;
134: v_target_major_version cz_db_settings.value%TYPE;
135: v_target_minor_version cz_db_settings.value%TYPE;
136: db_schema_compare_cur ref_cursor ;
137: v_db_link cz_servers.fndnam_link_name%TYPE;
138: v_validate_schema_flg BOOLEAN := TRUE;

Line 135: v_target_minor_version cz_db_settings.value%TYPE;

131:
132: v_source_major_version cz_db_settings.value%TYPE;
133: v_source_minor_version cz_db_settings.value%TYPE;
134: v_target_major_version cz_db_settings.value%TYPE;
135: v_target_minor_version cz_db_settings.value%TYPE;
136: db_schema_compare_cur ref_cursor ;
137: v_db_link cz_servers.fndnam_link_name%TYPE;
138: v_validate_schema_flg BOOLEAN := TRUE;
139: v_count PLS_INTEGER := 0;

Line 152: from cz_db_settings,

148: IF LTRIM(RTRIM(v_db_link)) = '@' THEN
149: v_validate_schema_flg := FALSE;
150: ELSE
151: OPEN db_schema_compare_cur FOR ' select count(*)
152: from cz_db_settings,
153: cz_db_settings'||v_db_link||' tgt
154: where cz_db_settings.setting_id = tgt.setting_id
155: and cz_db_settings.value = tgt.value
156: and cz_db_settings.setting_id = ''MAJOR_VERSION''

Line 153: cz_db_settings'||v_db_link||' tgt

149: v_validate_schema_flg := FALSE;
150: ELSE
151: OPEN db_schema_compare_cur FOR ' select count(*)
152: from cz_db_settings,
153: cz_db_settings'||v_db_link||' tgt
154: where cz_db_settings.setting_id = tgt.setting_id
155: and cz_db_settings.value = tgt.value
156: and cz_db_settings.setting_id = ''MAJOR_VERSION''
157: INTERSECT

Line 154: where cz_db_settings.setting_id = tgt.setting_id

150: ELSE
151: OPEN db_schema_compare_cur FOR ' select count(*)
152: from cz_db_settings,
153: cz_db_settings'||v_db_link||' tgt
154: where cz_db_settings.setting_id = tgt.setting_id
155: and cz_db_settings.value = tgt.value
156: and cz_db_settings.setting_id = ''MAJOR_VERSION''
157: INTERSECT
158: select count(*)

Line 155: and cz_db_settings.value = tgt.value

151: OPEN db_schema_compare_cur FOR ' select count(*)
152: from cz_db_settings,
153: cz_db_settings'||v_db_link||' tgt
154: where cz_db_settings.setting_id = tgt.setting_id
155: and cz_db_settings.value = tgt.value
156: and cz_db_settings.setting_id = ''MAJOR_VERSION''
157: INTERSECT
158: select count(*)
159: from cz_db_settings,

Line 156: and cz_db_settings.setting_id = ''MAJOR_VERSION''

152: from cz_db_settings,
153: cz_db_settings'||v_db_link||' tgt
154: where cz_db_settings.setting_id = tgt.setting_id
155: and cz_db_settings.value = tgt.value
156: and cz_db_settings.setting_id = ''MAJOR_VERSION''
157: INTERSECT
158: select count(*)
159: from cz_db_settings,
160: cz_db_settings'||v_db_link||' tgt

Line 159: from cz_db_settings,

155: and cz_db_settings.value = tgt.value
156: and cz_db_settings.setting_id = ''MAJOR_VERSION''
157: INTERSECT
158: select count(*)
159: from cz_db_settings,
160: cz_db_settings'||v_db_link||' tgt
161: where cz_db_settings.setting_id = tgt.setting_id
162: and cz_db_settings.value = tgt.value
163: and cz_db_settings.setting_id = ''MINOR_VERSION'' ';

Line 160: cz_db_settings'||v_db_link||' tgt

156: and cz_db_settings.setting_id = ''MAJOR_VERSION''
157: INTERSECT
158: select count(*)
159: from cz_db_settings,
160: cz_db_settings'||v_db_link||' tgt
161: where cz_db_settings.setting_id = tgt.setting_id
162: and cz_db_settings.value = tgt.value
163: and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
164: LOOP

Line 161: where cz_db_settings.setting_id = tgt.setting_id

157: INTERSECT
158: select count(*)
159: from cz_db_settings,
160: cz_db_settings'||v_db_link||' tgt
161: where cz_db_settings.setting_id = tgt.setting_id
162: and cz_db_settings.value = tgt.value
163: and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
164: LOOP
165: FETCH db_schema_compare_cur INTO v_count;

Line 162: and cz_db_settings.value = tgt.value

158: select count(*)
159: from cz_db_settings,
160: cz_db_settings'||v_db_link||' tgt
161: where cz_db_settings.setting_id = tgt.setting_id
162: and cz_db_settings.value = tgt.value
163: and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
164: LOOP
165: FETCH db_schema_compare_cur INTO v_count;
166: EXIT WHEN db_schema_compare_cur%NOTFOUND;

Line 163: and cz_db_settings.setting_id = ''MINOR_VERSION'' ';

159: from cz_db_settings,
160: cz_db_settings'||v_db_link||' tgt
161: where cz_db_settings.setting_id = tgt.setting_id
162: and cz_db_settings.value = tgt.value
163: and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
164: LOOP
165: FETCH db_schema_compare_cur INTO v_count;
166: EXIT WHEN db_schema_compare_cur%NOTFOUND;
167: END LOOP;