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_DB_SETTINGS

Line 70: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE);

66: ,x_status IN OUT NOCOPY VARCHAR2
67: );
68:
69: PROCEDURE rollback_data(p_db_link IN VARCHAR2);
70: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE);
71: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
72: -----------delete session variables
73: PROCEDURE delete_session_parameters
74: AS

Line 6598: v_source_major_version cz_db_settings.VALUE%TYPE;

6594: --------v_count when 0 is a failure else 1 indicates success
6595: FUNCTION validate_schema(target_server_id PLS_INTEGER)
6596: RETURN NUMBER
6597: IS
6598: v_source_major_version cz_db_settings.VALUE%TYPE;
6599: v_source_minor_version cz_db_settings.VALUE%TYPE;
6600: v_target_major_version cz_db_settings.VALUE%TYPE;
6601: v_target_minor_version cz_db_settings.VALUE%TYPE;
6602:

Line 6599: v_source_minor_version cz_db_settings.VALUE%TYPE;

6595: FUNCTION validate_schema(target_server_id PLS_INTEGER)
6596: RETURN NUMBER
6597: IS
6598: v_source_major_version cz_db_settings.VALUE%TYPE;
6599: v_source_minor_version cz_db_settings.VALUE%TYPE;
6600: v_target_major_version cz_db_settings.VALUE%TYPE;
6601: v_target_minor_version cz_db_settings.VALUE%TYPE;
6602:
6603: CURSOR db_link_cur(p_server_id PLS_INTEGER)

Line 6600: v_target_major_version cz_db_settings.VALUE%TYPE;

6596: RETURN NUMBER
6597: IS
6598: v_source_major_version cz_db_settings.VALUE%TYPE;
6599: v_source_minor_version cz_db_settings.VALUE%TYPE;
6600: v_target_major_version cz_db_settings.VALUE%TYPE;
6601: v_target_minor_version cz_db_settings.VALUE%TYPE;
6602:
6603: CURSOR db_link_cur(p_server_id PLS_INTEGER)
6604: IS

Line 6601: v_target_minor_version cz_db_settings.VALUE%TYPE;

6597: IS
6598: v_source_major_version cz_db_settings.VALUE%TYPE;
6599: v_source_minor_version cz_db_settings.VALUE%TYPE;
6600: v_target_major_version cz_db_settings.VALUE%TYPE;
6601: v_target_minor_version cz_db_settings.VALUE%TYPE;
6602:
6603: CURSOR db_link_cur(p_server_id PLS_INTEGER)
6604: IS
6605: SELECT local_name, fndnam_link_name

Line 6634: || 'from cz_db_settings,'

6630: v_count := 1;
6631: ELSE
6632: OPEN db_schema_compare_cur FOR ' select count(*)'
6633: || ' '
6634: || 'from cz_db_settings,'
6635: || ' '
6636: || 'cz_db_settings'
6637: || v_db_link
6638: || ' tgt'

Line 6636: || 'cz_db_settings'

6632: OPEN db_schema_compare_cur FOR ' select count(*)'
6633: || ' '
6634: || 'from cz_db_settings,'
6635: || ' '
6636: || 'cz_db_settings'
6637: || v_db_link
6638: || ' tgt'
6639: || ' '
6640: || 'where cz_db_settings.setting_id = tgt.setting_id'

Line 6640: || 'where cz_db_settings.setting_id = tgt.setting_id'

6636: || 'cz_db_settings'
6637: || v_db_link
6638: || ' tgt'
6639: || ' '
6640: || 'where cz_db_settings.setting_id = tgt.setting_id'
6641: || ' '
6642: || 'and cz_db_settings.value = tgt.value'
6643: || ' '
6644: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''

Line 6642: || 'and cz_db_settings.value = tgt.value'

6638: || ' tgt'
6639: || ' '
6640: || 'where cz_db_settings.setting_id = tgt.setting_id'
6641: || ' '
6642: || 'and cz_db_settings.value = tgt.value'
6643: || ' '
6644: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''
6645: || ' '
6646: || 'INTERSECT'

Line 6644: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''

6640: || 'where cz_db_settings.setting_id = tgt.setting_id'
6641: || ' '
6642: || 'and cz_db_settings.value = tgt.value'
6643: || ' '
6644: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''
6645: || ' '
6646: || 'INTERSECT'
6647: || ' '
6648: || 'select count(*)'

Line 6650: || 'from cz_db_settings,'

6646: || 'INTERSECT'
6647: || ' '
6648: || 'select count(*)'
6649: || ' '
6650: || 'from cz_db_settings,'
6651: || ' '
6652: || 'cz_db_settings'
6653: || v_db_link
6654: || ' tgt'

Line 6652: || 'cz_db_settings'

6648: || 'select count(*)'
6649: || ' '
6650: || 'from cz_db_settings,'
6651: || ' '
6652: || 'cz_db_settings'
6653: || v_db_link
6654: || ' tgt'
6655: || ' '
6656: || 'where cz_db_settings.setting_id = tgt.setting_id'

Line 6656: || 'where cz_db_settings.setting_id = tgt.setting_id'

6652: || 'cz_db_settings'
6653: || v_db_link
6654: || ' tgt'
6655: || ' '
6656: || 'where cz_db_settings.setting_id = tgt.setting_id'
6657: || ' '
6658: || 'and cz_db_settings.value = tgt.value'
6659: || ' '
6660: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';

Line 6658: || 'and cz_db_settings.value = tgt.value'

6654: || ' tgt'
6655: || ' '
6656: || 'where cz_db_settings.setting_id = tgt.setting_id'
6657: || ' '
6658: || 'and cz_db_settings.value = tgt.value'
6659: || ' '
6660: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
6661:
6662: LOOP

Line 6660: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';

6656: || 'where cz_db_settings.setting_id = tgt.setting_id'
6657: || ' '
6658: || 'and cz_db_settings.value = tgt.value'
6659: || ' '
6660: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
6661:
6662: LOOP
6663: FETCH db_schema_compare_cur
6664: INTO v_count;

Line 6676: FROM cz_db_settings

6672: --------set commit size variable
6673: BEGIN
6674: SELECT VALUE
6675: INTO cz_pb_mgr.record_commit_size
6676: FROM cz_db_settings
6677: WHERE cz_db_settings.setting_id = record_commit_str;
6678: EXCEPTION
6679: WHEN OTHERS
6680: THEN

Line 6677: WHERE cz_db_settings.setting_id = record_commit_str;

6673: BEGIN
6674: SELECT VALUE
6675: INTO cz_pb_mgr.record_commit_size
6676: FROM cz_db_settings
6677: WHERE cz_db_settings.setting_id = record_commit_str;
6678: EXCEPTION
6679: WHEN OTHERS
6680: THEN
6681: cz_pb_mgr.record_commit_size := 500;

Line 12972: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE)

12968: END insert_devl_projects;
12969:
12970: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
12971: ---------procedure retrieves the value of sequence incrementor
12972: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE)
12973: AS
12974: BEGIN
12975: SELECT VALUE
12976: INTO x_oraclesequenceincr

Line 12977: FROM cz_db_settings

12973: AS
12974: BEGIN
12975: SELECT VALUE
12976: INTO x_oraclesequenceincr
12977: FROM cz_db_settings
12978: WHERE cz_db_settings.setting_id = sequence_incr_str;
12979: EXCEPTION
12980: WHEN OTHERS
12981: THEN

Line 12978: WHERE cz_db_settings.setting_id = sequence_incr_str;

12974: BEGIN
12975: SELECT VALUE
12976: INTO x_oraclesequenceincr
12977: FROM cz_db_settings
12978: WHERE cz_db_settings.setting_id = sequence_incr_str;
12979: EXCEPTION
12980: WHEN OTHERS
12981: THEN
12982: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_INCR');

Line 12996: FROM cz_db_settings

12992: IF (cz_pb_mgr.v_session_parameter = pub_model)
12993: THEN
12994: SELECT VALUE
12995: INTO x_copyrules
12996: FROM cz_db_settings
12997: WHERE cz_db_settings.setting_id = rule_copy;
12998: ELSE
12999: x_copyrules := copy_rules;
13000: END IF;

Line 12997: WHERE cz_db_settings.setting_id = rule_copy;

12993: THEN
12994: SELECT VALUE
12995: INTO x_copyrules
12996: FROM cz_db_settings
12997: WHERE cz_db_settings.setting_id = rule_copy;
12998: ELSE
12999: x_copyrules := copy_rules;
13000: END IF;
13001: EXCEPTION

Line 16733: -------select value of setting id CopyRules from cz_db_settings

16729: resolution_status VARCHAR2(200);
16730: v_copy_rules_flag VARCHAR2(3) := '';
16731: plsql_table_list cz_pb_mgr.col_plsql_table_list;
16732: BEGIN
16733: -------select value of setting id CopyRules from cz_db_settings
16734: IF (cz_pb_mgr.g_log_timing = publication_timing)
16735: THEN
16736: log_timing_message('start get_copy_rules_flg');
16737: END IF;

Line 17134: l_expl_check_flag cz_db_settings.value%TYPE;

17130: v_model_count NUMBER := 1;
17131: v_validate_count NUMBER;
17132: mm_models_to_be_migrated cz_pb_mgr.t_ref;
17133:
17134: l_expl_check_flag cz_db_settings.value%TYPE;
17135: l_run_id NUMBER := cz_pb_mgr.v_pb_run_id;
17136: l_msg_count NUMBER;
17137: l_msg_data VARCHAR2(32000);
17138: l_return_status VARCHAR2(16);

Line 17144: ------retrieve seq incrementor from cz_db_settings

17140: BEGIN
17141: v_next_sequence_gen.DELETE;
17142: v_sequence_count.DELETE;
17143:
17144: ------retrieve seq incrementor from cz_db_settings
17145: IF (cz_pb_mgr.g_log_timing = publication_timing)
17146: THEN
17147: log_timing_message('start get_seq_incrementor');
17148: END IF;

Line 17278: INTO l_expl_check_flag FROM cz_db_settings

17274: IF(cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)THEN
17275:
17276: BEGIN
17277: SELECT DECODE(UPPER(value), 'Y', 'Y', 'YES', 'Y', '1', 'Y', 'ON', 'Y', 'N')
17278: INTO l_expl_check_flag FROM cz_db_settings
17279: WHERE UPPER(section_name) = 'PUBLICATION'
17280: AND UPPER(setting_id) = 'CheckExplosionStructure';
17281: EXCEPTION
17282: WHEN OTHERS THEN

Line 18244: l_log_pb_time cz_db_settings.VALUE%TYPE;

18240: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
18241: -----initialize pb parameters
18242: PROCEDURE initialize_pb_parameters(p_publication_id IN cz_model_publications.publication_id%TYPE)
18243: AS
18244: l_log_pb_time cz_db_settings.VALUE%TYPE;
18245: l_pub_mode cz_model_publications.publication_mode%TYPE;
18246: BEGIN
18247: fnd_msg_pub.initialize;
18248: cz_pb_mgr.v_publication_id := p_publication_id;

Line 18291: FROM cz_db_settings

18287: -------select setting for logging
18288: BEGIN
18289: SELECT VALUE
18290: INTO cz_pb_mgr.v_pb_log_flag
18291: FROM cz_db_settings
18292: WHERE cz_db_settings.setting_id = publication_log;
18293: EXCEPTION
18294: WHEN OTHERS
18295: THEN

Line 18292: WHERE cz_db_settings.setting_id = publication_log;

18288: BEGIN
18289: SELECT VALUE
18290: INTO cz_pb_mgr.v_pb_log_flag
18291: FROM cz_db_settings
18292: WHERE cz_db_settings.setting_id = publication_log;
18293: EXCEPTION
18294: WHEN OTHERS
18295: THEN
18296: cz_pb_mgr.v_pb_log_flag := 'NO';

Line 18303: FROM cz_db_settings

18299: -------select setting for logging publication times
18300: BEGIN
18301: SELECT VALUE
18302: INTO l_log_pb_time
18303: FROM cz_db_settings
18304: WHERE cz_db_settings.setting_id = pb_timing_log;
18305:
18306: IF (l_log_pb_time = 'YES')
18307: THEN

Line 18304: WHERE cz_db_settings.setting_id = pb_timing_log;

18300: BEGIN
18301: SELECT VALUE
18302: INTO l_log_pb_time
18303: FROM cz_db_settings
18304: WHERE cz_db_settings.setting_id = pb_timing_log;
18305:
18306: IF (l_log_pb_time = 'YES')
18307: THEN
18308: cz_pb_mgr.g_log_timing := publication_timing;