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 114: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE);

110: ,x_status IN OUT NOCOPY VARCHAR2
111: );
112:
113: PROCEDURE rollback_data(p_db_link IN VARCHAR2);
114: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE);
115: ------------>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
116: -----------delete session variables
117: PROCEDURE delete_session_parameters
118: AS

Line 7319: v_source_major_version cz_db_settings.VALUE%TYPE;

7315: --------v_count when 0 is a failure else 1 indicates success
7316: FUNCTION validate_schema(target_server_id PLS_INTEGER)
7317: RETURN NUMBER
7318: IS
7319: v_source_major_version cz_db_settings.VALUE%TYPE;
7320: v_source_minor_version cz_db_settings.VALUE%TYPE;
7321: v_target_major_version cz_db_settings.VALUE%TYPE;
7322: v_target_minor_version cz_db_settings.VALUE%TYPE;
7323:

Line 7320: v_source_minor_version cz_db_settings.VALUE%TYPE;

7316: FUNCTION validate_schema(target_server_id PLS_INTEGER)
7317: RETURN NUMBER
7318: IS
7319: v_source_major_version cz_db_settings.VALUE%TYPE;
7320: v_source_minor_version cz_db_settings.VALUE%TYPE;
7321: v_target_major_version cz_db_settings.VALUE%TYPE;
7322: v_target_minor_version cz_db_settings.VALUE%TYPE;
7323:
7324: CURSOR db_link_cur(p_server_id PLS_INTEGER)

Line 7321: v_target_major_version cz_db_settings.VALUE%TYPE;

7317: RETURN NUMBER
7318: IS
7319: v_source_major_version cz_db_settings.VALUE%TYPE;
7320: v_source_minor_version cz_db_settings.VALUE%TYPE;
7321: v_target_major_version cz_db_settings.VALUE%TYPE;
7322: v_target_minor_version cz_db_settings.VALUE%TYPE;
7323:
7324: CURSOR db_link_cur(p_server_id PLS_INTEGER)
7325: IS

Line 7322: v_target_minor_version cz_db_settings.VALUE%TYPE;

7318: IS
7319: v_source_major_version cz_db_settings.VALUE%TYPE;
7320: v_source_minor_version cz_db_settings.VALUE%TYPE;
7321: v_target_major_version cz_db_settings.VALUE%TYPE;
7322: v_target_minor_version cz_db_settings.VALUE%TYPE;
7323:
7324: CURSOR db_link_cur(p_server_id PLS_INTEGER)
7325: IS
7326: SELECT local_name, fndnam_link_name

Line 7355: || 'from cz_db_settings,'

7351: v_count := 1;
7352: ELSE
7353: OPEN db_schema_compare_cur FOR ' select count(*)'
7354: || ' '
7355: || 'from cz_db_settings,'
7356: || ' '
7357: || 'cz_db_settings'
7358: || v_db_link
7359: || ' tgt'

Line 7357: || 'cz_db_settings'

7353: OPEN db_schema_compare_cur FOR ' select count(*)'
7354: || ' '
7355: || 'from cz_db_settings,'
7356: || ' '
7357: || 'cz_db_settings'
7358: || v_db_link
7359: || ' tgt'
7360: || ' '
7361: || 'where cz_db_settings.setting_id = tgt.setting_id'

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

7357: || 'cz_db_settings'
7358: || v_db_link
7359: || ' tgt'
7360: || ' '
7361: || 'where cz_db_settings.setting_id = tgt.setting_id'
7362: || ' '
7363: || 'and cz_db_settings.value = tgt.value'
7364: || ' '
7365: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''

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

7359: || ' tgt'
7360: || ' '
7361: || 'where cz_db_settings.setting_id = tgt.setting_id'
7362: || ' '
7363: || 'and cz_db_settings.value = tgt.value'
7364: || ' '
7365: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''
7366: || ' '
7367: || 'INTERSECT'

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

7361: || 'where cz_db_settings.setting_id = tgt.setting_id'
7362: || ' '
7363: || 'and cz_db_settings.value = tgt.value'
7364: || ' '
7365: || 'and cz_db_settings.setting_id = ''MAJOR_VERSION'''
7366: || ' '
7367: || 'INTERSECT'
7368: || ' '
7369: || 'select count(*)'

Line 7371: || 'from cz_db_settings,'

7367: || 'INTERSECT'
7368: || ' '
7369: || 'select count(*)'
7370: || ' '
7371: || 'from cz_db_settings,'
7372: || ' '
7373: || 'cz_db_settings'
7374: || v_db_link
7375: || ' tgt'

Line 7373: || 'cz_db_settings'

7369: || 'select count(*)'
7370: || ' '
7371: || 'from cz_db_settings,'
7372: || ' '
7373: || 'cz_db_settings'
7374: || v_db_link
7375: || ' tgt'
7376: || ' '
7377: || 'where cz_db_settings.setting_id = tgt.setting_id'

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

7373: || 'cz_db_settings'
7374: || v_db_link
7375: || ' tgt'
7376: || ' '
7377: || 'where cz_db_settings.setting_id = tgt.setting_id'
7378: || ' '
7379: || 'and cz_db_settings.value = tgt.value'
7380: || ' '
7381: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';

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

7375: || ' tgt'
7376: || ' '
7377: || 'where cz_db_settings.setting_id = tgt.setting_id'
7378: || ' '
7379: || 'and cz_db_settings.value = tgt.value'
7380: || ' '
7381: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
7382:
7383: LOOP

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

7377: || 'where cz_db_settings.setting_id = tgt.setting_id'
7378: || ' '
7379: || 'and cz_db_settings.value = tgt.value'
7380: || ' '
7381: || 'and cz_db_settings.setting_id = ''MINOR_VERSION'' ';
7382:
7383: LOOP
7384: FETCH db_schema_compare_cur
7385: INTO v_count;

Line 7397: FROM cz_db_settings

7393: --------set commit size variable
7394: BEGIN
7395: SELECT VALUE
7396: INTO cz_pb_mgr.record_commit_size
7397: FROM cz_db_settings
7398: WHERE cz_db_settings.setting_id = record_commit_str;
7399: EXCEPTION
7400: WHEN OTHERS
7401: THEN

Line 7398: WHERE cz_db_settings.setting_id = record_commit_str;

7394: BEGIN
7395: SELECT VALUE
7396: INTO cz_pb_mgr.record_commit_size
7397: FROM cz_db_settings
7398: WHERE cz_db_settings.setting_id = record_commit_str;
7399: EXCEPTION
7400: WHEN OTHERS
7401: THEN
7402: cz_pb_mgr.record_commit_size := 500;

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

13969: END insert_devl_projects;
13970:
13971: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
13972: ---------procedure retrieves the value of sequence incrementor
13973: PROCEDURE get_seq_incrementor(x_oraclesequenceincr IN OUT NOCOPY cz_db_settings.VALUE%TYPE)
13974: AS
13975: BEGIN
13976: SELECT VALUE
13977: INTO x_oraclesequenceincr

Line 13978: FROM cz_db_settings

13974: AS
13975: BEGIN
13976: SELECT VALUE
13977: INTO x_oraclesequenceincr
13978: FROM cz_db_settings
13979: WHERE cz_db_settings.setting_id = sequence_incr_str;
13980: EXCEPTION
13981: WHEN OTHERS
13982: THEN

Line 13979: WHERE cz_db_settings.setting_id = sequence_incr_str;

13975: BEGIN
13976: SELECT VALUE
13977: INTO x_oraclesequenceincr
13978: FROM cz_db_settings
13979: WHERE cz_db_settings.setting_id = sequence_incr_str;
13980: EXCEPTION
13981: WHEN OTHERS
13982: THEN
13983: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_SEQ_INCR');

Line 13997: FROM cz_db_settings

13993: IF (cz_pb_mgr.v_session_parameter = pub_model)
13994: THEN
13995: SELECT VALUE
13996: INTO x_copyrules
13997: FROM cz_db_settings
13998: WHERE cz_db_settings.setting_id = rule_copy;
13999: ELSE
14000: x_copyrules := copy_rules;
14001: END IF;

Line 13998: WHERE cz_db_settings.setting_id = rule_copy;

13994: THEN
13995: SELECT VALUE
13996: INTO x_copyrules
13997: FROM cz_db_settings
13998: WHERE cz_db_settings.setting_id = rule_copy;
13999: ELSE
14000: x_copyrules := copy_rules;
14001: END IF;
14002: EXCEPTION

Line 14009: -----procedureto to get multi Publication flag from cz_db_settings. SUN ER

14005: x_copyrules := 'YES';
14006: END;
14007: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
14008: -----bug #10417318
14009: -----procedureto to get multi Publication flag from cz_db_settings. SUN ER
14010: -----If this flag is Yes, then only we will allow multi server publication
14011: PROCEDURE get_multi_server_pub_flg
14012: AS
14013: BEGIN

Line 14018: FROM cz_db_settings

14014: IF (CZ_PB_MGR.v_session_parameter = PUB_MODEL)
14015: THEN
14016: SELECT DECODE(UPPER(value),'TRUE','YES','FALSE','NO','T','YES','F','NO','1','YES','0','NO','YES','YES','NO','NO','Y','YES','N','NO','NO')
14017: INTO vMultiServerPub
14018: FROM cz_db_settings
14019: WHERE UPPER(cz_db_settings.setting_id) = UPPER(MULTI_SERVER_PUB);
14020: END IF;
14021: EXCEPTION
14022: WHEN OTHERS

Line 14019: WHERE UPPER(cz_db_settings.setting_id) = UPPER(MULTI_SERVER_PUB);

14015: THEN
14016: SELECT DECODE(UPPER(value),'TRUE','YES','FALSE','NO','T','YES','F','NO','1','YES','0','NO','YES','YES','NO','NO','Y','YES','N','NO','NO')
14017: INTO vMultiServerPub
14018: FROM cz_db_settings
14019: WHERE UPPER(cz_db_settings.setting_id) = UPPER(MULTI_SERVER_PUB);
14020: END IF;
14021: EXCEPTION
14022: WHEN OTHERS
14023: THEN

Line 14028: -----procedureto to get single Publication Language from cz_db_settings. SUN ER

14024: vMultiServerPub := 'NO';
14025: END;
14026:
14027: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
14028: -----procedureto to get single Publication Language from cz_db_settings. SUN ER
14029: PROCEDURE get_single_pb_language
14030: AS
14031: BEGIN
14032: IF (CZ_PB_MGR.v_session_parameter = PUB_MODEL)

Line 14036: FROM cz_db_settings

14032: IF (CZ_PB_MGR.v_session_parameter = PUB_MODEL)
14033: THEN
14034: SELECT UPPER(value)
14035: INTO vPubSingleLang
14036: FROM cz_db_settings
14037: WHERE UPPER(cz_db_settings.setting_id) = PUB_LANGUAGE;
14038: END IF;
14039: EXCEPTION
14040: WHEN OTHERS

Line 14037: WHERE UPPER(cz_db_settings.setting_id) = PUB_LANGUAGE;

14033: THEN
14034: SELECT UPPER(value)
14035: INTO vPubSingleLang
14036: FROM cz_db_settings
14037: WHERE UPPER(cz_db_settings.setting_id) = PUB_LANGUAGE;
14038: END IF;
14039: EXCEPTION
14040: WHEN OTHERS
14041: THEN

Line 14045: -----procedureto to get Bulk Remote Publication from cz_db_settings.

14041: THEN
14042: vPubSingleLang := NULL;
14043: END;
14044:
14045: -----procedureto to get Bulk Remote Publication from cz_db_settings.
14046: PROCEDURE get_remote_select_insert
14047: AS
14048: BEGIN
14049: IF (CZ_PB_MGR.v_session_parameter = PUB_MODEL)

Line 14053: FROM cz_db_settings

14049: IF (CZ_PB_MGR.v_session_parameter = PUB_MODEL)
14050: THEN
14051: SELECT UPPER(value)
14052: INTO vBulkSelectInsert
14053: FROM cz_db_settings
14054: WHERE cz_db_settings.setting_id = BULK_SELECT_INSERT;
14055: END IF;
14056: EXCEPTION
14057: WHEN OTHERS

Line 14054: WHERE cz_db_settings.setting_id = BULK_SELECT_INSERT;

14050: THEN
14051: SELECT UPPER(value)
14052: INTO vBulkSelectInsert
14053: FROM cz_db_settings
14054: WHERE cz_db_settings.setting_id = BULK_SELECT_INSERT;
14055: END IF;
14056: EXCEPTION
14057: WHEN OTHERS
14058: THEN

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

17866: resolution_status VARCHAR2(200);
17867: v_copy_rules_flag VARCHAR2(3) := '';
17868: plsql_table_list cz_pb_mgr.col_plsql_table_list;
17869: BEGIN
17870: -------select value of setting id CopyRules from cz_db_settings
17871: IF (cz_pb_mgr.g_log_timing = publication_timing)
17872: THEN
17873: log_timing_message('start get_copy_rules_flg');
17874: END IF;

Line 18277: l_expl_check_flag cz_db_settings.value%TYPE;

18273: v_model_count NUMBER := 1;
18274: v_validate_count NUMBER;
18275: mm_models_to_be_migrated cz_pb_mgr.t_ref;
18276:
18277: l_expl_check_flag cz_db_settings.value%TYPE;
18278: l_run_id NUMBER := cz_pb_mgr.v_pb_run_id;
18279: l_msg_count NUMBER;
18280: l_msg_data VARCHAR2(32000);
18281: l_return_status VARCHAR2(16);

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

18283: BEGIN
18284: v_next_sequence_gen.DELETE;
18285: v_sequence_count.DELETE;
18286:
18287: ------retrieve seq incrementor from cz_db_settings
18288: IF (cz_pb_mgr.g_log_timing = publication_timing)
18289: THEN
18290: log_timing_message('start get_seq_incrementor');
18291: END IF;

Line 18421: INTO l_expl_check_flag FROM cz_db_settings

18417: IF(cz_pb_mgr.v_status_code <> PUBLICATION_ERROR)THEN
18418:
18419: BEGIN
18420: SELECT DECODE(UPPER(value), 'Y', 'Y', 'YES', 'Y', '1', 'Y', 'ON', 'Y', 'N')
18421: INTO l_expl_check_flag FROM cz_db_settings
18422: WHERE UPPER(section_name) = 'PUBLICATION'
18423: AND UPPER(setting_id) = 'CheckExplosionStructure';
18424: EXCEPTION
18425: WHEN OTHERS THEN

Line 19381: l_log_pb_time cz_db_settings.VALUE%TYPE;

19377: --------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
19378: -----initialize pb parameters
19379: PROCEDURE initialize_pb_parameters(p_publication_id IN cz_model_publications.publication_id%TYPE)
19380: AS
19381: l_log_pb_time cz_db_settings.VALUE%TYPE;
19382: l_pub_mode cz_model_publications.publication_mode%TYPE;
19383: BEGIN
19384: fnd_msg_pub.initialize;
19385: cz_pb_mgr.v_publication_id := p_publication_id;

Line 19428: FROM cz_db_settings

19424: -------select setting for logging
19425: BEGIN
19426: SELECT VALUE
19427: INTO cz_pb_mgr.v_pb_log_flag
19428: FROM cz_db_settings
19429: WHERE cz_db_settings.setting_id = publication_log;
19430: EXCEPTION
19431: WHEN OTHERS
19432: THEN

Line 19429: WHERE cz_db_settings.setting_id = publication_log;

19425: BEGIN
19426: SELECT VALUE
19427: INTO cz_pb_mgr.v_pb_log_flag
19428: FROM cz_db_settings
19429: WHERE cz_db_settings.setting_id = publication_log;
19430: EXCEPTION
19431: WHEN OTHERS
19432: THEN
19433: cz_pb_mgr.v_pb_log_flag := 'NO';

Line 19440: FROM cz_db_settings

19436: -------select setting for logging publication times
19437: BEGIN
19438: SELECT VALUE
19439: INTO l_log_pb_time
19440: FROM cz_db_settings
19441: WHERE cz_db_settings.setting_id = pb_timing_log;
19442:
19443: IF (l_log_pb_time = 'YES')
19444: THEN

Line 19441: WHERE cz_db_settings.setting_id = pb_timing_log;

19437: BEGIN
19438: SELECT VALUE
19439: INTO l_log_pb_time
19440: FROM cz_db_settings
19441: WHERE cz_db_settings.setting_id = pb_timing_log;
19442:
19443: IF (l_log_pb_time = 'YES')
19444: THEN
19445: cz_pb_mgr.g_log_timing := publication_timing;