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_ITEM_TYPE_PROPERTIES

Line 1383: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';

1379: v_insertstring := v_insertstring || ' AND ' || table_name || '.' || primary_key2 || '=' || plsql_table_name2 || '(m) ';
1380: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
1381: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
1382: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
1383: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';
1384: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';
1385: v_insertstring := v_insertstring || ' WHERE PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1386: v_insertstring := v_insertstring || ' AND ITEM_TYPE_ID = ' || plsql_table_name2 || '(m); ';
1387: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';

Line 1384: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';

1380: v_insertstring := v_insertstring || ' AND deleted_flag = ''0'' ';
1381: v_insertstring := v_insertstring || ' ; IF (MOD(M,cz_pb_mgr.RECORD_COMMIT_SIZE) = 0) THEN COMMIT; END IF; ';
1382: v_insertstring := v_insertstring || ' EXCEPTION WHEN DUP_VAL_ON_INDEX THEN ';
1383: v_insertstring := v_insertstring || ' IF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_TYPE_PROPERTIES'') THEN ';
1384: v_insertstring := v_insertstring || ' UPDATE cz_item_type_properties' || cz_pb_mgr.v_db_link || ' SET DELETED_FLAG = ''0'' ';
1385: v_insertstring := v_insertstring || ' WHERE PROPERTY_ID = ' || plsql_table_name1 || '(m) ';
1386: v_insertstring := v_insertstring || ' AND ITEM_TYPE_ID = ' || plsql_table_name2 || '(m); ';
1387: v_insertstring := v_insertstring || ' ELSIF (UPPER(cz_pb_mgr.v_insert_table_name) = ''CZ_ITEM_PROPERTY_VALUES'') THEN ';
1388: v_insertstring := v_insertstring || ' UPDATE cz_item_property_values' || cz_pb_mgr.v_db_link || ' t SET ( PROPERTY_VALUE )= (SELECT PROPERTY_VALUE ';

Line 1880: insert_item_tables('cz_item_type_properties'

1876: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array2';
1877: rec_count := rec_count + 1;
1878: plsql_table_list(rec_count).col_name := 'orig_sys_ref';
1879: plsql_table_list(rec_count).table_name := 'cz_pb_mgr.mm_insert_array3';
1880: insert_item_tables('cz_item_type_properties'
1881: ,'property_id'
1882: ,'item_type_id'
1883: ,cz_pb_mgr.v_db_link
1884: ,plsql_table_list

Line 1901: || 'UPDATE cz_item_type_properties'

1897: || 'FOR I IN cz_pb_mgr.mm_insert_array2.FIRST..cz_pb_mgr.mm_insert_array2.LAST'
1898: || ' '
1899: || 'LOOP'
1900: || ' '
1901: || 'UPDATE cz_item_type_properties'
1902: || cz_pb_mgr.v_db_link
1903: || ' t'
1904: || ' '
1905: || 'SET t.orig_sys_ref = NULL'

Line 17276: || ' cz_item_type_properties'

17272: BEGIN
17273: EXECUTE IMMEDIATE 'SELECT NULL FROM cz_item_types'
17274: || cz_pb_mgr.v_db_link
17275: || 'it, '
17276: || ' cz_item_type_properties'
17277: || cz_pb_mgr.v_db_link
17278: || 'tp, '
17279: || ' cz_properties'
17280: || cz_pb_mgr.v_db_link

Line 17660: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p

17656: BEGIN
17657: SELECT property_id, data_type, name, src_application_id
17658: BULK COLLECT INTO v_remote_prop_tbl, v_prop_type_tbl, v_prop_name_tbl, v_prop_src_app_tbl
17659: FROM (SELECT itp.property_id, p.data_type, p.name, nvl(p.src_application_id, 0) AS src_application_id
17660: from cz_item_masters im, cz_item_type_properties itp, cz_ps_nodes psn, cz_properties p
17661: where psn.devl_project_id = cz_pb_mgr.v_models_to_be_exported(i) and psn.deleted_flag = '0'
17662: and psn.item_id = im.item_id AND im.deleted_flag = '0' and im.item_type_id = itp.item_type_id
17663: AND itp.deleted_flag = '0' and itp.property_id = p.property_id and p.deleted_flag = '0'
17664: UNION

Line 17733: FROM cz_item_type_properties itp, cz_properties p

17729: ,NVL(itp.orig_sys_ref, cz_pb_mgr.null_string)),NVL(itp.orig_sys_ref, cz_pb_mgr.null_string)
17730: BULK COLLECT INTO cz_pb_mgr.v_item_prop_id_ref, cz_pb_mgr.v_item_prop_type_ref
17731: ,cz_pb_mgr.v_item_prop_num_val_ref, cz_pb_mgr.v_item_prop_data_typ_ref
17732: ,v_tgt_item_type_prop_orig_ref, v_src_item_type_prop_orig_ref
17733: FROM cz_item_type_properties itp, cz_properties p
17734: WHERE itp.item_type_id = cz_pb_mgr.v_item_types_new_ref(i)
17735: AND p.deleted_flag = '0'
17736: AND itp.property_id =p.property_id
17737: AND itp.deleted_flag = '0';

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

17740: THEN
17741: NULL;
17742: WHEN OTHERS
17743: THEN
17744: cz_pb_mgr.v_err_message := cz_utils.get_text('CZ_PB_BULK_COLLECT_ERR', 'TABLENAME', 'cz_item_type_properties', 'SQLERRM', SQLERRM);
17745: cz_pb_mgr.error_msg_populate(cz_pb_mgr.v_err_message, 'cz_pb_mgr.ITEMTYPE', SQLCODE);
17746: cz_pb_mgr.v_status_code := PUBLICATION_ERROR;
17747: END;
17748: