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.

[Home] [Help]

APPS.CZ_PB_MGR dependencies on DUAL

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

544: -- 2. If the running sequence count has reached the last sequence in the block
545: IF (l_sequence_gen = 0 OR(l_sequence_gen = cz_pb_mgr.v_next_sequence_gen(seq_const)))
546: THEN
547: BEGIN
548: OPEN seq_cv FOR 'SELECT ' || seq_name || ' FROM dual';
549:
550: LOOP
551: FETCH seq_cv
552: INTO l_sequence_gen;

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

4658: || 'remote_publication_id )'
4659: || ' '
4660: || 'SELECT :1,:2,:3,''UIT'',:4,'''
4661: || l_pub_mode
4662: || ''',1,7,:5,:6,''OK'',''0'',sysdate,sysdate,sysdate,:7,:8, 0,:9 FROM dual';
4663:
4664: EXECUTE IMMEDIATE l_inst_str
4665: USING l_src_pb_id
4666: ,p_template_id

Line 4757: FROM DUAL;

4753: IF (cz_pb_mgr.g_ui_templates_ui_def_old_ref(i) = 0)
4754: THEN
4755: SELECT cz_model_publications_s.NEXTVAL
4756: INTO l_src_pb_id
4757: FROM DUAL;
4758:
4759: l_tgt_pb_id :=
4760: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
4761: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

Line 7558: FROM DUAL;

7554: ,v_page_elements_date
7555: )
7556: )
7557: INTO x_max_update_date
7558: FROM DUAL;
7559: EXCEPTION
7560: WHEN OTHERS
7561: THEN
7562: x_max_update_date := cz_utils.epoch_begin;

Line 9465: FROM DUAL;

9461: );
9462:
9463: SELECT cz_pb_model_exports_s.CURRVAL
9464: INTO cz_pb_mgr.v_export_id
9465: FROM DUAL;
9466:
9467: COMMIT;
9468: EXCEPTION
9469: WHEN OTHERS

Line 16904: FROM DUAL;

16900: COMMIT;
16901:
16902: SELECT cz_model_publications_s.NEXTVAL
16903: INTO l_old_publication_id
16904: FROM DUAL;
16905:
16906: l_remote_publication_id :=
16907: cz_pb_mgr.sequence_generate(cz_pb_mgr.cz_model_publications_seq
16908: , 'cz_model_publications_s.nextval' || cz_pb_mgr.v_db_link

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

16926: || 'MODEL_LAST_STRUCT_UPDATE,MODEL_LAST_LOGIC_UPDATE,MODEL_LAST_UPDATED,'''
16927: || g_source_flag
16928: || ''',:4,SOURCE_UI_DEF_ID,'
16929: || ' '
16930: || 'SOURCE_MODEL_ID,CONTAINER,PAGE_LAYOUT,disabled_flag FROM DUAL ';
16931:
16932: EXECUTE IMMEDIATE v_inst_str
16933: USING l_old_publication_id, p_temp_id, p_temp_id, l_remote_publication_id;
16934:

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

16952: || 'MODEL_LAST_STRUCT_UPDATE,MODEL_LAST_LOGIC_UPDATE,MODEL_LAST_UPDATED,'''
16953: || g_target_flag
16954: || ''',:4,SOURCE_UI_DEF_ID,'
16955: || ' '
16956: || 'SOURCE_MODEL_ID,CONTAINER,PAGE_LAYOUT,disabled_flag FROM DUAL ';
16957:
16958: EXECUTE IMMEDIATE v_inst_str
16959: USING l_remote_publication_id, p_temp_id, p_temp_id, l_old_publication_id;
16960:

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

17513: END;
17514:
17515: cz_pb_mgr.v_status_code := publication_ok;
17516:
17517: ---------select run_id and user from dual
17518: ---------
17519: BEGIN
17520: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
17521: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id

Line 17522: FROM DUAL;

17518: ---------
17519: BEGIN
17520: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
17521: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id
17522: FROM DUAL;
17523: EXCEPTION
17524: WHEN OTHERS
17525: THEN
17526: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_XFR');

Line 17717: FROM DUAL;

17713: -----------create a dummy publication
17714: BEGIN
17715: SELECT cz_model_publications_s.NEXTVAL
17716: INTO cz_pb_mgr.v_publication_id
17717: FROM DUAL;
17718:
17719: v_pub_id := cz_pb_mgr.v_publication_id;
17720: EXCEPTION
17721: WHEN OTHERS

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

18272: cz_pb_mgr.g_source_flag := cz_model_migration_pvt.mig_source_flag;
18273: cz_pb_mgr.g_target_flag := cz_model_migration_pvt.mig_target_flag;
18274: END IF;
18275:
18276: ---------select run_id and user from dual
18277: BEGIN
18278: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
18279: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id
18280: FROM DUAL;

Line 18280: FROM DUAL;

18276: ---------select run_id and user from dual
18277: BEGIN
18278: SELECT USER, cz_xfr_run_infos_s.NEXTVAL
18279: INTO cz_pb_mgr.loguser, cz_pb_mgr.v_pb_run_id
18280: FROM DUAL;
18281: EXCEPTION
18282: WHEN OTHERS
18283: THEN
18284: RAISE run_id_error;

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

19102: IF (cz_pb_mgr.v_status_code <> PUBLICATION_ERROR) THEN
19103: IF (cz_pb_mgr.v_session_parameter = cz_model_migration_pvt.migrate_model) THEN
19104: EXECUTE IMMEDIATE 'SELECT REPLACE(cz_developer_utils_pvt.get_repository_path'
19105: || cz_pb_mgr.v_db_link
19106: || '(:1, ''FLD''), ''/'', ''.'') FROM DUAL'
19107: INTO l_tgt_fld_path
19108: USING cz_pb_mgr.g_migration_tgt_folder_id;
19109:
19110: IF (cz_pb_mgr.v_models_to_be_exported.COUNT > 0) THEN

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

19240: || cz_pb_mgr.v_db_link
19241: || ' WHERE deleted_flag = ''0'' AND devl_project_id = :2), 0),'
19242: || ' NVL((SELECT MAX(persistent_intl_text_id) FROM cz_localized_texts'
19243: || cz_pb_mgr.v_db_link
19244: || ' WHERE deleted_flag = ''0'' AND model_id = :3), 0)) FROM DUAL'
19245: INTO v_max_rec_id
19246: USING v_object_id, v_object_id, v_object_id;
19247:
19248:

Line 21079: FROM DUAL;

21075: x_status := 'OK';
21076:
21077: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21078: INTO v_new_publication_id, v_old_publication_id
21079: FROM DUAL;
21080:
21081: INSERT INTO cz_model_publications
21082: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
21083: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update

Line 21227: FROM DUAL;

21223: END IF;
21224:
21225: SELECT cz_model_publications_s.NEXTVAL, p_publication_id
21226: INTO v_new_publication_id, v_old_publication_id
21227: FROM DUAL;
21228:
21229: INSERT INTO cz_model_publications
21230: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode, ui_def_id, ui_style
21231: ,applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update, model_last_logic_update

Line 21477: FROM DUAL;

21473:
21474: ---get run id
21475: SELECT cz_xfr_run_infos_s.NEXTVAL
21476: INTO cz_pb_mgr.v_pb_run_id
21477: FROM DUAL;
21478:
21479: x_run_id := cz_pb_mgr.v_pb_run_id;
21480:
21481: ----get source pb info

Line 22051: FROM DUAL;

22047: END IF;
22048:
22049: SELECT cz_model_publications_s.NEXTVAL
22050: INTO v_new_publication_id
22051: FROM DUAL;
22052:
22053: INSERT INTO cz_model_publications
22054: (publication_id, model_id, server_id, organization_id, top_item_id, product_key, publication_mode
22055: ,ui_def_id, ui_style, applicable_from, applicable_until, export_status, deleted_flag, model_last_struct_update

Line 22831: FROM DUAL

22827: IF (what_exists = 'PSPROPVAL')
22828: THEN
22829: SELECT '1'
22830: INTO record_exists
22831: FROM DUAL
22832: WHERE EXISTS(SELECT property_id
22833: FROM cz_ps_prop_vals
22834: WHERE property_id = source_id);
22835: ELSIF(what_exists = 'ITPROPVAL')

Line 22839: FROM DUAL

22835: ELSIF(what_exists = 'ITPROPVAL')
22836: THEN
22837: SELECT '1'
22838: INTO record_exists
22839: FROM DUAL
22840: WHERE EXISTS(SELECT property_id
22841: FROM cz_item_property_values
22842: WHERE property_id = source_id);
22843: END IF;