APPS.CZ_UPGRADE dependencies on CZ_DB_SETTINGS

Line 986: v_schema_version cz_db_settings.value%TYPE;

982: FUNCTION get_major_version
983: RETURN VARCHAR2
984: IS
985:
986: v_schema_version cz_db_settings.value%TYPE;
987: BEGIN
988: SELECT value
989: INTO cz_upgrade.v_schema_version
990: FROM cz_db_settings

Line 990: FROM cz_db_settings

986: v_schema_version cz_db_settings.value%TYPE;
987: BEGIN
988: SELECT value
989: INTO cz_upgrade.v_schema_version
990: FROM cz_db_settings
991: WHERE cz_db_settings.setting_id = MAJOR_SCHEMA_VERSION;
992: RETURN cz_upgrade.v_schema_version;
993: EXCEPTION
994: WHEN OTHERS THEN

Line 991: WHERE cz_db_settings.setting_id = MAJOR_SCHEMA_VERSION;

987: BEGIN
988: SELECT value
989: INTO cz_upgrade.v_schema_version
990: FROM cz_db_settings
991: WHERE cz_db_settings.setting_id = MAJOR_SCHEMA_VERSION;
992: RETURN cz_upgrade.v_schema_version;
993: EXCEPTION
994: WHEN OTHERS THEN
995: cz_upgrade.v_schema_version := 0;

Line 1389: v_major_version cz_db_settings.value%TYPE;

1385: v_source_lce_headers_tbl cz_upgrade.t_ref;
1386: v_published_lce_headers_tbl cz_upgrade.t_ref;
1387: x_populate_flag VARCHAR2(1);
1388: x_populate_error VARCHAR2(2000);
1389: v_major_version cz_db_settings.value%TYPE;
1390:
1391:
1392: BEGIN
1393: -----get the existing major version of the schema