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_PB_MGR dependencies on CZ_UI_PAGES

Line 160: g_cz_ui_pages_ui_def_ref.DELETE;

156: v_language_id_tbl.DELETE;
157: cz_pb_mgr.g_item_type_id := 0;
158: cz_pb_mgr.g_item_id := 0;
159: g_object_type := ' ';
160: g_cz_ui_pages_ui_def_ref.DELETE;
161: g_cz_ui_pages_jrad_doc_ref.DELETE;
162: g_cz_ui_pages_capt_id_ref.DELETE;
163: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
164: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;

Line 161: g_cz_ui_pages_jrad_doc_ref.DELETE;

157: cz_pb_mgr.g_item_type_id := 0;
158: cz_pb_mgr.g_item_id := 0;
159: g_object_type := ' ';
160: g_cz_ui_pages_ui_def_ref.DELETE;
161: g_cz_ui_pages_jrad_doc_ref.DELETE;
162: g_cz_ui_pages_capt_id_ref.DELETE;
163: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
164: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
165: g_cz_ui_pages_ui_def_tbl.DELETE;

Line 162: g_cz_ui_pages_capt_id_ref.DELETE;

158: cz_pb_mgr.g_item_id := 0;
159: g_object_type := ' ';
160: g_cz_ui_pages_ui_def_ref.DELETE;
161: g_cz_ui_pages_jrad_doc_ref.DELETE;
162: g_cz_ui_pages_capt_id_ref.DELETE;
163: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
164: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
165: g_cz_ui_pages_ui_def_tbl.DELETE;
166: g_cz_ui_pages_jrad_doc_tbl.DELETE;

Line 165: g_cz_ui_pages_ui_def_tbl.DELETE;

161: g_cz_ui_pages_jrad_doc_ref.DELETE;
162: g_cz_ui_pages_capt_id_ref.DELETE;
163: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
164: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
165: g_cz_ui_pages_ui_def_tbl.DELETE;
166: g_cz_ui_pages_jrad_doc_tbl.DELETE;
167: g_cz_ui_pages_capt_id_tbl.DELETE;
168: g_page_sets_ui_old_ref.DELETE;
169: g_page_sets_ui_ref.DELETE;

Line 166: g_cz_ui_pages_jrad_doc_tbl.DELETE;

162: g_cz_ui_pages_capt_id_ref.DELETE;
163: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
164: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
165: g_cz_ui_pages_ui_def_tbl.DELETE;
166: g_cz_ui_pages_jrad_doc_tbl.DELETE;
167: g_cz_ui_pages_capt_id_tbl.DELETE;
168: g_page_sets_ui_old_ref.DELETE;
169: g_page_sets_ui_ref.DELETE;
170: g_page_sets_pg_tbl.DELETE;

Line 167: g_cz_ui_pages_capt_id_tbl.DELETE;

163: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
164: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
165: g_cz_ui_pages_ui_def_tbl.DELETE;
166: g_cz_ui_pages_jrad_doc_tbl.DELETE;
167: g_cz_ui_pages_capt_id_tbl.DELETE;
168: g_page_sets_ui_old_ref.DELETE;
169: g_page_sets_ui_ref.DELETE;
170: g_page_sets_pg_tbl.DELETE;
171: cz_pb_mgr.v_ui_images_ui_ref.DELETE;

Line 4102: FROM cz_ui_pages

4098: END IF;
4099:
4100: SELECT jrad_doc
4101: BULK COLLECT INTO l_jrad_doc_tbl
4102: FROM cz_ui_pages
4103: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';
4104:
4105: IF (l_jrad_doc_tbl.COUNT > 0)
4106: THEN

Line 4103: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';

4099:
4100: SELECT jrad_doc
4101: BULK COLLECT INTO l_jrad_doc_tbl
4102: FROM cz_ui_pages
4103: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';
4104:
4105: IF (l_jrad_doc_tbl.COUNT > 0)
4106: THEN
4107: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || p_link_name || ' WHERE publication_id='||cz_pb_mgr.v_publication_id||' ; commit; end; ';

Line 4484: -----collect from cz_ui_pages

4480: RAISE;
4481: END insert_into_repository;
4482:
4483: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4484: -----collect from cz_ui_pages
4485: PROCEDURE bulk_collect_ui_pages
4486: IS
4487: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
4488: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;

Line 4487: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;

4483: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
4484: -----collect from cz_ui_pages
4485: PROCEDURE bulk_collect_ui_pages
4486: IS
4487: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
4488: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
4489: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
4490: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;

Line 4488: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;

4484: -----collect from cz_ui_pages
4485: PROCEDURE bulk_collect_ui_pages
4486: IS
4487: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
4488: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
4489: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
4490: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;

Line 4489: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;

4485: PROCEDURE bulk_collect_ui_pages
4486: IS
4487: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
4488: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
4489: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
4490: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;

Line 4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;

4488: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
4489: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
4490: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
4494: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
4495: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
4496: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;

Line 4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;

4489: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
4490: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
4494: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
4495: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
4496: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
4497: l_rec_count NUMBER;

Line 4494: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;

4490: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
4494: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
4495: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
4496: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
4497: l_rec_count NUMBER;
4498: BEGIN

Line 4495: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;

4491: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
4494: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
4495: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
4496: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
4497: l_rec_count NUMBER;
4498: BEGIN
4499: pbdebug := 22029;

Line 4496: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;

4492: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
4493: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
4494: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
4495: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
4496: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
4497: l_rec_count NUMBER;
4498: BEGIN
4499: pbdebug := 22029;
4500:

Line 4503: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;

4499: pbdebug := 22029;
4500:
4501: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4502: THEN
4503: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
4504: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
4505: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
4506: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
4507: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;

Line 4504: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;

4500:
4501: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4502: THEN
4503: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
4504: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
4505: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
4506: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
4507: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
4508: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;

Line 4505: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;

4501: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
4502: THEN
4503: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
4504: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
4505: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
4506: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
4507: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
4508: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
4509: -- cz_pb_mgr.v_intl_text_model_tbl.DELETE;

Line 4510: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;

4506: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
4507: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
4508: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
4509: -- cz_pb_mgr.v_intl_text_model_tbl.DELETE;
4510: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;
4511: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
4512: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
4513: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;

Line 4511: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;

4507: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
4508: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
4509: -- cz_pb_mgr.v_intl_text_model_tbl.DELETE;
4510: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;
4511: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
4512: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
4513: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
4515: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;

Line 4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;

4510: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;
4511: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
4512: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
4513: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
4515: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
4516: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
4517:
4518: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST

Line 4515: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;

4511: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
4512: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
4513: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
4515: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
4516: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
4517:
4518: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST
4519: LOOP

Line 4516: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;

4512: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
4513: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
4514: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
4515: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
4516: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
4517:
4518: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST
4519: LOOP
4520: l_cz_ui_pages_ui_def_tbl.DELETE;

Line 4520: l_cz_ui_pages_ui_def_tbl.DELETE;

4516: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
4517:
4518: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST
4519: LOOP
4520: l_cz_ui_pages_ui_def_tbl.DELETE;
4521: l_cz_ui_pages_jrad_doc_tbl.DELETE;
4522: l_cz_ui_pages_capt_id_tbl.DELETE;
4523: l_cz_page_stat_templ_tbl.DELETE;
4524: l_cz_page_stat_uidef_tbl.DELETE;

Line 4521: l_cz_ui_pages_jrad_doc_tbl.DELETE;

4517:
4518: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST
4519: LOOP
4520: l_cz_ui_pages_ui_def_tbl.DELETE;
4521: l_cz_ui_pages_jrad_doc_tbl.DELETE;
4522: l_cz_ui_pages_capt_id_tbl.DELETE;
4523: l_cz_page_stat_templ_tbl.DELETE;
4524: l_cz_page_stat_uidef_tbl.DELETE;
4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;

Line 4522: l_cz_ui_pages_capt_id_tbl.DELETE;

4518: FOR uidef IN cz_pb_mgr.v_cz_ui_defs_old_oa_ref.FIRST .. cz_pb_mgr.v_cz_ui_defs_old_oa_ref.LAST
4519: LOOP
4520: l_cz_ui_pages_ui_def_tbl.DELETE;
4521: l_cz_ui_pages_jrad_doc_tbl.DELETE;
4522: l_cz_ui_pages_capt_id_tbl.DELETE;
4523: l_cz_page_stat_templ_tbl.DELETE;
4524: l_cz_page_stat_uidef_tbl.DELETE;
4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;
4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;

Line 4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;

4521: l_cz_ui_pages_jrad_doc_tbl.DELETE;
4522: l_cz_ui_pages_capt_id_tbl.DELETE;
4523: l_cz_page_stat_templ_tbl.DELETE;
4524: l_cz_page_stat_uidef_tbl.DELETE;
4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;
4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;
4527: l_cz_ui_pages_dis_cond_tbl.DELETE;
4528: l_cz_ui_pages_enb_cond_tbl.DELETE;
4529: l_cz_ui_pages_expl_node_tbl.DELETE;

Line 4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;

4522: l_cz_ui_pages_capt_id_tbl.DELETE;
4523: l_cz_page_stat_templ_tbl.DELETE;
4524: l_cz_page_stat_uidef_tbl.DELETE;
4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;
4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;
4527: l_cz_ui_pages_dis_cond_tbl.DELETE;
4528: l_cz_ui_pages_enb_cond_tbl.DELETE;
4529: l_cz_ui_pages_expl_node_tbl.DELETE;
4530:

Line 4527: l_cz_ui_pages_dis_cond_tbl.DELETE;

4523: l_cz_page_stat_templ_tbl.DELETE;
4524: l_cz_page_stat_uidef_tbl.DELETE;
4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;
4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;
4527: l_cz_ui_pages_dis_cond_tbl.DELETE;
4528: l_cz_ui_pages_enb_cond_tbl.DELETE;
4529: l_cz_ui_pages_expl_node_tbl.DELETE;
4530:
4531: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id

Line 4528: l_cz_ui_pages_enb_cond_tbl.DELETE;

4524: l_cz_page_stat_uidef_tbl.DELETE;
4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;
4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;
4527: l_cz_ui_pages_dis_cond_tbl.DELETE;
4528: l_cz_ui_pages_enb_cond_tbl.DELETE;
4529: l_cz_ui_pages_expl_node_tbl.DELETE;
4530:
4531: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
4532: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id

Line 4529: l_cz_ui_pages_expl_node_tbl.DELETE;

4525: l_cz_ui_pages_pgtmplid_tbl.DELETE;
4526: l_cz_ui_pages_pgtmplui_tbl.DELETE;
4527: l_cz_ui_pages_dis_cond_tbl.DELETE;
4528: l_cz_ui_pages_enb_cond_tbl.DELETE;
4529: l_cz_ui_pages_expl_node_tbl.DELETE;
4530:
4531: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
4532: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
4533: ,enabled_condition_id, pagebase_expl_node_id

Line 4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl

4530:
4531: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
4532: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
4533: ,enabled_condition_id, pagebase_expl_node_id
4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl
4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl
4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;

Line 4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl

4531: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
4532: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
4533: ,enabled_condition_id, pagebase_expl_node_id
4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl
4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl
4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;
4539:

Line 4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl

4532: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
4533: ,enabled_condition_id, pagebase_expl_node_id
4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl
4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl
4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;
4539:
4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)

Line 4537: FROM cz_ui_pages

4533: ,enabled_condition_id, pagebase_expl_node_id
4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl
4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl
4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;
4539:
4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
4541: THEN

Line 4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;

4534: BULK COLLECT INTO l_cz_ui_pages_ui_def_tbl, l_cz_ui_pages_jrad_doc_tbl, l_cz_ui_pages_capt_id_tbl, l_cz_page_stat_templ_tbl
4535: ,l_cz_page_stat_uidef_tbl, l_cz_ui_pages_pgtmplid_tbl, l_cz_ui_pages_pgtmplui_tbl, l_cz_ui_pages_dis_cond_tbl
4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;
4539:
4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
4541: THEN
4542: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;

Line 4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)

4536: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
4537: FROM cz_ui_pages
4538: WHERE cz_ui_pages.ui_def_id = cz_pb_mgr.v_cz_ui_defs_old_oa_ref(uidef) AND cz_ui_pages.deleted_flag = record_not_deleted;
4539:
4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
4541: THEN
4542: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;
4543:
4544: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST

Line 4544: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST

4540: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
4541: THEN
4542: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;
4543:
4544: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST
4545: LOOP
4546: l_rec_count := l_rec_count + 1;
4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

Line 4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

4543:
4544: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST
4545: LOOP
4546: l_rec_count := l_rec_count + 1;
4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

Line 4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

4544: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST
4545: LOOP
4546: l_rec_count := l_rec_count + 1;
4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);

Line 4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);

4545: LOOP
4546: l_rec_count := l_rec_count + 1;
4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);

Line 4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);

4546: l_rec_count := l_rec_count + 1;
4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);

Line 4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

4547: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;

Line 4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);

4548: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);

Line 4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);

4549: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);

Line 4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);

4550: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
4551: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);

Line 4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);

4552: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
4559: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
4560: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);

Line 4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);

4553: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
4559: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
4560: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
4561: END LOOP;

Line 4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);

4554: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
4559: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
4560: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
4561: END LOOP;
4562: END IF;

Line 4559: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);

4555: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
4559: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
4560: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
4561: END LOOP;
4562: END IF;
4563: END LOOP;

Line 4560: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);

4556: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
4557: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
4558: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
4559: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
4560: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
4561: END LOOP;
4562: END IF;
4563: END LOOP;
4564: END IF;

Line 4571: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_pages', 'SQLERRM', SQLERRM);

4567: THEN
4568: NULL;
4569: WHEN OTHERS
4570: THEN
4571: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_pages', 'SQLERRM', SQLERRM);
4572: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGES', SQLCODE);
4573: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
4574: RAISE;
4575: END bulk_collect_ui_pages;

Line 4578: -------insert into cz_ui_pages

4574: RAISE;
4575: END bulk_collect_ui_pages;
4576:
4577: -------------------------------------------------------------------------
4578: -------insert into cz_ui_pages
4579: PROCEDURE insert_into_ui_pages
4580: IS
4581: rec_count NUMBER := 0;
4582: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 4589: resolve_ids(cz_pb_mgr.g_pages_ui_def_old_ref,cz_pb_mgr.g_cz_ui_pages_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui pages');

4585:
4586: IF (cz_pb_mgr.g_pages_ui_def_old_ref.COUNT > 0)
4587: THEN
4588: ----resolve ui_def_id of ui pages
4589: resolve_ids(cz_pb_mgr.g_pages_ui_def_old_ref,cz_pb_mgr.g_cz_ui_pages_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui pages');
4590:
4591: -- resolve page status and outer page templates
4592: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');

Line 4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');

4589: resolve_ids(cz_pb_mgr.g_pages_ui_def_old_ref,cz_pb_mgr.g_cz_ui_pages_ui_def_ref, cz_pb_mgr.v_cz_ui_defs_idx_ref, 'ui def ids of ui pages');
4590:
4591: -- resolve page status and outer page templates
4592: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');
4594: resolve_ids(cz_pb_mgr.g_cz_ui_pages_stat_templ, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'pg stat templs of ui pages', ENTITY_TYPE_UCT);
4595: resolve_tmpl_ui_defs(g_cz_uipg_tmplui_tbl, g_cz_uipg_tmplui_tbl,g_cz_uipg_tmplid_tbl, v_cz_ui_defs_idx_ref, 'outer pg templ uidefs of ui pages');
4596: resolve_ids(cz_pb_mgr.g_cz_uipg_tmplid_tbl, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'outer page tmpl id of ui pages', ENTITY_TYPE_UCT);
4597: END IF;

Line 4594: resolve_ids(cz_pb_mgr.g_cz_ui_pages_stat_templ, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'pg stat templs of ui pages', ENTITY_TYPE_UCT);

4590:
4591: -- resolve page status and outer page templates
4592: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
4593: resolve_tmpl_ui_defs(g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_ui, g_cz_ui_pages_stat_templ, v_cz_ui_defs_idx_ref, 'pg status templ uidefs of ui pages');
4594: resolve_ids(cz_pb_mgr.g_cz_ui_pages_stat_templ, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'pg stat templs of ui pages', ENTITY_TYPE_UCT);
4595: resolve_tmpl_ui_defs(g_cz_uipg_tmplui_tbl, g_cz_uipg_tmplui_tbl,g_cz_uipg_tmplid_tbl, v_cz_ui_defs_idx_ref, 'outer pg templ uidefs of ui pages');
4596: resolve_ids(cz_pb_mgr.g_cz_uipg_tmplid_tbl, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'outer page tmpl id of ui pages', ENTITY_TYPE_UCT);
4597: END IF;
4598:

Line 4600: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');

4596: resolve_ids(cz_pb_mgr.g_cz_uipg_tmplid_tbl, cz_pb_mgr.g_ui_templates_idx_temp_ref, 'outer page tmpl id of ui pages', ENTITY_TYPE_UCT);
4597: END IF;
4598:
4599: ----caption ids of ui pages
4600: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
4601:
4602: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
4603: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');

Line 4602: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');

4598:
4599: ----caption ids of ui pages
4600: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
4601:
4602: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
4603: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;

Line 4603: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');

4599: ----caption ids of ui pages
4600: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
4601:
4602: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
4603: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;
4607: plsql_table_list(rec_count).col_name := 'ui_def_id';

Line 4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');

4600: resolve_intl_texts(cz_pb_mgr.g_cz_ui_pages_capt_id_ref, cz_pb_mgr.v_cz_intl_text_idx_ref, 'caption ids of cz ui pages');
4601:
4602: resolve_ids(cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'disabled condition of ui pages');
4603: resolve_ids(cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl, cz_pb_mgr.v_cz_rules_rule_id_idx_ref, 'enabled condition of ui pages');
4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;
4607: plsql_table_list(rec_count).col_name := 'ui_def_id';
4608: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';

Line 4608: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';

4604: resolve_ids(cz_pb_mgr.g_cz_ui_pages_expl_tbl, cz_pb_mgr.v_cz_model_ref_expls_idx_ref, 'expl node id of ui pages');
4605: plsql_table_list.DELETE;
4606: rec_count := 1;
4607: plsql_table_list(rec_count).col_name := 'ui_def_id';
4608: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';
4609: rec_count := rec_count + 1;
4610: plsql_table_list(rec_count).col_name := 'jrad_doc';
4611: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';
4612: rec_count := rec_count + 1;

Line 4611: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';

4607: plsql_table_list(rec_count).col_name := 'ui_def_id';
4608: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';
4609: rec_count := rec_count + 1;
4610: plsql_table_list(rec_count).col_name := 'jrad_doc';
4611: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';
4612: rec_count := rec_count + 1;
4613: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPLATE_ID';
4614: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';
4615: rec_count := rec_count + 1;

Line 4614: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';

4610: plsql_table_list(rec_count).col_name := 'jrad_doc';
4611: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';
4612: rec_count := rec_count + 1;
4613: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPLATE_ID';
4614: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';
4615: rec_count := rec_count + 1;
4616: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPL_UIDEF_ID';
4617: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_ui';
4618: rec_count := rec_count + 1;

Line 4617: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_ui';

4613: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPLATE_ID';
4614: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';
4615: rec_count := rec_count + 1;
4616: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPL_UIDEF_ID';
4617: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_ui';
4618: rec_count := rec_count + 1;
4619: plsql_table_list(rec_count).col_name := 'OUTER_PAGE_TEMPLATE_ID';
4620: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_uipg_tmplid_tbl';
4621: rec_count := rec_count + 1;

Line 4626: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl';

4622: plsql_table_list(rec_count).col_name := 'OUTER_PAGE_TEMPL_UIDEF_ID';
4623: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_uipg_tmplui_tbl';
4624: rec_count := rec_count + 1;
4625: plsql_table_list(rec_count).col_name := 'DISPLAY_CONDITION_ID';
4626: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl';
4627: rec_count := rec_count + 1;
4628: plsql_table_list(rec_count).col_name := 'ENABLED_CONDITION_ID';
4629: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';
4630: rec_count := rec_count + 1;

Line 4629: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';

4625: plsql_table_list(rec_count).col_name := 'DISPLAY_CONDITION_ID';
4626: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl';
4627: rec_count := rec_count + 1;
4628: plsql_table_list(rec_count).col_name := 'ENABLED_CONDITION_ID';
4629: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';
4630: rec_count := rec_count + 1;
4631: plsql_table_list(rec_count).col_name := 'PAGEBASE_EXPL_NODE_ID';
4632: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
4633: rec_count := rec_count + 1;

Line 4632: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';

4628: plsql_table_list(rec_count).col_name := 'ENABLED_CONDITION_ID';
4629: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';
4630: rec_count := rec_count + 1;
4631: plsql_table_list(rec_count).col_name := 'PAGEBASE_EXPL_NODE_ID';
4632: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
4633: rec_count := rec_count + 1;
4634: plsql_table_list(rec_count).col_name := 'CAPTION_TEXT_ID';
4635: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';
4636: insert_into_table('cz_ui_pages'

Line 4635: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';

4631: plsql_table_list(rec_count).col_name := 'PAGEBASE_EXPL_NODE_ID';
4632: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
4633: rec_count := rec_count + 1;
4634: plsql_table_list(rec_count).col_name := 'CAPTION_TEXT_ID';
4635: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';
4636: insert_into_table('cz_ui_pages'
4637: ,'ui_def_id'
4638: ,'jrad_doc'
4639: ,cz_pb_mgr.v_db_link

Line 4636: insert_into_table('cz_ui_pages'

4632: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
4633: rec_count := rec_count + 1;
4634: plsql_table_list(rec_count).col_name := 'CAPTION_TEXT_ID';
4635: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';
4636: insert_into_table('cz_ui_pages'
4637: ,'ui_def_id'
4638: ,'jrad_doc'
4639: ,cz_pb_mgr.v_db_link
4640: ,plsql_table_list

Line 5970: IF (cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.COUNT > 0)

5966: l_new_document VARCHAR2(255);
5967: BEGIN
5968: pbdebug := 22035;
5969:
5970: IF (cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.COUNT > 0)
5971: THEN
5972: FOR doc IN cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.FIRST .. cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.LAST
5973: LOOP
5974: l_new_document :=

Line 5972: FOR doc IN cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.FIRST .. cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.LAST

5968: pbdebug := 22035;
5969:
5970: IF (cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.COUNT > 0)
5971: THEN
5972: FOR doc IN cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.FIRST .. cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.LAST
5973: LOOP
5974: l_new_document :=
5975: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5976: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))

Line 5975: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)

5971: THEN
5972: FOR doc IN cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.FIRST .. cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.LAST
5973: LOOP
5974: l_new_document :=
5975: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5976: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5977: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5978: );
5979: insert_into_repository(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc), l_new_document, cz_pb_mgr.v_db_link , 'UI_PAGE');

Line 5979: insert_into_repository(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc), l_new_document, cz_pb_mgr.v_db_link , 'UI_PAGE');

5975: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5976: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5977: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5978: );
5979: insert_into_repository(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc), l_new_document, cz_pb_mgr.v_db_link , 'UI_PAGE');
5980: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;
5981: END LOOP;
5982: END IF;
5983: EXCEPTION

Line 5980: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;

5976: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5977: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5978: );
5979: insert_into_repository(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc), l_new_document, cz_pb_mgr.v_db_link , 'UI_PAGE');
5980: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;
5981: END LOOP;
5982: END IF;
5983: EXCEPTION
5984: WHEN OTHERS

Line 7215: delete_from_table('cz_ui_pages','ui_def_id',v_database_link,'cz_pb_mgr.g_cz_ui_pages_ui_def_ref',cz_pb_mgr.g_cz_ui_pages_ui_def_ref);

7211: ,'cz_pb_mgr.v_cz_des_cells_rule_id_new_ref'
7212: ,cz_pb_mgr.v_cz_des_cells_rule_id_new_ref
7213: );
7214:
7215: delete_from_table('cz_ui_pages','ui_def_id',v_database_link,'cz_pb_mgr.g_cz_ui_pages_ui_def_ref',cz_pb_mgr.g_cz_ui_pages_ui_def_ref);
7216: delete_from_table('cz_ui_page_elements','ui_def_id','page_id','element_id',v_database_link,'cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref','cz_pb_mgr.g_ui_ps_maps_page_id_tbl','cz_pb_mgr.g_ui_ps_maps_element_tbl',cz_pb_mgr.g_ui_ps_maps_new_ui_def_ref);
7217: delete_from_table('cz_ui_page_refs','ui_def_id','page_set_id','page_ref_id',v_database_link,'cz_pb_mgr.g_page_refs_ui_def_new_ref','cz_pb_mgr.g_page_refs_pg_set_ref','cz_pb_mgr.g_page_refs_pg_ref_ref',cz_pb_mgr.g_page_refs_ui_def_new_ref);
7218: delete_from_table('cz_ui_page_sets','ui_def_id','page_set_id',v_database_link,'cz_pb_mgr.g_page_sets_ui_ref','cz_pb_mgr.g_page_sets_pg_tbl',cz_pb_mgr.g_page_sets_ui_ref);
7219: delete_from_table('cz_ui_refs','ui_def_id','model_ref_expl_id',v_database_link,'cz_pb_mgr.g_ui_refs_new_ui_def_ref','cz_pb_mgr.g_ui_refs_expl_id_ref',cz_pb_mgr.g_ui_refs_new_ui_def_ref);

Line 7848: FROM cz_ui_pages

7844:
7845: CURSOR ui_pages_cur(ui_pages_def_id NUMBER)
7846: IS
7847: SELECT last_update_date
7848: FROM cz_ui_pages
7849: WHERE cz_ui_pages.ui_def_id = ui_pages_def_id
7850: ORDER BY last_update_date DESC;
7851:
7852: CURSOR ui_pages_capt_cur(p_ui_def_id NUMBER)

Line 7849: WHERE cz_ui_pages.ui_def_id = ui_pages_def_id

7845: CURSOR ui_pages_cur(ui_pages_def_id NUMBER)
7846: IS
7847: SELECT last_update_date
7848: FROM cz_ui_pages
7849: WHERE cz_ui_pages.ui_def_id = ui_pages_def_id
7850: ORDER BY last_update_date DESC;
7851:
7852: CURSOR ui_pages_capt_cur(p_ui_def_id NUMBER)
7853: IS

Line 7857: FROM cz_ui_pages

7853: IS
7854: SELECT last_update_date
7855: FROM cz_intl_texts
7856: WHERE intl_text_id IN(SELECT caption_text_id
7857: FROM cz_ui_pages
7858: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)
7859: ORDER BY last_update_date DESC;
7860:
7861: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)

Line 7858: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)

7854: SELECT last_update_date
7855: FROM cz_intl_texts
7856: WHERE intl_text_id IN(SELECT caption_text_id
7857: FROM cz_ui_pages
7858: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)
7859: ORDER BY last_update_date DESC;
7860:
7861: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)
7862: IS

Line 13043: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

13039: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13040: (t.ui_def_id>1 AND
13041: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13042: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13043: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13044: WHERE p.page_id=t.ui_page_id AND
13045: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13046: );
13047:

Line 13072: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

13068: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13069: (t.ui_def_id>1 AND
13070: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13071: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13072: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13073: WHERE p.page_id=t.ui_page_id AND
13074: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13075: );
13076: END IF;

Line 13098: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

13094: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13095: (t.ui_def_id>1 AND
13096: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13097: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13098: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13099: WHERE p.page_id=t.ui_page_id AND
13100: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13101: );
13102:

Line 13125: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

13121: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
13122: (t.ui_def_id>1 AND
13123: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
13124: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
13125: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
13126: WHERE p.page_id=t.ui_page_id AND
13127: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
13128: );
13129: