APPS.CZ_PB_SYNC_UTIL dependencies on CZ_DB_SETTINGS

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

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

Line 134: v_source_major_version cz_db_settings.value%TYPE;

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

Line 135: v_source_minor_version cz_db_settings.value%TYPE;

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

Line 136: v_target_major_version cz_db_settings.value%TYPE;

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

Line 137: v_target_minor_version cz_db_settings.value%TYPE;

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

Line 154: from cz_db_settings,

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

Line 155: cz_db_settings'||v_db_link||' tgt

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

Line 156: where cz_db_settings.setting_id = tgt.setting_id

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

Line 157: and cz_db_settings.value = tgt.value

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

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

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

Line 161: from cz_db_settings,

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

Line 162: cz_db_settings'||v_db_link||' tgt

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

Line 163: where cz_db_settings.setting_id = tgt.setting_id

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

Line 164: and cz_db_settings.value = tgt.value

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

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

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