APPS.CZ_UPGRADE dependencies on CZ_EXT_APPLICATIONS_V

Line 69: v_application_id cz_ext_applications_v.application_id%TYPE;

65: DHTML constant VARCHAR2(3) := '0';
66: v_models_to_be_published devl_project_id_table;
67: v_orig_sys_ref orig_sys_ref_table;
68: v_last_import_date last_import_date_table;
69: v_application_id cz_ext_applications_v.application_id%TYPE;
70: v_to_publish_id cz_model_publications.publication_id%TYPE;
71: v_ui_def_id NUMBER;
72: v_run_id NUMBER;
73: v_ui_def_id_tmp NUMBER;

Line 102: FROM cz_ext_applications_v

98: order by LAST_UPDATE_DATE desc;
99:
100: CURSOR appl_cur(v_preferred_ui_style VARCHAR2) IS
101: SELECT distinct application_id, application_short_name
102: FROM cz_ext_applications_v
103: WHERE preferred_ui_style = v_preferred_ui_style;
104:
105: PROCEDURE get_base_language(x_base_lang OUT NOCOPY VARCHAR2)
106: AS

Line 120: v_application_id cz_ext_applications_v.application_id%TYPE;

116:
117: PROCEDURE insert_publication(p_ui_def_id NUMBER,
118: p_ui_style VARCHAR2,
119: p_models cz_devl_projects.devl_project_id%TYPE) AS
120: v_application_id cz_ext_applications_v.application_id%TYPE;
121: v_application_short_name cz_ext_applications_v.application_short_name%TYPE;
122: BEGIN
123: get_base_language(v_base_language);
124:

Line 121: v_application_short_name cz_ext_applications_v.application_short_name%TYPE;

117: PROCEDURE insert_publication(p_ui_def_id NUMBER,
118: p_ui_style VARCHAR2,
119: p_models cz_devl_projects.devl_project_id%TYPE) AS
120: v_application_id cz_ext_applications_v.application_id%TYPE;
121: v_application_short_name cz_ext_applications_v.application_short_name%TYPE;
122: BEGIN
123: get_base_language(v_base_language);
124:
125: INSERT INTO cz_model_publications(