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 114: g_cz_ui_pages_ui_def_ref.DELETE;

110: v_language_id_tbl.DELETE;
111: cz_pb_mgr.g_item_type_id := 0;
112: cz_pb_mgr.g_item_id := 0;
113: g_object_type := ' ';
114: g_cz_ui_pages_ui_def_ref.DELETE;
115: g_cz_ui_pages_jrad_doc_ref.DELETE;
116: g_cz_ui_pages_capt_id_ref.DELETE;
117: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
118: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;

Line 115: g_cz_ui_pages_jrad_doc_ref.DELETE;

111: cz_pb_mgr.g_item_type_id := 0;
112: cz_pb_mgr.g_item_id := 0;
113: g_object_type := ' ';
114: g_cz_ui_pages_ui_def_ref.DELETE;
115: g_cz_ui_pages_jrad_doc_ref.DELETE;
116: g_cz_ui_pages_capt_id_ref.DELETE;
117: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
118: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
119: g_cz_ui_pages_ui_def_tbl.DELETE;

Line 116: g_cz_ui_pages_capt_id_ref.DELETE;

112: cz_pb_mgr.g_item_id := 0;
113: g_object_type := ' ';
114: g_cz_ui_pages_ui_def_ref.DELETE;
115: g_cz_ui_pages_jrad_doc_ref.DELETE;
116: g_cz_ui_pages_capt_id_ref.DELETE;
117: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
118: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
119: g_cz_ui_pages_ui_def_tbl.DELETE;
120: g_cz_ui_pages_jrad_doc_tbl.DELETE;

Line 119: g_cz_ui_pages_ui_def_tbl.DELETE;

115: g_cz_ui_pages_jrad_doc_ref.DELETE;
116: g_cz_ui_pages_capt_id_ref.DELETE;
117: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
118: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
119: g_cz_ui_pages_ui_def_tbl.DELETE;
120: g_cz_ui_pages_jrad_doc_tbl.DELETE;
121: g_cz_ui_pages_capt_id_tbl.DELETE;
122: g_page_sets_ui_old_ref.DELETE;
123: g_page_sets_ui_ref.DELETE;

Line 120: g_cz_ui_pages_jrad_doc_tbl.DELETE;

116: g_cz_ui_pages_capt_id_ref.DELETE;
117: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
118: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
119: g_cz_ui_pages_ui_def_tbl.DELETE;
120: g_cz_ui_pages_jrad_doc_tbl.DELETE;
121: g_cz_ui_pages_capt_id_tbl.DELETE;
122: g_page_sets_ui_old_ref.DELETE;
123: g_page_sets_ui_ref.DELETE;
124: g_page_sets_pg_tbl.DELETE;

Line 121: g_cz_ui_pages_capt_id_tbl.DELETE;

117: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
118: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
119: g_cz_ui_pages_ui_def_tbl.DELETE;
120: g_cz_ui_pages_jrad_doc_tbl.DELETE;
121: g_cz_ui_pages_capt_id_tbl.DELETE;
122: g_page_sets_ui_old_ref.DELETE;
123: g_page_sets_ui_ref.DELETE;
124: g_page_sets_pg_tbl.DELETE;
125: cz_pb_mgr.v_ui_images_ui_ref.DELETE;

Line 3468: FROM cz_ui_pages

3464: END IF;
3465:
3466: SELECT jrad_doc
3467: BULK COLLECT INTO l_jrad_doc_tbl
3468: FROM cz_ui_pages
3469: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';
3470:
3471: IF (l_jrad_doc_tbl.COUNT > 0)
3472: THEN

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

3465:
3466: SELECT jrad_doc
3467: BULK COLLECT INTO l_jrad_doc_tbl
3468: FROM cz_ui_pages
3469: WHERE cz_ui_pages.ui_def_id = p_ui_def_id AND cz_ui_pages.deleted_flag = '0';
3470:
3471: IF (l_jrad_doc_tbl.COUNT > 0)
3472: THEN
3473: EXECUTE IMMEDIATE ' begin delete from cz_jrad_chunks' || l_link_name || '; commit; end; ';

Line 3826: -----collect from cz_ui_pages

3822: RAISE;
3823: END insert_into_repository;
3824:
3825: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3826: -----collect from cz_ui_pages
3827: PROCEDURE bulk_collect_ui_pages
3828: IS
3829: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
3830: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;

Line 3829: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;

3825: ------------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3826: -----collect from cz_ui_pages
3827: PROCEDURE bulk_collect_ui_pages
3828: IS
3829: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
3830: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
3831: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
3832: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;

Line 3830: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;

3826: -----collect from cz_ui_pages
3827: PROCEDURE bulk_collect_ui_pages
3828: IS
3829: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
3830: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
3831: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
3832: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;

Line 3831: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;

3827: PROCEDURE bulk_collect_ui_pages
3828: IS
3829: l_cz_ui_pages_ui_def_tbl cz_pb_mgr.t_ref;
3830: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
3831: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
3832: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;

Line 3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;

3830: l_cz_ui_pages_jrad_doc_tbl varchar_tbl_type;
3831: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
3832: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
3836: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
3837: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
3838: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;

Line 3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;

3831: l_cz_ui_pages_capt_id_tbl cz_pb_mgr.t_ref;
3832: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
3836: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
3837: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
3838: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
3839: l_rec_count NUMBER;

Line 3836: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;

3832: l_cz_page_stat_templ_tbl cz_pb_mgr.t_ref;
3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
3836: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
3837: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
3838: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
3839: l_rec_count NUMBER;
3840: BEGIN

Line 3837: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;

3833: l_cz_page_stat_uidef_tbl cz_pb_mgr.t_ref;
3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
3836: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
3837: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
3838: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
3839: l_rec_count NUMBER;
3840: BEGIN
3841: pbdebug := 22029;

Line 3838: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;

3834: l_cz_ui_pages_pgtmplid_tbl cz_pb_mgr.t_ref;
3835: l_cz_ui_pages_pgtmplui_tbl cz_pb_mgr.t_ref;
3836: l_cz_ui_pages_dis_cond_tbl cz_pb_mgr.t_ref;
3837: l_cz_ui_pages_enb_cond_tbl cz_pb_mgr.t_ref;
3838: l_cz_ui_pages_expl_node_tbl cz_pb_mgr.t_ref;
3839: l_rec_count NUMBER;
3840: BEGIN
3841: pbdebug := 22029;
3842:

Line 3845: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;

3841: pbdebug := 22029;
3842:
3843: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
3844: THEN
3845: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
3846: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
3847: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
3848: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
3849: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;

Line 3846: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;

3842:
3843: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
3844: THEN
3845: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
3846: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
3847: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
3848: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
3849: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
3850: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;

Line 3847: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;

3843: IF (cz_pb_mgr.v_cz_ui_defs_old_oa_ref.COUNT > 0)
3844: THEN
3845: cz_pb_mgr.g_cz_ui_pages_ui_def_ref.DELETE;
3846: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.DELETE;
3847: cz_pb_mgr.g_cz_ui_pages_capt_id_ref.DELETE;
3848: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
3849: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
3850: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
3851: -- cz_pb_mgr.v_intl_text_model_tbl.DELETE;

Line 3852: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;

3848: cz_pb_mgr.g_pages_ui_def_old_ref.DELETE;
3849: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
3850: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
3851: -- cz_pb_mgr.v_intl_text_model_tbl.DELETE;
3852: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;
3853: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
3854: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
3855: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;

Line 3853: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;

3849: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref.DELETE;
3850: -- cz_pb_mgr.v_intl_text_ui_tbl.DELETE;
3851: -- cz_pb_mgr.v_intl_text_model_tbl.DELETE;
3852: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;
3853: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
3854: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
3855: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
3857: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;

Line 3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;

3852: cz_pb_mgr.g_cz_ui_pages_stat_templ.DELETE;
3853: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
3854: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
3855: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
3857: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
3858: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
3859:
3860: 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 3857: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;

3853: cz_pb_mgr.g_cz_ui_pages_stat_ui.DELETE;
3854: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
3855: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
3857: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
3858: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
3859:
3860: 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
3861: LOOP

Line 3858: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;

3854: cz_pb_mgr.g_cz_uipg_tmplid_tbl.DELETE;
3855: cz_pb_mgr.g_cz_uipg_tmplui_tbl.DELETE;
3856: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl.DELETE;
3857: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl.DELETE;
3858: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
3859:
3860: 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
3861: LOOP
3862: l_cz_ui_pages_ui_def_tbl.DELETE;

Line 3862: l_cz_ui_pages_ui_def_tbl.DELETE;

3858: cz_pb_mgr.g_cz_ui_pages_expl_tbl.DELETE;
3859:
3860: 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
3861: LOOP
3862: l_cz_ui_pages_ui_def_tbl.DELETE;
3863: l_cz_ui_pages_jrad_doc_tbl.DELETE;
3864: l_cz_ui_pages_capt_id_tbl.DELETE;
3865: l_cz_page_stat_templ_tbl.DELETE;
3866: l_cz_page_stat_uidef_tbl.DELETE;

Line 3863: l_cz_ui_pages_jrad_doc_tbl.DELETE;

3859:
3860: 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
3861: LOOP
3862: l_cz_ui_pages_ui_def_tbl.DELETE;
3863: l_cz_ui_pages_jrad_doc_tbl.DELETE;
3864: l_cz_ui_pages_capt_id_tbl.DELETE;
3865: l_cz_page_stat_templ_tbl.DELETE;
3866: l_cz_page_stat_uidef_tbl.DELETE;
3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;

Line 3864: l_cz_ui_pages_capt_id_tbl.DELETE;

3860: 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
3861: LOOP
3862: l_cz_ui_pages_ui_def_tbl.DELETE;
3863: l_cz_ui_pages_jrad_doc_tbl.DELETE;
3864: l_cz_ui_pages_capt_id_tbl.DELETE;
3865: l_cz_page_stat_templ_tbl.DELETE;
3866: l_cz_page_stat_uidef_tbl.DELETE;
3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;
3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;

Line 3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;

3863: l_cz_ui_pages_jrad_doc_tbl.DELETE;
3864: l_cz_ui_pages_capt_id_tbl.DELETE;
3865: l_cz_page_stat_templ_tbl.DELETE;
3866: l_cz_page_stat_uidef_tbl.DELETE;
3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;
3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;
3869: l_cz_ui_pages_dis_cond_tbl.DELETE;
3870: l_cz_ui_pages_enb_cond_tbl.DELETE;
3871: l_cz_ui_pages_expl_node_tbl.DELETE;

Line 3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;

3864: l_cz_ui_pages_capt_id_tbl.DELETE;
3865: l_cz_page_stat_templ_tbl.DELETE;
3866: l_cz_page_stat_uidef_tbl.DELETE;
3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;
3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;
3869: l_cz_ui_pages_dis_cond_tbl.DELETE;
3870: l_cz_ui_pages_enb_cond_tbl.DELETE;
3871: l_cz_ui_pages_expl_node_tbl.DELETE;
3872:

Line 3869: l_cz_ui_pages_dis_cond_tbl.DELETE;

3865: l_cz_page_stat_templ_tbl.DELETE;
3866: l_cz_page_stat_uidef_tbl.DELETE;
3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;
3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;
3869: l_cz_ui_pages_dis_cond_tbl.DELETE;
3870: l_cz_ui_pages_enb_cond_tbl.DELETE;
3871: l_cz_ui_pages_expl_node_tbl.DELETE;
3872:
3873: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id

Line 3870: l_cz_ui_pages_enb_cond_tbl.DELETE;

3866: l_cz_page_stat_uidef_tbl.DELETE;
3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;
3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;
3869: l_cz_ui_pages_dis_cond_tbl.DELETE;
3870: l_cz_ui_pages_enb_cond_tbl.DELETE;
3871: l_cz_ui_pages_expl_node_tbl.DELETE;
3872:
3873: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
3874: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id

Line 3871: l_cz_ui_pages_expl_node_tbl.DELETE;

3867: l_cz_ui_pages_pgtmplid_tbl.DELETE;
3868: l_cz_ui_pages_pgtmplui_tbl.DELETE;
3869: l_cz_ui_pages_dis_cond_tbl.DELETE;
3870: l_cz_ui_pages_enb_cond_tbl.DELETE;
3871: l_cz_ui_pages_expl_node_tbl.DELETE;
3872:
3873: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
3874: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
3875: ,enabled_condition_id, pagebase_expl_node_id

Line 3876: 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

3872:
3873: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
3874: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
3875: ,enabled_condition_id, pagebase_expl_node_id
3876: 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
3877: ,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
3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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 3877: ,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

3873: SELECT ui_def_id, jrad_doc, caption_text_id, page_status_template_id
3874: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
3875: ,enabled_condition_id, pagebase_expl_node_id
3876: 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
3877: ,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
3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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;
3881:

Line 3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl

3874: ,page_status_templ_uidef_id, outer_page_template_id, outer_page_templ_uidef_id, display_condition_id
3875: ,enabled_condition_id, pagebase_expl_node_id
3876: 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
3877: ,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
3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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;
3881:
3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)

Line 3879: FROM cz_ui_pages

3875: ,enabled_condition_id, pagebase_expl_node_id
3876: 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
3877: ,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
3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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;
3881:
3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
3883: THEN

Line 3880: 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;

3876: 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
3877: ,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
3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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;
3881:
3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
3883: THEN
3884: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;

Line 3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)

3878: ,l_cz_ui_pages_enb_cond_tbl, l_cz_ui_pages_expl_node_tbl
3879: FROM cz_ui_pages
3880: 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;
3881:
3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
3883: THEN
3884: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;
3885:
3886: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST

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

3882: IF (l_cz_ui_pages_ui_def_tbl.COUNT > 0)
3883: THEN
3884: l_rec_count := cz_pb_mgr.g_pages_ui_def_old_ref.COUNT;
3885:
3886: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST
3887: LOOP
3888: l_rec_count := l_rec_count + 1;
3889: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

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

3885:
3886: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST
3887: LOOP
3888: l_rec_count := l_rec_count + 1;
3889: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);

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

3886: FOR uidefref IN l_cz_ui_pages_ui_def_tbl.FIRST .. l_cz_ui_pages_ui_def_tbl.LAST
3887: LOOP
3888: l_rec_count := l_rec_count + 1;
3889: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);

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

3887: LOOP
3888: l_rec_count := l_rec_count + 1;
3889: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);

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

3888: l_rec_count := l_rec_count + 1;
3889: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);

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

3889: -- cz_pb_mgr.g_cz_ui_pages_ui_def_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;

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

3890: -- cz_pb_mgr.v_intl_text_ui_tbl(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);

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

3891: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);

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

3892: cz_pb_mgr.g_cz_ui_pages_capt_id_ref(l_rec_count) := l_cz_ui_pages_capt_id_tbl(uidefref);
3893: cz_pb_mgr.g_pages_ui_def_old_ref(l_rec_count) := l_cz_ui_pages_ui_def_tbl(uidefref);
3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
3900: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);

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

3894: cz_pb_mgr.g_cz_ui_old_jrad_doc_ref(l_rec_count) := l_cz_ui_pages_jrad_doc_tbl(uidefref);
3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
3900: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
3901: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
3902: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);

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

3895: cz_pb_mgr.g_cz_ui_pages_stat_templ(l_rec_count) := l_cz_page_stat_templ_tbl(uidefref);
3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
3900: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
3901: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
3902: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
3903: END LOOP;

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

3896: cz_pb_mgr.g_cz_ui_pages_stat_ui(l_rec_count) := l_cz_page_stat_uidef_tbl(uidefref);
3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
3900: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
3901: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
3902: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
3903: END LOOP;
3904: END IF;

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

3897: -- cz_pb_mgr.v_intl_text_model_tbl(l_rec_count) := -1;
3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
3900: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
3901: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
3902: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
3903: END LOOP;
3904: END IF;
3905: END LOOP;

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

3898: cz_pb_mgr.g_cz_uipg_tmplid_tbl(l_rec_count) := l_cz_ui_pages_pgtmplid_tbl(uidefref);
3899: cz_pb_mgr.g_cz_uipg_tmplui_tbl(l_rec_count) := l_cz_ui_pages_pgtmplui_tbl(uidefref);
3900: cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl(l_rec_count) := l_cz_ui_pages_dis_cond_tbl(uidefref);
3901: cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl(l_rec_count) := l_cz_ui_pages_enb_cond_tbl(uidefref);
3902: cz_pb_mgr.g_cz_ui_pages_expl_tbl(l_rec_count) := l_cz_ui_pages_expl_node_tbl(uidefref);
3903: END LOOP;
3904: END IF;
3905: END LOOP;
3906: END IF;

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

3909: THEN
3910: NULL;
3911: WHEN OTHERS
3912: THEN
3913: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_ui_pages', 'SQLERRM', SQLERRM);
3914: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.CZ_UIPAGES', SQLCODE);
3915: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
3916: RAISE;
3917: END bulk_collect_ui_pages;

Line 3920: -------insert into cz_ui_pages

3916: RAISE;
3917: END bulk_collect_ui_pages;
3918:
3919: -------------------------------------------------------------------------
3920: -------insert into cz_ui_pages
3921: PROCEDURE insert_into_ui_pages
3922: IS
3923: rec_count NUMBER := 0;
3924: plsql_table_list cz_pb_mgr.col_plsql_table_list;

Line 3931: 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');

3927:
3928: IF (cz_pb_mgr.g_pages_ui_def_old_ref.COUNT > 0)
3929: THEN
3930: ----resolve ui_def_id of ui pages
3931: 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');
3932:
3933: -- resolve page status and outer page templates
3934: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
3935: 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 3935: 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');

3931: 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');
3932:
3933: -- resolve page status and outer page templates
3934: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
3935: 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');
3936: 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);
3937: 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');
3938: 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);
3939: END IF;

Line 3936: 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);

3932:
3933: -- resolve page status and outer page templates
3934: IF cz_pb_mgr.v_session_parameter = pub_model OR cz_pb_mgr.v_server_id <> 0 THEN
3935: 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');
3936: 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);
3937: 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');
3938: 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);
3939: END IF;
3940:

Line 3942: 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');

3938: 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);
3939: END IF;
3940:
3941: ----caption ids of ui pages
3942: 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');
3943:
3944: 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');
3945: 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');
3946: 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 3944: 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');

3940:
3941: ----caption ids of ui pages
3942: 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');
3943:
3944: 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');
3945: 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');
3946: 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');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;

Line 3945: 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');

3941: ----caption ids of ui pages
3942: 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');
3943:
3944: 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');
3945: 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');
3946: 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');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;
3949: plsql_table_list(rec_count).col_name := 'ui_def_id';

Line 3946: 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');

3942: 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');
3943:
3944: 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');
3945: 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');
3946: 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');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;
3949: plsql_table_list(rec_count).col_name := 'ui_def_id';
3950: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';

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

3946: 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');
3947: plsql_table_list.DELETE;
3948: rec_count := 1;
3949: plsql_table_list(rec_count).col_name := 'ui_def_id';
3950: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';
3951: rec_count := rec_count + 1;
3952: plsql_table_list(rec_count).col_name := 'jrad_doc';
3953: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';
3954: rec_count := rec_count + 1;

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

3949: plsql_table_list(rec_count).col_name := 'ui_def_id';
3950: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_ui_def_ref';
3951: rec_count := rec_count + 1;
3952: plsql_table_list(rec_count).col_name := 'jrad_doc';
3953: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';
3954: rec_count := rec_count + 1;
3955: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPLATE_ID';
3956: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';
3957: rec_count := rec_count + 1;

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

3952: plsql_table_list(rec_count).col_name := 'jrad_doc';
3953: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref';
3954: rec_count := rec_count + 1;
3955: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPLATE_ID';
3956: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';
3957: rec_count := rec_count + 1;
3958: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPL_UIDEF_ID';
3959: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_ui';
3960: rec_count := rec_count + 1;

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

3955: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPLATE_ID';
3956: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_templ';
3957: rec_count := rec_count + 1;
3958: plsql_table_list(rec_count).col_name := 'PAGE_STATUS_TEMPL_UIDEF_ID';
3959: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_stat_ui';
3960: rec_count := rec_count + 1;
3961: plsql_table_list(rec_count).col_name := 'OUTER_PAGE_TEMPLATE_ID';
3962: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_uipg_tmplid_tbl';
3963: rec_count := rec_count + 1;

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

3964: plsql_table_list(rec_count).col_name := 'OUTER_PAGE_TEMPL_UIDEF_ID';
3965: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_uipg_tmplui_tbl';
3966: rec_count := rec_count + 1;
3967: plsql_table_list(rec_count).col_name := 'DISPLAY_CONDITION_ID';
3968: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl';
3969: rec_count := rec_count + 1;
3970: plsql_table_list(rec_count).col_name := 'ENABLED_CONDITION_ID';
3971: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';
3972: rec_count := rec_count + 1;

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

3967: plsql_table_list(rec_count).col_name := 'DISPLAY_CONDITION_ID';
3968: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_dis_cond_tbl';
3969: rec_count := rec_count + 1;
3970: plsql_table_list(rec_count).col_name := 'ENABLED_CONDITION_ID';
3971: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';
3972: rec_count := rec_count + 1;
3973: plsql_table_list(rec_count).col_name := 'PAGEBASE_EXPL_NODE_ID';
3974: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
3975: rec_count := rec_count + 1;

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

3970: plsql_table_list(rec_count).col_name := 'ENABLED_CONDITION_ID';
3971: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_enb_cond_tbl';
3972: rec_count := rec_count + 1;
3973: plsql_table_list(rec_count).col_name := 'PAGEBASE_EXPL_NODE_ID';
3974: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
3975: rec_count := rec_count + 1;
3976: plsql_table_list(rec_count).col_name := 'CAPTION_TEXT_ID';
3977: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';
3978: insert_into_table('cz_ui_pages'

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

3973: plsql_table_list(rec_count).col_name := 'PAGEBASE_EXPL_NODE_ID';
3974: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
3975: rec_count := rec_count + 1;
3976: plsql_table_list(rec_count).col_name := 'CAPTION_TEXT_ID';
3977: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';
3978: insert_into_table('cz_ui_pages'
3979: ,'ui_def_id'
3980: ,'jrad_doc'
3981: ,cz_pb_mgr.v_db_link

Line 3978: insert_into_table('cz_ui_pages'

3974: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_expl_tbl';
3975: rec_count := rec_count + 1;
3976: plsql_table_list(rec_count).col_name := 'CAPTION_TEXT_ID';
3977: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.g_cz_ui_pages_capt_id_ref';
3978: insert_into_table('cz_ui_pages'
3979: ,'ui_def_id'
3980: ,'jrad_doc'
3981: ,cz_pb_mgr.v_db_link
3982: ,plsql_table_list

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

5220: l_new_document VARCHAR2(255);
5221: BEGIN
5222: pbdebug := 22035;
5223:
5224: IF (cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.COUNT > 0)
5225: THEN
5226: 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
5227: LOOP
5228: l_new_document :=

Line 5226: 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

5222: pbdebug := 22035;
5223:
5224: IF (cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref.COUNT > 0)
5225: THEN
5226: 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
5227: LOOP
5228: l_new_document :=
5229: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5230: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))

Line 5229: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)

5225: THEN
5226: 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
5227: LOOP
5228: l_new_document :=
5229: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5230: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5231: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5232: );
5233: 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 5233: 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');

5229: REPLACE(cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc)
5230: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5231: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5232: );
5233: 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');
5234: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;
5235: END LOOP;
5236: END IF;
5237: EXCEPTION

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

5230: ,TO_CHAR(cz_pb_mgr.g_pages_ui_def_old_ref(doc))
5231: ,TO_CHAR(cz_pb_mgr.v_cz_ui_defs_idx_ref(cz_pb_mgr.g_pages_ui_def_old_ref(doc)))
5232: );
5233: 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');
5234: cz_pb_mgr.g_cz_ui_pages_jrad_doc_ref(doc) := l_new_document;
5235: END LOOP;
5236: END IF;
5237: EXCEPTION
5238: WHEN OTHERS

Line 6503: 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);

6499: ,'cz_pb_mgr.v_cz_des_cells_rule_id_new_ref'
6500: ,cz_pb_mgr.v_cz_des_cells_rule_id_new_ref
6501: );
6502:
6503: 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);
6504: 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);
6505: 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);
6506: 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);
6507: 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 7125: FROM cz_ui_pages

7121:
7122: CURSOR ui_pages_cur(ui_pages_def_id NUMBER)
7123: IS
7124: SELECT last_update_date
7125: FROM cz_ui_pages
7126: WHERE cz_ui_pages.ui_def_id = ui_pages_def_id
7127: ORDER BY last_update_date DESC;
7128:
7129: CURSOR ui_pages_capt_cur(p_ui_def_id NUMBER)

Line 7126: WHERE cz_ui_pages.ui_def_id = ui_pages_def_id

7122: CURSOR ui_pages_cur(ui_pages_def_id NUMBER)
7123: IS
7124: SELECT last_update_date
7125: FROM cz_ui_pages
7126: WHERE cz_ui_pages.ui_def_id = ui_pages_def_id
7127: ORDER BY last_update_date DESC;
7128:
7129: CURSOR ui_pages_capt_cur(p_ui_def_id NUMBER)
7130: IS

Line 7134: FROM cz_ui_pages

7130: IS
7131: SELECT last_update_date
7132: FROM cz_intl_texts
7133: WHERE intl_text_id IN(SELECT caption_text_id
7134: FROM cz_ui_pages
7135: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)
7136: ORDER BY last_update_date DESC;
7137:
7138: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)

Line 7135: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)

7131: SELECT last_update_date
7132: FROM cz_intl_texts
7133: WHERE intl_text_id IN(SELECT caption_text_id
7134: FROM cz_ui_pages
7135: WHERE cz_ui_pages.ui_def_id = p_ui_def_id)
7136: ORDER BY last_update_date DESC;
7137:
7138: CURSOR ui_page_sets_cur(p_ui_def_id NUMBER)
7139: IS

Line 12079: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

12075: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12076: (t.ui_def_id>1 AND
12077: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
12078: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
12079: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
12080: WHERE p.page_id=t.ui_page_id AND
12081: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12082: );
12083:

Line 12106: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

12102: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12103: (t.ui_def_id>1 AND
12104: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
12105: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
12106: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
12107: WHERE p.page_id=t.ui_page_id AND
12108: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12109: );
12110:

Line 12133: EXISTS(SELECT NULL FROM CZ_UI_PAGES p

12129: (t.ui_def_id IS NULL OR t.ui_def_id IN(0,1)) OR
12130: (t.ui_def_id>1 AND
12131: EXISTS(SELECT NULL FROM CZ_UI_DEFS u
12132: WHERE u.ui_def_id=t.ui_def_id AND u.deleted_flag='0') AND
12133: EXISTS(SELECT NULL FROM CZ_UI_PAGES p
12134: WHERE p.page_id=t.ui_page_id AND
12135: p.ui_def_id=t.ui_def_id AND p.deleted_flag='0'))
12136: );
12137: