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 DUAL

Line 728: OPEN seq_cv FOR 'SELECT ' || seq_name || ' FROM dual';

724: -- 2. If the running sequence count has reached the last sequence in the block
725: IF (l_sequence_gen = 0 OR(l_sequence_gen = cz_pb_mgr.v_next_sequence_gen(seq_const)))
726: THEN
727: BEGIN
728: OPEN seq_cv FOR 'SELECT ' || seq_name || ' FROM dual';
729:
730: LOOP
731: FETCH seq_cv
732: INTO l_sequence_gen;

Line 5368: || ''',1,7,:5,:6,''OK'',''0'',sysdate,sysdate,sysdate,:7,:8, 0,:9 FROM dual';

5364: || 'remote_publication_id )'
5365: || ' '
5366: || 'SELECT :1,:2,:3,''UIT'',:4,'''
5367: || l_pub_mode
5368: || ''',1,7,:5,:6,''OK'',''0'',sysdate,sysdate,sysdate,:7,:8, 0,:9 FROM dual';
5369:
5370: EXECUTE IMMEDIATE l_inst_str
5371: USING l_src_pb_id
5372: ,p_template_id

Line 5463: FROM DUAL;

5459: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
5460: THEN
5461: SELECT cz_model_publications_s.NEXTVAL
5462: INTO l_src_pb_id
5463: FROM DUAL;
5464:
5465: l_tgt_pb_id :=
5466: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
5467: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

Line 8281: FROM DUAL;

8277: ,v_page_elements_date
8278: )
8279: )
8280: INTO x_max_update_date
8281: FROM DUAL;
8282: EXCEPTION
8283: WHEN OTHERS
8284: THEN
8285: x_max_update_date := cz_utils.epoch_begin;

Line 10221: FROM DUAL;

10217: );
10218:
10219: SELECT cz_pb_model_exports_s.CURRVAL
10220: INTO cz_pb_mgr.v_export_id
10221: FROM DUAL;
10222:
10223: COMMIT;
10224: EXCEPTION
10225: WHEN OTHERS

Line 18047: FROM DUAL;

18043: COMMIT;
18044:
18045: SELECT cz_model_publications_s.NEXTVAL
18046: INTO l_old_publication_id
18047: FROM DUAL;
18048:
18049: l_remote_publication_id :=
18050: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
18051: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

Line 18073: || 'SOURCE_MODEL_ID,CONTAINER,PAGE_LAYOUT,disabled_flag FROM DUAL ';

18069: || 'MODEL_LAST_STRUCT_UPDATE,MODEL_LAST_LOGIC_UPDATE,MODEL_LAST_UPDATED,'''
18070: || g_source_flag
18071: || ''',:4,SOURCE_UI_DEF_ID,'
18072: || ' '
18073: || 'SOURCE_MODEL_ID,CONTAINER,PAGE_LAYOUT,disabled_flag FROM DUAL ';
18074:
18075: EXECUTE IMMEDIATE v_inst_str
18076: USING l_old_publication_id, p_temp_id, p_temp_id, l_remote_publication_id;
18077:

Line 18099: || 'SOURCE_MODEL_ID,CONTAINER,PAGE_LAYOUT,disabled_flag FROM DUAL ';

18095: || 'MODEL_LAST_STRUCT_UPDATE,MODEL_LAST_LOGIC_UPDATE,MODEL_LAST_UPDATED,'''
18096: || g_target_flag
18097: || ''',:4,SOURCE_UI_DEF_ID,'
18098: || ' '
18099: || 'SOURCE_MODEL_ID,CONTAINER,PAGE_LAYOUT,disabled_flag FROM DUAL ';
18100:
18101: EXECUTE IMMEDIATE v_inst_str
18102: USING l_remote_publication_id, p_temp_id, p_temp_id, l_old_publication_id;
18103:

Line 18660: ---------select run_id and user from dual

18656: END;
18657:
18658: cz_pb_mgr.v_status_code := publication_ok;
18659:
18660: ---------select run_id and user from dual
18661: ---------
18662: BEGIN
18663: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
18664: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id

Line 18665: FROM DUAL;

18661: ---------
18662: BEGIN
18663: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
18664: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id
18665: FROM DUAL;
18666: EXCEPTION
18667: WHEN OTHERS
18668: THEN
18669: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');

Line 18860: FROM DUAL;

18856: -----------create a dummy publication
18857: BEGIN
18858: SELECT cz_model_publications_s.NEXTVAL
18859: INTO cz_pb_mgr.v_publication_id
18860: FROM DUAL;
18861:
18862: v_pub_id := cz_pb_mgr.v_publication_id;
18863: EXCEPTION
18864: WHEN OTHERS

Line 19413: ---------select run_id and user from dual

19409: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
19410: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
19411: END IF;
19412:
19413: ---------select run_id and user from dual
19414: BEGIN
19415: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
19416: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id
19417: FROM DUAL;

Line 19417: FROM DUAL;

19413: ---------select run_id and user from dual
19414: BEGIN
19415: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
19416: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id
19417: FROM DUAL;
19418: EXCEPTION
19419: WHEN OTHERS
19420: THEN
19421: RAISE run_id_error;

Line 20291: || '(:1, ''FLD''), ''/'', ''.'') FROM DUAL'

20287: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN
20288: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
20289: EXECUTE IMMEDIATE 'SELECT REPLACE(cz_developer_utils_pvt.get_repository_path'
20290: || cz_pb_mgr.v_db_link
20291: || '(:1, ''FLD''), ''/'', ''.'') FROM DUAL'
20292: INTO l_tgt_fld_path
20293: USING cz_pb_mgr.g_migration_tgt_folder_id;
20294:
20295: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN

Line 20429: || ' WHERE deleted_flag = ''0'' AND model_id = :3), 0)) FROM DUAL'

20425: || cz_pb_mgr.v_db_link
20426: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :2), 0),'
20427: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'
20428: || cz_pb_mgr.v_db_link
20429: || ' WHERE deleted_flag = ''0'' AND model_id = :3), 0)) FROM DUAL'
20430: INTO v_max_rec_id
20431: USING v_object_id, v_object_id, v_object_id;
20432:
20433:

Line 22288: FROM DUAL;

22284: x_status := 'OK';
22285:
22286: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22287: INTO v_new_publication_id, v_old_publication_id
22288: FROM DUAL;
22289:
22290: INSERT INTO cz_model_publications
22291: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
22292: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update

Line 22436: FROM DUAL;

22432: END IF;
22433:
22434: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
22435: INTO v_new_publication_id, v_old_publication_id
22436: FROM DUAL;
22437:
22438: INSERT INTO cz_model_publications
22439: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
22440: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update

Line 22686: FROM DUAL;

22682:
22683: ---get run id
22684: SELECT cz_xfr_run_infos_s.NEXTVAL
22685: INTO cz_pb_mgr.v_pb_run_id
22686: FROM DUAL;
22687:
22688: x_run_id := cz_pb_mgr.v_pb_run_id;
22689:
22690: ----get source pb info

Line 23260: FROM DUAL;

23256: END IF;
23257:
23258: SELECT cz_model_publications_s.NEXTVAL
23259: INTO v_new_publication_id
23260: FROM DUAL;
23261:
23262: INSERT INTO cz_model_publications
23263: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode
23264: ,ui_def_id, ui_style, applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update

Line 24275: FROM DUAL

24271: IF (what_exists = 'PSPROPVAL')
24272: THEN
24273: SELECT '1'
24274: INTO record_exists
24275: FROM DUAL
24276: WHERE EXISTS(SELECT property_id
24277: FROM cz_ps_prop_vals
24278: WHERE property_id = source_id);
24279: ELSIF(what_exists = 'ITPROPVAL')

Line 24283: FROM DUAL

24279: ELSIF(what_exists = 'ITPROPVAL')
24280: THEN
24281: SELECT '1'
24282: INTO record_exists
24283: FROM DUAL
24284: WHERE EXISTS(SELECT property_id
24285: FROM cz_item_property_values
24286: WHERE property_id = source_id);
24287: END IF;