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 6712: FROM cz_model_usages;

6708:
6709: BEGIN
6710: SELECT model_usage_id
6711: BULK COLLECT INTO cz_pb_mgr.v_model_usages_tbl
6712: FROM cz_model_usages;
6713: EXCEPTION
6714: WHEN NO_DATA_FOUND
6715: THEN
6716: cz_pb_mgr.v_err_message := 'No model usages found';

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

6716: cz_pb_mgr.v_err_message := 'No model usages found';
6717: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6718: WHEN OTHERS
6719: THEN
6720: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
6721: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6722: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6723: RAISE;
6724: END;

Line 6730: || ' DELETE FROM CZ_MODEL_USAGES'

6726: IF (cz_pb_mgr.v_model_usages_tbl.COUNT > 0)
6727: THEN
6728: l_sql_string :=
6729: 'BEGIN '
6730: || ' DELETE FROM CZ_MODEL_USAGES'
6731: || cz_pb_mgr.v_db_link
6732: || '; '
6733: || ' '
6734: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'

Line 6738: || 'INSERT INTO cz_model_usages'

6734: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'
6735: || ' '
6736: || 'LOOP'
6737: || ' '
6738: || 'INSERT INTO cz_model_usages'
6739: || cz_pb_mgr.v_db_link
6740: || ' '
6741: || '(MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE)'
6742: || ' '

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

6739: || cz_pb_mgr.v_db_link
6740: || ' '
6741: || '(MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE)'
6742: || ' '
6743: || 'SELECT MODEL_USAGE_ID,NAME,DESCRIPTION,NOTE,IN_USE FROM cz_model_usages t'
6744: || ' '
6745: || 'WHERE t.model_usage_id = cz_pb_mgr.v_model_usages_tbl(i);'
6746: || ' '
6747: || 'END LOOP;'

Line 6760: FROM cz_model_usages_tl;

6756:
6757: BEGIN
6758: SELECT model_usage_id, LANGUAGE
6759: BULK COLLECT INTO cz_pb_mgr.v_model_usages_tbl, v_usages_lang_tbl
6760: FROM cz_model_usages_tl;
6761: EXCEPTION
6762: WHEN NO_DATA_FOUND
6763: THEN
6764: cz_pb_mgr.v_err_message := 'No model usages translations found';

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

6764: cz_pb_mgr.v_err_message := 'No model usages translations found';
6765: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6766: WHEN OTHERS
6767: THEN
6768: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_model_usages_tl', 'SQLERRM', SQLERRM);
6769: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USGS', SQLCODE);
6770: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6771: RAISE;
6772: END;

Line 6778: || 'DELETE FROM CZ_MODEL_USAGES_TL'

6774: IF (cz_pb_mgr.v_model_usages_tbl.COUNT > 0)
6775: THEN
6776: EXECUTE IMMEDIATE 'BEGIN'
6777: || ' '
6778: || 'DELETE FROM CZ_MODEL_USAGES_TL'
6779: || cz_pb_mgr.v_db_link
6780: || ';'
6781: || ' '
6782: || 'FOR I IN cz_pb_mgr.v_model_usages_tbl.FIRST..cz_pb_mgr.v_model_usages_tbl.LAST'

Line 6788: || 'INSERT INTO cz_model_usages_tl'

6784: || 'LOOP'
6785: || ' '
6786: || 'BEGIN'
6787: || ' '
6788: || 'INSERT INTO cz_model_usages_tl'
6789: || cz_pb_mgr.v_db_link
6790: || ' '
6791: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
6792: || ' '

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

6789: || cz_pb_mgr.v_db_link
6790: || ' '
6791: || '(MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION)'
6792: || ' '
6793: || 'SELECT MODEL_USAGE_ID,LANGUAGE,SOURCE_LANG,DESCRIPTION FROM cz_model_usages_tl t'
6794: || ' '
6795: || 'WHERE t.model_usage_id = cz_pb_mgr.v_model_usages_tbl(i)'
6796: || ' '
6797: || 'and t.language=cz_pb_mgr.v_usages_lang_tbl(i);'

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

6808: EXCEPTION
6809: WHEN OTHERS
6810: THEN
6811: ROLLBACK;
6812: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_INSERTION_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
6813: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.USAGES', SQLCODE);
6814: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
6815: RAISE;
6816: END load_usages;

Line 13205: FROM cz_model_usages

13201: IF (TO_NUMBER(l_str) = 1)
13202: THEN
13203: SELECT NAME, model_usage_id
13204: INTO l_name, l_id
13205: FROM cz_model_usages
13206: WHERE model_usage_id = l_cnt;
13207:
13208: p_old_usage_name_to_id_map(l_cnt) := l_name;
13209: END IF;

Line 13246: l_usage_id cz_model_usages.model_usage_id%TYPE;

13242: l_previous_mask VARCHAR2(16) := v_default_eff_usg_mask;
13243: l_avail_usage_id NUMBER;
13244: l_effective_usage VARCHAR2(2000);
13245: usageid NUMBER;
13246: l_usage_id cz_model_usages.model_usage_id%TYPE;
13247: l_usage_name cz_model_usages.NAME%TYPE;
13248: l_usage_desc cz_model_usages.description%TYPE;
13249: l_index_ps_to_eff NUMBER;
13250: l_index_usage_name_to_id NUMBER;

Line 13247: l_usage_name cz_model_usages.NAME%TYPE;

13243: l_avail_usage_id NUMBER;
13244: l_effective_usage VARCHAR2(2000);
13245: usageid NUMBER;
13246: l_usage_id cz_model_usages.model_usage_id%TYPE;
13247: l_usage_name cz_model_usages.NAME%TYPE;
13248: l_usage_desc cz_model_usages.description%TYPE;
13249: l_index_ps_to_eff NUMBER;
13250: l_index_usage_name_to_id NUMBER;
13251: l_count NUMBER;

Line 13248: l_usage_desc cz_model_usages.description%TYPE;

13244: l_effective_usage VARCHAR2(2000);
13245: usageid NUMBER;
13246: l_usage_id cz_model_usages.model_usage_id%TYPE;
13247: l_usage_name cz_model_usages.NAME%TYPE;
13248: l_usage_desc cz_model_usages.description%TYPE;
13249: l_index_ps_to_eff NUMBER;
13250: l_index_usage_name_to_id NUMBER;
13251: l_count NUMBER;
13252: rec_count NUMBER := 0;

Line 13294: || 'from cz_model_usages'

13290: -- 2. usage name to new remote usage id that is commited.
13291: IF (cz_pb_mgr.g_usg_name_processed.COUNT = 0 OR (NOT cz_pb_mgr.g_usg_name_processed.EXISTS(l_usage_name))) THEN
13292: OPEN remote_usage FOR 'Select model_usage_id, name, description '
13293: || ' '
13294: || 'from cz_model_usages'
13295: || cz_pb_mgr.v_db_link
13296: || ' t'
13297: || ' '
13298: || 'where t.name = :1' USING l_usage_name;

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

13301: INTO l_usage_id, l_usage_name, l_usage_desc;
13302:
13303: IF (l_usage_id IS NULL)
13304: THEN
13305: OPEN avail_usage_cur FOR 'select min(model_usage_id) from cz_model_usages' || cz_pb_mgr.v_db_link || 'where in_use=''X''';
13306:
13307: FETCH avail_usage_cur
13308: INTO l_avail_usage_id;
13309:

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

13311: THEN
13312: --Raise migration failure.
13313: --Proposed: Usage Limit maxed out during the migration process.
13314: cz_pb_mgr.v_err_message :=
13315: cz_utils.get_text('CZDEV_MAX_USAGES_CREATED_ERR', 'TABLENAME', 'cz_model_usages', 'SQLERRM', SQLERRM);
13316: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.resolve_effective_usage_mask', SQLCODE);
13317: cz_pb_mgr.v_status_code := 0; -- MIGRATION_ERROR;
13318: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
13319: RAISE NO_DATA_FOUND;

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

13318: cz_pb_mgr.v_sql_err_msg := SUBSTR(SQLERRM, 1, 2000);
13319: RAISE NO_DATA_FOUND;
13320: ELSE
13321: l_usage_id := l_avail_usage_id;
13322: --Insert into cz_model_usages, use execute immediate
13323: l_str :=
13324: 'update cz_model_usages'
13325: || cz_pb_mgr.v_db_link
13326: || ' '

Line 13324: 'update cz_model_usages'

13320: ELSE
13321: l_usage_id := l_avail_usage_id;
13322: --Insert into cz_model_usages, use execute immediate
13323: l_str :=
13324: 'update cz_model_usages'
13325: || cz_pb_mgr.v_db_link
13326: || ' '
13327: || 'set name = :1,'
13328: || ' '