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_MODEL_USAGES

Line 7433: FROM cz_model_usages;

7429:
7430: BEGIN
7431: SELECT model_usage_id
7432: BULK COLLECT INTO cz_pb_mgr.v_model_usages_tbl
7433: FROM cz_model_usages;
7434: EXCEPTION
7435: WHEN NO_DATA_FOUND
7436: THEN
7437: cz_pb_mgr.v_err_message := 'No model usages found';

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

7437: cz_pb_mgr.v_err_message := 'No model usages found';
7438: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7439: WHEN OTHERS
7440: THEN
7441: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
7442: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7443: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7444: RAISE;
7445: END;

Line 7451: || ' DELETE FROM CZ_MODEL_USAGES'

7447: IF (cz_pb_mgr.v_model_usages_tbl.COUNT > 0)
7448: THEN
7449: l_sql_string :=
7450: 'BEGIN '
7451: || ' DELETE FROM CZ_MODEL_USAGES'
7452: || cz_pb_mgr.v_db_link
7453: || '; '
7454: || ' '
7455: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'

Line 7459: || 'INSERT INTO cz_model_usages'

7455: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'
7456: || ' '
7457: || 'LOOP'
7458: || ' '
7459: || 'INSERT INTO cz_model_usages'
7460: || cz_pb_mgr.v_db_link
7461: || ' '
7462: || '(MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE)'
7463: || ' '

Line 7464: || 'SELECT MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE FROM cz_model_usages t'

7460: || cz_pb_mgr.v_db_link
7461: || ' '
7462: || '(MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE)'
7463: || ' '
7464: || 'SELECT MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE FROM cz_model_usages t'
7465: || ' '
7466: || 'WHERE t.model_usage_id = cz_pb_mgr.v_model_usages_tbl(i);'
7467: || ' '
7468: || 'END LOOP;'

Line 7481: FROM cz_model_usages_tl;

7477:
7478: BEGIN
7479: SELECT model_usage_id, LANGUAGE
7480: BULK COLLECT INTO cz_pb_mgr.v_model_usages_tbl, v_usages_lang_tbl
7481: FROM cz_model_usages_tl;
7482: EXCEPTION
7483: WHEN NO_DATA_FOUND
7484: THEN
7485: cz_pb_mgr.v_err_message := 'No model usages translations found';

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

7485: cz_pb_mgr.v_err_message := 'No model usages translations found';
7486: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7487: WHEN OTHERS
7488: THEN
7489: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);
7490: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
7491: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7492: RAISE;
7493: END;

Line 7499: || 'DELETE FROM CZ_MODEL_USAGES_TL'

7495: IF (cz_pb_mgr.v_model_usages_tbl.COUNT > 0)
7496: THEN
7497: EXECUTE IMMEDIATE 'BEGIN'
7498: || ' '
7499: || 'DELETE FROM CZ_MODEL_USAGES_TL'
7500: || cz_pb_mgr.v_db_link
7501: || ';'
7502: || ' '
7503: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'

Line 7509: || 'INSERT INTO cz_model_usages_tl'

7505: || 'LOOP'
7506: || ' '
7507: || 'BEGIN'
7508: || ' '
7509: || 'INSERT INTO cz_model_usages_tl'
7510: || cz_pb_mgr.v_db_link
7511: || ' '
7512: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
7513: || ' '

Line 7514: || 'SELECT MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION FROM cz_model_usages_tl t'

7510: || cz_pb_mgr.v_db_link
7511: || ' '
7512: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
7513: || ' '
7514: || 'SELECT MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION FROM cz_model_usages_tl t'
7515: || ' '
7516: || 'WHERE t.model_usage_id = cz_pb_mgr.v_model_usages_tbl(i)'
7517: || ' '
7518: || 'and t.language=cz_pb_mgr.v_usages_lang_tbl(i);'

Line 7533: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);

7529: EXCEPTION
7530: WHEN OTHERS
7531: THEN
7532: ROLLBACK;
7533: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
7534: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USAGES', SQLCODE);
7535: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
7536: RAISE;
7537: END load_usages;

Line 14260: FROM cz_model_usages

14256: IF (TO_NUMBER(l_str) = 1)
14257: THEN
14258: SELECT NAME, model_usage_id
14259: INTO l_name, l_id
14260: FROM cz_model_usages
14261: WHERE model_usage_id = l_cnt;
14262:
14263: p_old_usage_name_to_id_map(l_cnt) := l_name;
14264: END IF;

Line 14301: l_usage_id cz_model_usages.model_usage_id%TYPE;

14297: l_previous_mask VARCHAR2(16) := v_default_eff_usg_mask;
14298: l_avail_usage_id NUMBER;
14299: l_effective_usage VARCHAR2(2000);
14300: usageid NUMBER;
14301: l_usage_id cz_model_usages.model_usage_id%TYPE;
14302: l_usage_name cz_model_usages.NAME%TYPE;
14303: l_usage_desc cz_model_usages.description%TYPE;
14304: l_index_ps_to_eff NUMBER;
14305: l_index_usage_name_to_id NUMBER;

Line 14302: l_usage_name cz_model_usages.NAME%TYPE;

14298: l_avail_usage_id NUMBER;
14299: l_effective_usage VARCHAR2(2000);
14300: usageid NUMBER;
14301: l_usage_id cz_model_usages.model_usage_id%TYPE;
14302: l_usage_name cz_model_usages.NAME%TYPE;
14303: l_usage_desc cz_model_usages.description%TYPE;
14304: l_index_ps_to_eff NUMBER;
14305: l_index_usage_name_to_id NUMBER;
14306: l_count NUMBER;

Line 14303: l_usage_desc cz_model_usages.description%TYPE;

14299: l_effective_usage VARCHAR2(2000);
14300: usageid NUMBER;
14301: l_usage_id cz_model_usages.model_usage_id%TYPE;
14302: l_usage_name cz_model_usages.NAME%TYPE;
14303: l_usage_desc cz_model_usages.description%TYPE;
14304: l_index_ps_to_eff NUMBER;
14305: l_index_usage_name_to_id NUMBER;
14306: l_count NUMBER;
14307: rec_count NUMBER := 0;

Line 14349: || 'from cz_model_usages'

14345: -- 2. usage name to new remote usage id that is commited.
14346: IF (cz_pb_mgr.g_usg_name_processed.COUNT = 0 OR (NOT cz_pb_mgr.g_usg_name_processed.EXISTS(l_usage_name))) THEN
14347: OPEN remote_usage FOR 'Select model_usage_id, name, description '
14348: || ' '
14349: || 'from cz_model_usages'
14350: || cz_pb_mgr.v_db_link
14351: || ' t'
14352: || ' '
14353: || 'where t.name = :1' USING l_usage_name;

Line 14360: OPEN avail_usage_cur FOR 'select min(model_usage_id) from cz_model_usages' || cz_pb_mgr.v_db_link || 'where in_use=''X''';

14356: INTO l_usage_id, l_usage_name, l_usage_desc;
14357:
14358: IF (l_usage_id IS NULL)
14359: THEN
14360: OPEN avail_usage_cur FOR 'select min(model_usage_id) from cz_model_usages' || cz_pb_mgr.v_db_link || 'where in_use=''X''';
14361:
14362: FETCH avail_usage_cur
14363: INTO l_avail_usage_id;
14364:

Line 14370: cz_utils.get_text('CZDEV_MAX_USAGES_CREATED_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);

14366: THEN
14367: --Raise migration failure.
14368: --Proposed: Usage Limit maxed out during the migration process.
14369: cz_pb_mgr.v_err_message :=
14370: cz_utils.get_text('CZDEV_MAX_USAGES_CREATED_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
14371: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.resolve_effective_usage_mask', SQLCODE);
14372: cz_pb_mgr.v_status_code := 0; -- MIGRATION_ERROR;
14373: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
14374: RAISE NO_DATA_FOUND;

Line 14377: --Insert into cz_model_usages, use execute immediate

14373: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
14374: RAISE NO_DATA_FOUND;
14375: ELSE
14376: l_usage_id := l_avail_usage_id;
14377: --Insert into cz_model_usages, use execute immediate
14378: l_str :=
14379: 'update cz_model_usages'
14380: || cz_pb_mgr.v_db_link
14381: || ' '

Line 14379: 'update cz_model_usages'

14375: ELSE
14376: l_usage_id := l_avail_usage_id;
14377: --Insert into cz_model_usages, use execute immediate
14378: l_str :=
14379: 'update cz_model_usages'
14380: || cz_pb_mgr.v_db_link
14381: || ' '
14382: || 'set name = :1,'
14383: || ' '